If alpha is not provided, use 0.05 level of significance.

Please use the regression outputs provided even if they don't match your regression outputs, or they don't correspond to the data given in the previous assignment.

Consider Model 2 below. Use this regression model to test (at the 5% level of significance) if the brick premium in the East is different from the brick premium in the North.

Model 2:

A. State the null and alternative hypotheses.

B. State the p-value for this test.

C. State the statistical conclusion.

D. Communicate the results of the test in "plain English" within the context of the problem.

Considering Model 2 . Use this regression model to test (at the 5% level of significance) if the average increase in price for a 1 square foot increase in floor area is less than $320 per square foot.

A. State the null and alternative hypotheses.

B. Calculate the p-value for this test. Include the Excel function (specifying all inputs) that you used to compute this probability.

C. State the statistical conclusion.

D. Communicate the results of the test in "plain English" within the context of the problem.

Model 2: Variable: Price Medtiple Regresion for Price SYY Multiple R R-Squre Adjusted Require Std. Err. of Estimate Roms Ignored Outhers 0.9346 0.8735 0.8638 49569.26433 0 0 Degrees of Freedom Sum of Squires Mean of Squires F p Value ANOVA Table