Question: Need help with the following question, mostly E-H. Giving the selling price of the dependent variable and house size, house age and are independent variables
Need help with the following question, mostly E-H.
Giving 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). (a = 0.05)
| SUMMARY OUTPUT | ||||||||
| Regression Statistics | ||||||||
| Multiple R | 0.9571 | |||||||
| R Square | _____ | |||||||
| Adjusted R Square | 0.8932 | |||||||
| Standard Error | 6.8940 | |||||||
| Observations | _____ | |||||||
| ANOVA | ||||||||
| df | SS | MS | F | Significance F | ||||
| Regression | 3 | 5707.4385 | _____ | _____ | 3.27814E-06 | |||
| Residual | 11 | _____ | 47.5270 | |||||
| Total | _____ | 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 | _____ | 25.9171 |
| House Size | 4.1462 | 0.7512 | 5.5195 | 0.0002 | 2.4928 | 5.7995 | 2.4928 | _____ |
| House Age | -0.2361 | 0.8812 | -0.2679 | 0.7937 | -2.1756 | 1.7035 | _____ | 1.7035 |
| Area | 4.8309 | 0.9011 | 5.3612 | 0.0002 | 2.8476 | 6.8141 | 2.8476 | _____ |
| a) Write and interpret the estimated regression equation | b) What is the number of observations |
| c) What percent of the variation is explained by the regression equation, please explain. | d) What is the standard error of regression, please explain.? |
| e) What is the variance of the slope coefficient of House size? | |
| f) Conduct a global test of hypothesis to determine if any of the regression coefficients are not zero. | g) Conduct a test of hypothesis for each of the independent variables. Which one you would eliminate and why? |
| h) Interpret and show that you understand this computer printout. (Significant weight will be given to this question) |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
