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 a = 0.05.

c. Calculate the adjusted multiple coefficient of determination.AppendixLO1

Transcribed Image Text:

10 ANOVA 11 12 Regression 13 Residual 14 Total 15 16 df 55 3 102454.9381 28 61158.5619 31 163613.5000 Coefficients Standard Error 17 Intercept -652.2924 322.0966 18 SF 0.0904 0.0210 19 Age 2.0430 1.5089 20 Temp 10.8250 5.0068