Answer Happy

А A B D E F G H J 1 2 Nm 3 4 V. The data below show real estate sales for houses in a neighborhood in Biloxi, Mississippi a. What is the multiple regression equation explaining the selling price of homes based upon square footage and age? b. What are the slopes and vertical intercept values in your equation. c. Explain which of the coefficients in your estimated regression equation are statistically significant at the 5% level. 5 6 7 8 9 10 11 12 13 Age 30 40 25 18 30 30 19 14 15 16 17 18 19 20 21 Price (1000s) quare Footage 261 1712 279 1840 280 1339 288 2300 293 2234 294 1670 311 2311 328 2377 335 2736 350 2500 376 2500 399 2479 405 2400 418 3124 344 2580 455 4060 477 3900 7 10 1 3 3 1 22 23 24 w6NOwW6 25 26 27 2 10 3

SUMMARY OUTPUT 28 29 30 31 32 Regression Statistics Multiple R 0.922509049 R Square 0.851022946 Adjusted R: 0.82974051 Standard Er 26.90894048 Observatior 17 33 34 35 36 37 38 39 ANOVA df SS MS F gnificance F 2 57908.6 28954.3 39.9871 1.6E-06 14 10137.3 724.091 16 68045.9 Regression Residual Total 40 41 42 43 44 Coefficients indard Eri t Stat P-value ower 959 Joper 9591wer 95.Opper 95.0% Intercept 218.8589061 36.5784 5.98328 3.3E-05 140.406 297.312 140.406 297.312 X Variable 1 0.061185036 0.01203 5.08607 0.00017 0.03538 0.08699 0.03538 0.08699 X Variable 2 -1.729165543 0.65574 -2.637 0.01952 -3.1356 -0.3227 3.1356 -0.3227 45 46 47