ESTABLISHING THE RELATIVE CONTRIBUTIONS OF VARIABLES

 

Defining the Model

 

Ŷ = a + b1X1 + b2X2 + … + bpXp for a total of ‘p’ terms

 

 

 

 

Testing for Multi-Collinearity

 

1. Bivarite Correlation Matrix (the quick-and-dirty approach)

 

Step 1: create a matrix of bivariate correlations, where every variable (Y, X1,…Xp) is paired with every other variable

 

Note: ‘total’ linear correlations are standard but it would be better to use either ‘total’ quadratic correlations or ‘partial’ linear correlations

 

Step 2: predictor variables with correlations > 0.80 are highly intercorrelated; select for the model the one predictor variable with the highest correlation with Y

 

2. Multiple Linear Regressions (the more statistically sound approach)

 

Step 1: regress each predictor variable on the linear combination of all other predictor variables

 

            Given Ŷ = f(X1, X2, X3, X4)

 

            Find X1 = f(X2, X3, X4) and R1

                    X2 = f(X1, X3, X4) and R2

                    X3 = f(X1, X2, X4) and R3

                    X4 = f(X1, X2, X3) and R4

 

Step 2: if any R > 0.8 then remove the one variable corresponding to the highest R (i.e., if Rk is highest, remove Xk)

 

            Step 3: repeat step 2 recursively until no R > 0.8

 

 

Determining Variable Contributions

 

Step 1: perform multivariate regression analysis using the reduced set of predictor variables (i.e., those for which no multi-collinearity exists)

 

Step 2: calculate the ‘Standardized Partial Regression Coefficients’ (a.k.a. ‘Beta Weights, Bk)

 

                        for bk•Xk,  Bk = │bk│• (SXk / SY)

 

the Bk is proportional to the contribution of predictor variable Xk to the regression of the response variable

 

Note 1: if the predictor variables were standardized prior to Step 1 (i.e., Xk is replaced by Xk where Xk = (Xk – Xmean) / SX) then

 

                        │bk│ = Bk

 

            Note 2: if all intercorrelations among predictor variables equal zero then

 

                        Bk = rYXk