In an effort to explain to customers why their electricity bills have been so high lately, and how, specifically, they could save money by reducing the thermostat settings on both space heaters and water heaters, an electric utility company has collected total kW consumption figures for last year's winter months, as well as thermostat settings on space and water heaters, for 100 homes The data are recorded in columns 1(consumption),2(space),3(water) Use excel output from pictures below two answer these questions Determine the regression equation Determine the coefficient of determination, and comment about what it tells you Test whether the model is useful Predict the electricity consumption of a house whose space heater thermostat is set at 21 and whose water heater thermostat is set at 54 Estimate the average electricity consumption for houses whose space heater thermostat is set at 21 and whose water heater thermostat is set at 54 SUMMARY OUTPUT Regression Statistics Multiple R 0 840197656 R Square 0 705932101 Adjusted R Square 0 699868846 Standard Error 214 4814179 Observations 100 ANOVA SS MS F Significance F Regression 2 10711897 08 5355948 542 116 4278967 1 65848E 26 Residual 97 4462221 026 46002 27862 Total 99 15174118 11 Coefficients Standard Error t Stat P value Lower 95 Upper 95 Lower 95 0 Upper 95 0 Intercept 3867 786035 315 0630941 12 27622691 1 84114E 21 3242 473023 4493 099047 3242 473023 4493 099047 Space 163 0485562 11 78500596 13 83525445 1 10123E 24 139 6585822 186 4385302 139 6585822 186 4385302 Water 17 56149131 4 338882886 4 047468385 0 000104136 8 950010058 26 17297256 8 950010058 26 17297256 f

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 27, 2024

In an effort to explain to customers why their electricity bills have been so high lately, and how, specifically, they could save money by reducing

In an effort to explain to customers why their electricity bills have been so high lately, and how, specifically, they could save money by reducing the thermostat settings on both space heaters and water heaters, an electric utility company has collected total kW consumption figures for last year's winter months, as well as thermostat settings on space and water heaters, for 100 homes. The data are recorded in columns 1(consumption),2(space),3(water).

Use excel output from pictures below two answer these questions:

Determine the regression equation
Determine the coefficient of determination, and comment about what it tells you.
Test whether the model is useful.
Predict the electricity consumption of a house whose space heater thermostat is set at 21 and whose water heater thermostat is set at 54.
Estimate the average electricity consumption for houses whose space heater thermostat is set at 21 and whose water heater thermostat is set at 54.

SUMMARY OUTPUT Regression Statistics Multiple R 0.840197656 R Square 0.705932101 Adjusted R Square 0.699868846 Standard Error 214.4814179 Observations 100 ANOVA SS MS F Significance F Regression 2 10711897.08 5355948.542 116.4278967 1.65848E-26 Residual 97 4462221.026 46002.27862 Total 99 15174118.11 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 3867.786035 315.0630941 12.27622691 1.84114E-21 3242.473023 4493.099047 3242.473023 4493.099047 Space 163.0485562 11.78500596 13.83525445 1. 10123E-24 139.6585822 186.4385302 139.6585822 186.4385302 Water 17.56149131 4.338882886 4.047468385 0.000104136 8.950010058 26.17297256 8.950010058 26.17297256\f