automatic thumbs down if answer is copy and pasted

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), sarft (size of house, in square feet), bdrms (number of bedrooms), colonial (a dummy variable coded 1 if house is colonial style and otherwise). The Excel output for the following model (Model 1) was given below. Model 1: price = Bo + Bilotsize + Basqrft + B3bdrms + Bacolonial + ANOVA df SS MS F 620279 Regression Residual Total 83 87 917855 Coefficients Standard Error t Stat P-value -24.127 29.603 -0.815 0.417 0.002 0.001 3.230 0.002 Intercept lotsize sarft bdrms colonial 0.124 0.013 9.314 0.000 11.004 9.515 1.156 0.251 13.716 14.637 Use Model 1 to answer parts a-e. a. Interpret the coefficient of the variable "colonial". Question 35 2.5 pts d-(1). 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 - (). What is the p-value? Op value is between 0.05 to 0.1 Op value is less than 0.01 O p-value is between 0.025 to 0.05 O p-value is between 0.01 to 0.025 Question 37 2 pts d-(iii). Find the critical value. Question 38 1.5 pts d - (iv). What is your conclusion? Do not reject Ho. The regression relationship is significant. O Reject Ho. The regression relationship is not significant Do not reject Ho. The regression relationship is not significant. O Reject Ho. The regression relationship is significant Question 39 3 pts e-(1). Conduct at 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-(i). Find the p-value and state your conclusion. O 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. 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. O 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. Op-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