What follows is Excel output from a regression model to predict y using x1, x2, x21, x22, and the interaction term, x1 x2. 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 Significance df MS 8089.274577 796.725 8886 0.00000073 Regression Residual Total 1617.855 28.43 56.909 19 Coefficients Standard Error t Stat P-value 464.4433 -10.5101 -1.2212 0.0357 -0.0002 0.0243 0.92 -1.75 1.9791 -0.62 1.84 0.0021 -0.08 2.28 0.3716 0.1021 0.5471 0.0876 0.9394 0.0390 Intercept 503.0955 6.0074 0.0195 0.0107 X1Sq 34 120 190 45 96 245 56 105 240 34 79 288 78 108 238 23 66 312 90 110 250 89 88 315 23 34 45 67 78 65 78 255 76 80 320 98 230 56 73 335 89 266 43 69 335 92 270 23 75 250 95 272 45 63 372 85 288 56 74 360