# Multiple Regression - PowerPoint PPT Presentation

1 / 32

Multiple Regression. Selecting the Best Equation. Techniques for Selecting the "Best" Regression Equation. The best Regression equation is not necessarily the equation that explains most of the variance in Y (the highest R 2 ). This equation will be the one with all the variables included.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

Multiple Regression

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

## Multiple Regression

Selecting the Best Equation

### Techniques for Selecting the "Best" Regression Equation

• The best Regression equation is not necessarily the equation that explains most of the variance in Y (the highest R2).

• This equation will be the one with all the variables included.

• The best equation should also be simple and interpretable. (i.e. contain a small no. of variables).

• Simple (interpretable) & Reliable - opposing criteria.

• The best equation is a compromise between these two.

• We will discuss several strategies for selecting the best equation:

• All Possible Regressions

Uses R2, s2, Mallows Cp

• "Best Subset" Regression

Uses R2,Ra2, Mallows Cp

• Backward Elimination

• Stepwise Regression

### An Example

In this example the following four chemicals are measured:

X1 = amount of tricalcium aluminate, 3 CaO - Al2O3

X2 = amount of tricalcium silicate, 3 CaO - SiO2

X3 = amount of tetracalcium alumino ferrite, 4 CaO - Al2O3 - Fe2O3

X4 = amount of dicalcium silicate, 2 CaO - SiO2

Y = heat evolved in calories per gram of cement.

X1

X2

X3

X4

Y

7

26

6

60

79

1

29

15

52

74

11

56

8

20

104

11

31

8

47

88

7

52

6

33

96

11

55

9

22

109

3

71

17

6

103

1

31

22

44

73

2

54

18

22

93

21

47

4

26

116

1

40

23

34

84

11

66

9

12

113

10

68

8

12

109

### I All Possible Regressions

• Suppose we have the p independent variables X1, X2, ..., Xp.

• Then there are 2p subsets of variables

Variables in EquationModel

no variablesY = b0 + e

X1Y = b0 + b1 X1+ e

X2Y = b0 + b2 X2+ e

X3Y = b0 + b3 X3+ e

X1, X2Y = b0 + b1 X1+ b2 X2+ e

X1, X3Y = b0 + b1 X1+ b3 X3+ e

X2, X3 Y = b0 + b2 X2+ b3 X3+ e and

X1, X2, X3Y = b0 + b1 X1+ b2 X2+ b2 X3+ e

Use of R2

1.Assume we carry out 2p runs for each of the subsets.

Divide the Runs into the following sets

Set 0: No variables

Set 1:One independent variable.

...

Set p: p independent variables.

2. Order the runs in each set according to R2.

3. Examine the leaders in each run looking for consistent patterns

- take into account correlation between independent variables.

Example (k=4) X1, X2, X3, X4

Variables in for leading runs100 R2%

Set 1: X4.67.5 %

Set 2: X1, X2.97.9 %

X1, X497.2 %

Set 3: X1, X2, X4.98.234 %

Set 4: X1, X2, X3, X4.98.237 %

Examination of the correlation coefficients reveals a high correlation between X1, X3 (r13= -0.824) and between X2, X4 (r24= -0.973).

Best Equation Y = b0 + b1 X1+ b4 X4+ e

### Use of R2

Number of variables required, p, coincides with where R2 begins to level out

Use of the Residual Mean Square (RMS) (s2)

• When all of the variables having a non-zero effect have been included in the mode then the residual mean square is an estimate of s2.

• If "significant" variables have been left out then RMS will be biased upward.

No. of Variables

pRMS s2(p)Average s2(p)

1115.06, 82.39,1176.31, 80.35113.53

25.79*,122.71,7.48**,86.59.17.5747.00

35.35, 5.33, 5.65, 8.206.13

45.985.98

*- run X1, X2 **- run X1, X4 s2- approximately 6.

### Use of s2

Number of variables required, p, coincides with where s2 levels out

Use of Mallows Cp

• If the equation with p variables is adequate then both s2complete and RSSp/(n-p-1) will be estimating s2.

• If "significant" variables have been left out then RMS will be biased upward.

• Then

• Thus if we plot, for each run, Cp vs p and look for Cp close to p + 1 then we will be able to identify models giving a reasonable fit.

RunCpp + 1

no variables443.21

1,2,3,4202.5, 142.5, 315.2, 138.72

12,13,142.7, 198.1, 5.53

23,24,3462.4, 138.2, 22.4

123,124,134,2343.0, 3.0, 3.5, 7.54

12345.05

### Use of Cp

Cp

p

Number of variables required, p, coincides with where Cp becomes close to p + 1

### II "Best Subset" Regression

• Similar to all possible regressions.

• If p, the number of variables, is large then the number of runs , 2p, performed could be extremely large.

• In this algorithm the user supplies the value K and the algorithm identifies the best K subsets of X1, X2, ..., Xp for predicting Y.

### III Backward Elimination

• In this procedure the complete regression equation is determined containing all the variables - X1, X2, ..., Xp.

• Then variables are checked one at a time and the least significant is dropped from the model at each stage.

• The procedure is terminated when all of the variables remaining in the equation provide a significant contribution to the prediction of the dependent variable Y.

The precise algorithm proceeds as follows:

• Fit a regression equation containing all variables in the equation.

The Partial F statistic:

2.A partial F-test is computed for each of the independent variables still in the equation.

where

RSS1 = the residual sum of squares with all variables that are presently in the equation,

RSS2 = the residual sum of squares with on of the variables removed, and

MSE1 = the Mean Square for Error with all variables that are presently in the equation.

3.The lowest partial F value is compared withFafor some pre-specifieda .

If FLowest >Fathen accept the equation as it stands.

Example (k=4) (same example as before) X1, X2, X3, X4

1. X1, X2, X3, X4 in the equation.

The lowest partial F = 0.018 (X3) is compared withFa(1,8)= 3.46 for a = 0.01.

Remove X3.

2. X1, X2, X4 in the equation.

The lowest partial F = 1.86 (X4) is compared withFa(1,9) = 3.36for a= 0.01.

Remove X4.

3. X1, X2 in the equation.

Partial F for both variables X1 and X2 exceed Fa(1,10) = 3.36 for a= 0.01.

Equation is accepted as it stands.

Y = 52.58 + 1.47 X1 + 0.66 X2

Note : F to Remove = partial F.

### IV Stepwise Regression

• Variables are then checked one at a time using the partial correlation coefficient as a measure of importance in predicting the dependent variable Y.

• In this procedure the regression equation is determined containing no variables in the model.

• At each stage the variable with the highest significant partial correlation coefficient is added to the model.

• Once this has been done the partial F statistic is computed for all variables now in the model is computed to check if any of the variables previously added can now be deleted.

• This procedure is continued until no further variables can be added or deleted from the model.

• The partial correlation coefficient for a given variable is the correlation between the given variable and the response when the present independent variables in the equation are held fixed.

• It is also the correlation between the given variable and the residuals computed from fitting an equation with the present independent variables in the equation.

1. With no variables in the equation.

Example (k=4) (same example as before) X1, X2, X3, X4

The correlation of each independent variable with the dependent variable Y is computed.

The highest significant correlation ( r = -0.821)

is with variable X4.

Thus the decision is made to include X4.

Regress Y with X4

-significant thus we keep X4.

• Compute partial correlation coefficients of Y with all other independent variables given X4 in the equation.

The highest partial correlation is with the variable X1. ( [rY1.4]2 = 0.915).

Thus the decision is made to include X1.

Regress Y with X1, X4.

R2 = 0.972 , F = 176.63 .

Check to see if variables in the equation can be eliminated

For X1 the partial F value =108.22 (F0.10(1,8) = 3.46)

Retain X1.

For X4 the partial F value =154.295 (F0.10(1,8) = 3.46)

Retain X4.

• Compute partial correlation coefficients of Y with all other independent variables given X4 and X1 in the equation.

The highest partial correlation is with the variable X2. ( [rY2.14]2 = 0.358). Thus the decision is made to include X2.

Regress Y with X1, X2,X4. R2 = 0.982 .

Check to see if variables in the equation can be eliminated

Lowest partial F value =1.863 for X4 (F0.10(1,9) = 3.36)

Remove X4 leaving X1 and X2 .

### Examples

Using Statistical Packages