The average cost (COST) of heating a home is a function of o…
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) 12.1 4.012 The observed or computed t-value for the independent variable AGE is: