Question: The average cost (COST) of heating a home is a function of outside Temperature (TEMP), thickness of Insulation (INSUL) and Age of furnace (AGE). Data

The average cost (COST) of heating a home is a function of outside Temperature (TEMP), thickness of Insulation (INSUL) and Age of furnace (AGE). Data is collected on these variables and a regression analysis is done on the data. An incomplete MS Excel output is shown below. Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA df SS MS F Signifcance F Regression 171220 Residual Total 19 212916 Coefficients Standard Error t Stat P-Value Lower 95% Intercept 427 59.6 7.17 TEMPT (X1) 0.7723 -5.93 INSUL (X2) -14.8 4.754 AGE (X3) 6.1 4.012

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!