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 diff erences.

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