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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started