Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A multiple regression was run with Y as the dependent variable and X1, X2, and X3 as explanatory variables. In addition, a dummy variable was
A multiple regression was run with Y as the dependent variable and X1, X2, and X3 as explanatory variables. In addition, a dummy variable was added that equals 1 for men and 0 for women. The output is provided below: SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Regression Residual Total Intercept X1 X2 X3 D 0.8530 0.7277 0.7218 1.6801 192 df 4 187 191 SS 2.577 -0.001 0.291 -0.372 -1.451 1410.326 527.854 1938.180 Coefficients Standard Error 2.003 0.000 0.041 0.047 0.558 MS 352.581 2.823 t Stat 1.287 -2.391 7.150 -7.855 -2.601 F 124.907 P-value 0.200 0.018 0.203 0.008 0.010 Significance F 1.05389E-51 Lower 95% -1.374 -0.002 0.211 -0.465 -2.551 Upper 95% 6.527 0.000 0.371 -0.278 -0.351 No work needs to be shown, but the following information should be provided:
a. What is the multiple regression equation? b. Using this equation, what is the predicted value of Y when X1 = X2 = X3 = 10 and D=0
c. What is the value of R^2, SSE, and se?
d. What variables are not important (use a 0.05 level of significance)?
e. What is the dummy variable telling us?
f. Is this a good or bad model at the 0.05 level? Explain.
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