Question: 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

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.

What follows is Excel output from a regression model to

Compare this model to the model withinteraction.

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

Step by Step Solution

3.37 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The F value shows very strong overall significance with a p v... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

243-M-S-L-R (435).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!