Delmarva Power is a utility company that would like to predict the monthly heating bill for a household in Kent County during the month of January. A random sample of households in the county was selected and their January heating bill recorded along with the following variables: SF: the square footage of the house Age: the age of the current heating system in years Temp: the thermostat setting, in degrees Fahrenheit, during the day The following figure shows the regression output from Excel.

a. Calculate the multiple coefficient of determination.

b. Test the significance of the overall regression model using α = 0.05.

c. Calculate the adjusted multiple coefficient of determination.

Transcribed Image Text:

O ANOVA 12 Regressicn 102454.9381 61158 5619 31 163613.5000 Coeffcients Standard Error 7 Intercept 18 SF 19 Age 652.2924 0.0904 2.0430 10.8250 322.0966 0.0210 15089