Please help as much as you can. THANK YOU!!!!! :)
A real estate investor would like to develop a regression model to predict the price of a house based on its characteristics (size, number of bedrooms, style, and so on), and collected data on 88 houses sold in Portland, Oregon, during the period March 2018 to November 2018. The variables include price (house price in thousands of dollars), lotsize (size of the lot, in square feet), sqrft (size of house, in square feet), bdrms (number of bedrooms), colonial (a dummy variable coded 1 if house is colonial style and 0 otherwise). The Excel output for the following model (Model 1) was given below. Model 1: price = Bo + Bilotsize + Bysqrft + B3barms + BAcolonial + E ANOVA df SS MS F Regression 620279 Residual 83 Total 87 917855 Coefficients Standard Error t Stat P-value Intercept -24.127 29.603 -0.815 0.417 lotsize 0.002 0.001 3.230 0.002 sqrft 0.124 0.013 9.314 0.000 bdrms 11.004 9.515 1.156 0.251 colonial 13.716 14.637 Use Model 1 to answer parts a - e.c. Compute adjusted coefficient of determination (Ra) 66.43% 66.02% 65.81% 66.29% Question 35 2.5 pts d - (i). Conduct an F test to determine the overall significance of the relationship. Use a = 0.05. Compute the test statistic value. Question 36 2 pts d - (ii). What is the p-value? Op-value is between 0.01 to 0.025 Op-value is between 0.05 to 0.1 O p-value is less than 0.01 Op-value is between 0.025 to 0.05Question 37 2 pts d - (iii). Find the critical value. Question 38 1.5 pts d - (iv). What is your conclusion? Reject Ho. The regression relationship is significant. Do not reject Ho. The regression relationship is significant. Reject Ho. The regression relationship is not significant. Do not reject Ho. The regression relationship is not significant. Question 39 3 pts e - (i). Conduct a t test to determine whether the price for a house of colonial style is, on average, $49,000 higher than the price for a house of another style after controlling for lot size, house size, and number of bedrooms. Use a 0.05 level of significance. Compute the test statistic value.Question 40 3 pts e - (ii). Find the p-value and state your conclusion. A p-value is between 0.005 and 0.01; The price for a house of colonial style is, on average, $49,000 higher than the price for a house of another style. A p-value is between 0.01 to 0.02; The price for a house of colonial style is not, on average, $49,000 higher than the price for a house of another style. /'\\ p-value is between 0.01 to 0.02; The price for a house of colonial style is, on average, $49,000 higher than the price for a house of another style. A p-value is between 0.005 and 0.01; The price for a house of colonial style is not, on average, $49,000 higher than the price for a house of another style
