Please show the work by hand In a town, a sample of 24 recently sold houses is collected. We would like to predict the saleprice in $/10000 (Y) using the size of the home in sq. ft./1000 (X,) and the number ofrooms (X2) as predictor variables. The data is shown in the house.csv file.YXX,29.51.5...25.90.9987a) Fit the model Y = Bo + B,X, + B,X2 + e to the house price data, and give the least%3Dsquares function.b) Find the value of SSE that is minimized by the least squares method.c) Estimate o, the standard deviation of ed) Conduct the ANOVA F-test for model usefulness at the a = 0.05 significance level (besure to specify the null and alternative hypotheses).e) Conduct the individual t-tests for B, and B, at the a = 0.05 significance level (be sure tospecify the null and alternative hypotheses).f) Find and interpret the coefficient of determination R2, and the adjusted coefficient ofdetermination R.g) Which model do you think would be best: a simple linear regression with X, as thepredictor variable, a simple linear regression with X, as the predictor variable, or thefirst-order multiple regression model with both X, and X,?h) Using the chosen model from part g), predict the sale price for a 1000 square foothouse with 6 rooms. Give a 95% prediction interval for this estimate. A1fx PrizeAB.CPrizeSizeRooms29.51.527.91.17525.91.232629.91.12129.90.988630.91.2478.28.91.5016.35.91.2251031.51.552310.9751230.91.1216.13301.021436.91.66481541.91.48871640.51.37661743.91.571837.51.25661937.91.696.2044.51.828.2137.91.6526.2238.91.77782336.91.50472445.81.83182525.90.9982627282930Re3132333435house(1) (1)766.1.12345 67

Name: Please show the work by hand In a town, a sample of 24 recently sold h
Uploaded: 2024-03-20T07:07:37.000Z
Channel: Bartleby
Description: Please show the work by hand In a town, a sample of 24 recently sold houses is collected. We would like to predict the saleprice in $/10000 (Y) using the size of the home in sq. ft./1000 (X,) and the number ofrooms (X2) as predictor variables. The da