1
$\begingroup$

I have multiple independent variables and multiple dependent variables, some categorical and some quantitative. I have created a data sheet with dummy columns appropriate to each categorical variable.

My team and I have ran various tests with our data, including Multivariate Multiple Regression, and will need to re-do all of them in light of a multicolinearity test that will surely eliminate some variables. This is our last step before writing up a manuscript, so all and any help is deeply appreciated.

I have access to SPSS, SAS and R (though no experience with R). Multicolinearity tests are simple enough for multiple regression with SPSS, but I'm lost when it comes to multiple multivariate regression.

Any suggestions for how to test for multicolinearity for multivariate multiple regression?

Here is a link to some of our data:

https://docs.google.com/spreadsheets/d/1nTBcGgBl99Wb5bAjzY2j26W-vkAE-rKRvisbB-CMFGs/edit?usp=sharing

Our dependent variables are the columns labeled with names of academic fields, all on the left-most side. Our independent variables are the columns to the right of those, from "Major Fields" to "Average ACT." To the right of that are the columns for the dummy variables. I've color coded the dummy columns to the variable to which they correspond.

$\endgroup$
0
$\begingroup$

You can perform a Principal Component Analysis (PCA) based on the correlation matrix of your continuous variables. PCA is a method of dimension reduction and hence it is usually applied to reduce the number of collinear variables, like in your case. Many softwares, such as PC-ORD, can perform it. But, I am not sure that you can do correlation analyses with your categorical or nominal variables at the same time. However, you can get some ideas on how to handle these nominal variables after you have reduced some of collinear continuous variables through PCA.

$\endgroup$
  • $\begingroup$ Ah, I should of mentioned. We have done PCA analysis to two components. My statistician, however, thinks we still need to do some other multicolinearity test. $\endgroup$ – philosonista Jun 6 '16 at 15:44
0
$\begingroup$

I have used the vif function from the car package in R to obtain the Variance Inflation Factor (VIF), which is a measure of multi-collinearity. You should be able to do the same with your multivariate analysis. Basically, once you obtain your multivariate model, you'll need to load the car package, simply write vif(name_of_your_model) in R and you'll obtain the VIF for each of your explanatory variable. Note that according to Zuur et al. (2009) Mixed Effects Models and Extensions in Ecology with R, if a predictor variable as a VIF ­> 5 it means that there's a multi-collinearity issue. You would have to exclude the predictor variable with the highest VIF, redo the vif test on the updated model and repeat these steps until all your predictor variables have a VIF < 5.

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.