What follows is Excel output from a regression model to predict y using x1, x2, x21, x22, and the interaction term, x1x2. Comment on the overall strength of the model and the significance of each predictor. The data follow the Excel output. Develop a regression model with the same independent variables as the first model but without the interaction variable. Compare this model to the model withinteraction.

Transcribed Image Text:

SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.954 0.910 0.878 7.544 20 ANOVA df MS Significance F 8089.275 796.725 8886.000 1617.855 28.43 0.00000073 Regression Residual Total 56.909 Coefficients Standard Errort Stat P-value 503.0955 Intercept X1 X2 X1Sq X2Sq X1*X2 464.4433 -10.5101 -1.2212 0.0357 -0.0002 0.0243 0.92 6.0074 1.75 -0.62 1.84 -0.08 2.28 1.9791 0.0195 0.0021 0.0107 0.3716 0.1021 0.5471 0.0876 0.9394 0.0390 x2 34 120 190 45 96 245 56 105 240 34 79 288 78 108 238 2366 312 90 110 250 8988 315 78 255 76 80 320 98 230 56 73 335 89266 43 69335 92 270 2375 250 95 272 45 63 372 85288 56 74360 23 34 45 67 78 65