Given here is Excel output for a multiple regression model that was developed to predict y from two independent variables, x1 and x2.Variablex2is a dummy variable. Discuss the strength of the multiple regression models 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.

Transcribed Image Text:

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