Regression Figure 5 shows Excel output estimating the follow

Regression

Figure 5 shows Excel output estimating the following model: HousingPrice-80-B1Acres-B2SqFeet-p3CentralAir Where, HousingPrice = the price of a home in dollars. Acres = the number of acres on the lot, SqFeet-square footage of the home and CentralAir-dummy variable that is 1 if the home has AC and 0 if it does not. Using this information answer questions 16-18 SUMMARY OUTPUT ressin Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.646644032 0418148504 0.309051348 12321.10463 20 ANOVA df MS Significance F Regression Residual Total 3 1745571591 581857197 3.832808485 0.030422865 16 2428953909 151809619.3 19 41745255D0 P-value Lower 95% Upper 95% Coefficients Standard Errot Staf 36045.02154 14539.25779 2479151416 0.024687239 5223.17211 66866.87096 Intercept Acres SqFeet CentralAir 15662.9033 5715.898484 2.740234689 0.014522601 3545.739898 27780.06671 10.87526606 4.959248807 2.192926082 0.043437915 0.362128299 21.38840381 4181.D89465 5652 117044 0.73973B656 0.470174074-7B00.B63328 16163.04226 Figure 5 16. Choose the best answer a. The regression equation IS significant at the .05 level b. NONE of the individual coefficients are significant at the.05 level C. 41.8% ofthe variation in housing price is explained by the regression equation d. The dummy variable CenteralAir DOES have a significant effect on housing price at the 05 level e. Both a. and c. are correct

Solution

16) Option e

17) OPtion b

18) Option a