Question

Attie Age Outside Insulation Furnace Square Avg Heating of Temp (inches) (years) Footage Cost Avg Heating Cost 48564s+381 96 350 | 300
M2_A2. Western Home Inspections is a home inspection service that provides prospective homebuyers with a thorough assessment of the major systems in a house prior to the execution of the purchase contract. Prospective homebuyers often ask the company for an estimate of the heating cost of the home during the winter. To answer this question, the company wants to build a regression model to help predict the average monthly heating cost (Y) as a function of the average outside temperature in the winter (X1), the amount of attic insulation in the house (X2), the age of the furnace in the house (X3), and the size of the house measured in square feet (X4). Data on 20 homes has been recorded and is shown in Worksheet A2. The company wants to build a regression model to estimate the average monthly heating cost based on outside temperature, attic insulation, age of the furnace, and size of the house. (Note: I have made some modifications to this problem since creating the supporting video- although it shows a different problem number it is the solution for this problem) average monthly a) Prepare a scatter plot showing the relationship between the heating cost and each of the independent variables If the home inspector wanted to build a regression model using only one independent variable to predict heating cost, which variable should be used? Why? How do you use the value of Significance F in the model with only one independent variable? If the home inspector wanted to build a regression model using two independent variable to predict heating cost, which variable should be added to the model? Why? If the home inspector wanted to build a regression model using three independent variable to predict heating cost, which variable should be added to the two variable model? Why? If the home inspector wanted to build a regression model using four independent variable to predict heating cost, which variable should be added to the three variable model? Why? How do you use the value of Significance F in the model with more than one independent variable? b) c) d) e) f) g) h) i) j) k) I) Does there appear to be any multicollinearity among the independent variables? m) How can you tell if you have multicollinearity? n) Which sets of variables indicate multicollinearity o) Based on your best model, what is the expected average monthly heating cost for a home which has an average outside temperature of 45, 8 inches of attic insulation, a 7 year old furnace, and is 2000 square foot?
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Ans)

a) scatter plot

1) average outside temp

50 60 40 Activate Windows 10 20 30 ettings to activate Windows avg outside temp2) attic insulation

0 2 4 10 Activate Windows attic insultaion Settings to activate Windows3) age of furnace

1 8) 0 8 12 Activate Windows 4 6 100 14 age of furñace Settings to activate Windows.4) square footage

EN 1500 2000 2500 Activate Windows square footage Settings to activate Windowsseturse .fectege seold Lestested a lte 1rderen erd d e pandent wat alle hedngco sh as seen only .taka pe orfeoOon vorculaa.仆仆 meaning F-vake.fm the ndepindnt veofeta?づ t) this is because shte secn mosh rnet)

Add a comment
Know the answer?
Add Answer to:
Attie Age Outside Insulation Furnace Square Avg Heating of Temp (inches) (years) Footage Cost Avg Heating...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Attic Age of Avg Outside Insulation Furnace Square Avg Heating (inches) (years) Footage Cost Temp 6 291 230 1300 2100 3...

    Attic Age of Avg Outside Insulation Furnace Square Avg Heating (inches) (years) Footage Cost Temp 6 291 230 1300 2100 36 2400 360 2300 164 36 2 8 1300 42 2300 2 271 57 1400 2 2 187 2100 235 2 138 53 47 398 14 319 2600 estern Home Inspections is a home inspection service that provides prospective homebuyers with a thorough assessment of the major systems in a house prior to the execution of the purchase contract. Prospective...

  • Western Home Inspections is a home inspection service that provides prospective homebuyers with a thorough assessment...

    Western Home Inspections is a home inspection service that provides prospective homebuyers with a thorough assessment of the major systems in a house prior to the execution of the purchase contract. Prospective homebuyers often ask the company for an estimate of the average monthly heating cost of the home during the winter. To answer this question, the company wants to build a regression model to help predict the average monthly heating cost (Y) as a function of the average outside...

  • Heating Cost Sy Outside Temp Ideal Attle Insalatice inches) 2 Age of Furnace years) x3 The...

    Heating Cost Sy Outside Temp Ideal Attle Insalatice inches) 2 Age of Furnace years) x3 The following data points were collected at random from a sample of 10 recently sold homes. What is the estimated heating cost for a home if; the mean outside temperature is 32 degrees, there are 7 inches of insulation, and the furnace is 7 years old? 10 165 36 200

  • Use the following information to answer the questions below: Heat Power is a utility company that...

    Use the following information to answer the questions below: Heat Power is a utility company that would like to predict the monthly heating bill for a household in a particular region during the month of January. A random sample of 18 households in the region were selected and their January heating bill recorded. The data is shown in the table below along with the square footage of the house (SF), the age of the heating system in years (Age), and...

  • One of the biggest factors in determining the value of a home is the square footage....

    One of the biggest factors in determining the value of a home is the square footage. The accompanying data represent the square footage and selling price​ (in thousands of​dollars) for a random sample of homes for sale in a certain region. Complete all parts below (A.) Which variable is the explanatory variable? a. selling price b. square footage Square Footage, x Selling Price ($000s), y 2221 382.7 3046 353.4 1175 197.2 1938 332.2 3166 630.2 2857    383.9 4086 623.6...

  • What is the relationship between the assessed value of houses and heating area of those houses?...

    What is the relationship between the assessed value of houses and heating area of those houses? The file "House2", which is available in a separate item on this Blackboard page, contains the assessed value (in thousands of $) for a house and the square footage of heating area (in thousands of sq. ft.). Using Excel create a simple linear regression to predict the value of a house using the square footage of heated area as the independent variable (in appropriate...

  • Develop a multiple linear regression model to predict the fair market value based on land area of the property and age, in years. Fair Market Value($000) Property Size (acres) Age House Size (s...

    Develop a multiple linear regression model to predict the fair market value based on land area of the property and age, in years. Fair Market Value($000) Property Size (acres) Age House Size (square feet) 522.9 0.2297 56 2448 425.0 0.2192 61 1942 539.2 0.1630 39 2073 628.2 0.4608 28 2707 490.4 0.2549 56 2042 487.7 0.2290 98 2089 370.3 0.1808 58 1433 777.9 0.5015 17 2991 347.1 0.2229 62 1008 756.8 0.1300 25 3202 389.0 0.1763 64 2230 889.0 1.3100...

  • Obs Salary Avg Perf. Years Jobs 1 48.20 3.50 9 6 2 55.30 5.30 20 6...

    Obs Salary Avg Perf. Years Jobs 1 48.20 3.50 9 6 2 55.30 5.30 20 6 3 53.70 5.10 18 7 4 61.80 5.80 33 7 5 56.40 4.20 31 8 6 52.50 6.00 13 6 7 54.00 6.80 25 6 8 55.70 5.50 30 4 9 45.10 3.10 5 6 10 67.90 7.20 47 8 11 53.20 4.50 25 5 12 46.80 4.90 11 6 13 58.30 8.00 23 8 14 59.10 6.50 35 7 15 57.80 6.60 39...

  • Heat Power is a utility company that would like to predict the monthly heating bill for...

    Heat Power is a utility company that would like to predict the monthly heating bill for a household in a particular region during the month of January. A random sample of 18 households in the region were selected and their January heating bill recorded. The data is shown in the table below along with the square footage of the house (SF), the age of the heating system in years (Age), and the type of heating system (Type: heat pump =...

  • 4. An agent for a residential real estate company in a suburb located outside a major...

    4. An agent for a residential real estate company in a suburb located outside a major city has the business objective of developing more accurate estimates of the monthly rental cost for apartments. Toward the goal, the agent would like to use the size of an apartment, as defined by square footage to predict the monthly rental cost. The agent selects a sample of 8 one-bedroom apartments and the data are shown. Complete parts (a) through (f). Monthly Rent ($)...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT