Question: Shown below is output from two Excel regression analyses on the same problem. The first output was done on a full model. In the second

Shown below is output from two Excel regression analyses on the same problem. The first output was done on a “full” model. In the second output, the variable with the smallest absolute t value has been removed, and the regression has been rerun like a second step of a backward elimination process. Examine the two outputs. Explain what happened, what the results mean, and what might happen in a third step.FULL MODEL Regression Statistics Multiple R 0.567 R Square 0.321 Adjusted R

Square 0.208 Standard Error 159.681 Observations 29 ANOVA Significance F df SS

FULL MODEL Regression Statistics Multiple R 0.567 R Square 0.321 Adjusted R Square 0.208 Standard Error 159.681 Observations 29 ANOVA Significance F df SS MS F Regression 4 289856.08 Residual 24 611955.23 72464.02 25498.13 2.84 0.046 Total 28 901811.31 Coefficients Standard Error t Stat P-value Intercept 336.79 124.0800 2.71 0.012 X 1.65 1.7800 0.93 0.363 X2 -5.63 13.4700 -0.42 0.680 X3 0.26 1.6800 0.16 0.878 185.50 66.2200 2.80 0.010

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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

Students Have Also Explored These Related Business Statistics Questions!