I have a Box-Cox regression where the explanatory variables are almost all dummy variables. If I want to see if there is multicollinearity among them, what would be an appropriate test? Do variance inflation factor (VIF) tests work here? What about the Pearson correlation coefficient matrix?
1 Answer
The VIF is probably the best way to go here. The Pearson correlation will give you a lousy measure here because it behaves somewhat weirdly for categorical variables like this. Another possibility is to use a matrix of a different measure like cosine similarity: $\sum x_i*x_j / \sqrt{\sum x_i^2 * \sum x_j^2}$. I think that is equivalent to Spearman's Rho or Kendall's Tau but am not sure off the top of my head.
I'd stick to the VIF though because it will tell you for each variable whether the other variables combined are highly colinear. But if you want a visual diagnostic of which pairwise variables are similar, those other metrics are better than Pearson for categorical data.
----EDIT---
Sure. This has to do primarily with the fact that Pearson's correlation can swing up or down or go negative very easily. Here's an example:
> cor(c(0,1,1,1,0,1,0,1,0),c(1,1,0,1,1,0,1,1,0))
[1] -0.1581139
> cor(c(0,1,1,1,0,1,0,1,0),c(0,1,0,1,1,0,1,1,0))
[1] 0.1
Here, by changing just one of the entries to zero we have swung the correlation from positive to negative. But the VIF uses $1/(1-R_{i}^2)$ where the $R_{i}^2$ is for the regression of the other variables on the one in question. I would have to work it out but I think that is basically a linear combination of something similar to the cosine measure I posted above, or a transform of it. Essentially though, it can't go negative.
I don't know any literature on it off the top of my head, but I will think about it.
-
$\begingroup$ Thanks Mike. Could you please explain some more about why VIF is still appropriate for dummy variables, when Pearson is not? Is there a publication reference that you could point me to which discusses this? I have done an extensive search online and found nothing for this topic, which is quite surprising since I am sure others before me have encountered this problem, which is quite common, I would think. You're the first person who has specifically said this, so thanks for your reply and hope to hear from you soon!!! $\endgroup$ Commented Aug 15, 2013 at 14:55
-
$\begingroup$ I am not sure what your example means, could you pls explain it in words? Also, why is VIF appropriate? Is there any publication references you can give me? Many many thanks! $\endgroup$ Commented Aug 16, 2013 at 15:43
-
$\begingroup$ Sorry about that, I had started to put it in a comment, then decided to add it to the post by editing but didn't realize it had saved half the comment. I hope that's a little more clear but let me know if it's not. $\endgroup$ Commented Aug 16, 2013 at 22:32
-
$\begingroup$ I agree with Mike's answer, assuming none of these variables is ordinal. Also, in the event that you’re not confident that (transformed) linear regression is appropriate for your dataset, and you want to more generally explore relations among the categorical variable, consider log-linear analysis. Saying this just in case it helps; feel free to ignore. $\endgroup$ Commented Jul 27, 2020 at 20:26