Giving the selling price of the dependent variable and house size, house age and are independent variables please fill in...
jxuygie05Giving the selling price of the dependent variable and house size, house age and are independent variables please fill in the table and answer the following questions (a-h). (
SUMMARY OUTPUT | ||||||||
Regression Statistics | ||||||||
Multiple R | 0.9571 | |||||||
R Square | .91604 | |||||||
Adjusted R Square | 0.8932 | |||||||
Standard Error | 6.8940 | |||||||
Observations | 15 | |||||||
ANOVA | ||||||||
| df | SS | MS | F | Significance F | |||
Regression | 3 | 5707.4385 | 1902.4495 | 40.0288 | 3.27814E-06 | |||
Residual | 11 | 522.797 | 47.5270 | |||||
Total | 14 | 6230.2360 |
|
|
| |||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% |
Intercept | -16.0580 | 19.0710 | -0.8420 | 0.4177 | -58.0331 | 25.9171 | -58.0331 | 25.9171 |
House Size | 4.1462 | 0.7512 | 5.5195 | 0.0002 | 2.4928 | 5.7995 | 2.4928 | 5.7995 |
House Age | -0.2361 | 0.8812 | -0.2679 | 0.7937 | -2.1756 | 1.7035 | -2.1756 | 1.7035 |
Area | 4.8309 | 0.9011 | 5.3612 | 0.0002 | 2.8476 | 6.8141 | 2.8476 | 6.8141 |
-What is the variance of the slope coefficient of House size?
-Conduct a global test of the hypothesis to determine if any of the regression coefficients are not zero.
-Conduct a test of hypothesis for each of the independent variables. Which one would you eliminate and why?
10 years ago
5
Purchase the answer to view it
regression_analysis.doc
