a 2131 b 2145 c 2179 d 2201 SUMMARY OUTPUT Rearession Statis

a) 2.131

b) 2.145

c) 2.179

d) 2.201

SUMMARY OUTPUT Rearession Statistics MultipleR R Square Adjusted R Square Standard Error Observations 0.8486 36,009.01 ANOVA Significance F 0.0022 MS Regression Residual Total 36,709,265,905.70 14 50,972,400,000.00 Coefficients Standard Error t Stat P- Lower 95% Upper 95% Intercept Age Living Area Bedrooms 108,597.3721 580.6870 86.8282 31,261.9127 101,922.3333 2,092.4981 27.6994 11,006.8696 value 0.3095 0.7865 0.0095 0.0161

Solution

We have given that the regression output and ANOVA table.

= 0.05

We have to find critical value to test the significance of the regression coefficients.

We test regression coefficient by using t-test.

This we can done by using EXCEL.

In the ANOVA table we see degrees of freedom for total are 14.

degrees of freedom for total are n - 1.

So n - 1 = 14

n = 14 + 1 = 15

Therefore, total observations are 15.

EXCEL syntax for critical value is,

=TINV(probability, deg_freedom)

where, probability =

and deg_freedom = degrees of freedom for total = 14

critical value = 2.145

Option b) is correct.