You are required to show all necessary calculations in order to earn full points. Each student is expected to conform to a strict standard of academic honesty. Cheating on examination, plagiarism, unauthorized collaboration with others is not allowed and carry serious penalty. Question 1 Jennifer Stance is contemplating the purchase of a home. One of her primary concerns is how well the home will maintain its value. In particular, she is wondering how certain options affect the home's resale value. Jennifer is interested in the condition of the home - (excellent, good, and mint), its price, the age, and the lot size (SF). To get a home that meets her expectation, Jennifer contacted an old high school friend that works at a real estate company. He agreed to provide her with data on all homes in her preferred location. She used the data to estimate the relationship between the sales price and four independent variables shown below. Round answers to 3 decimal places. SUMMARY OUTPUT Regression Statistics Multiple R 0.922247934 R Square 0.850541251 Adjusted R Square 0.765136252 Standard Error 16817.63625 Observations 12 ANOVA df F 9.958916 Significance F 0.005133 SS MS 1.13E+10 2.82E+09 1.98E+09 2.83E+08 1.32E+10 4 Regression Residual Total 7 11 tercept Standard Error 24512.18 10.15869 865.3645 16465.69 14775.72 Coefficients 126941.3065 54. 20838558 -3962.88794 30981.07379 46573.77079 (Exc.) Mint) t Stat P-value Lower 95% 5.178703 0.001283 68979.21 5.336158 0.00108 30.18689 -4.57944 0.002545 -6009.15 1.881554 0.101933 -7954.09 3.152047 0.016106 11634.74 You are required to show all necessary calculations in order to earn full points. Each student is expected to conform to a strict standard of academic honesty. Cheating on examination, plagiarism, unauthorized collaboration with others is not allowed and carry serious penalty. Question 1 Jennifer Stance is contemplating the purchase of a home. One of her primary concerns is how well the home will maintain its value. In particular, she is wondering how certain options affect the home's resale value. Jennifer is interested in the condition of the home - (excellent, good, and mint), its price, the age, and the lot size (SF). To get a home that meets her expectation, Jennifer contacted an old high school friend that works at a real estate company. He agreed to provide her with data on all homes in her preferred location. She used the data to estimate the relationship between the sales price and four independent variables shown below. Round answers to 3 decimal places. SUMMARY OUTPUT Regression Statistics Multiple R 0.922247934 R Square 0.850541251 Adjusted R Square 0.765136252 Standard Error 16817.63625 Observations 12 ANOVA df F 9.958916 Significance F 0.005133 SS MS 1.13E+10 2.82E+09 1.98E+09 2.83E+08 1.32E+10 4 Regression Residual Total 7 11 tercept Standard Error 24512.18 10.15869 865.3645 16465.69 14775.72 Coefficients 126941.3065 54. 20838558 -3962.88794 30981.07379 46573.77079 (Exc.) Mint) t Stat P-value Lower 95% 5.178703 0.001283 68979.21 5.336158 0.00108 30.18689 -4.57944 0.002545 -6009.15 1.881554 0.101933 -7954.09 3.152047 0.016106 11634.74