Given here is Excel output for a multiple regression model that was developed to

Question

Given here is Excel output for a multiple regression model that was developed to predict y from two independent variables, x1 and x2. Variable x2 is a dummy variable. Discuss the strength of the multiple regression model on the basis of the output. Focus on the contribution of the dummy variable. Plot x1 and y with x2 as 0, and then plot x1 and y with x2 as 1. Compare the two lines and discuss the differences.

(Round your answer to 3 decimal places.)

The presence of x2 causes the y intercept to drop by...

SUMMARY OUTPUT Regression Statistics Multiple R 0.623 R Square 0.388 0.341 Adjusted R Square 11.744 Standard Error Observations ANOVA df Significance F 2270.11 1135.05 8.23 0.0017 Regression Residual 26 137.91 3585.75 Total 28 5855.86 P-value Coefficients Standard Error t Stat Intercept 41.225 6.380 6.46 0.00000076 1.353 0.80 0.4316 1.081 4.5470 -4.05 0.0004. 18.404

Explanation / Answer

For the given Regression Output;

The Presence of X2 causes the Y intercept to drop by 18.404 units.

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.