Excel Notes - STEPWISE REGRESSION

# Excel Notes - STEPWISE REGRESSION - STEPWISE REGRESSION...

This preview shows pages 1–2. Sign up to view the full content.

STEPWISE REGRESSION Begin by performing a normal multiple regression. If all variables are shown as significant (P-values < α ), then STOP -- the complete model is good. But if Significance F is low, but one or more of the p-values for the t- tests are high, forward stepwise regression can be used to develop the best model that contains some of the variables as follows. STEP 1. Do simple linear regressions of y vs. each x variable individually. Select the x variable with the lowest p-value. (Suppose it is X 3 .) Step 2: Do all possible 2-variable regressions in which one of the two variables is X 3 . If none of the 2-variable regressions gives low p-values for both X 3 and the other variable -- STOP -- use the model utilizing only X 3 . If one or more of the 2-variable models gives low p-values for both X 3 and the second variable, select the model with the lowest p-values. (Suppose it is the one with X 3 and X 5 .) --- GO TO STEP 3.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 6

Excel Notes - STEPWISE REGRESSION - STEPWISE REGRESSION...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online