Data modelling · Regression
Multicollinearity: when predictors tell the same story
Expect it as "what is multicollinearity, how do you detect it, and how do you fix it?" That's three parts, and this lesson gives you all three.
What it is
Multicollinearity means two or more predictor (independent) variables in a regression are highly correlated with each other. Example: predicting salary from both age and years of experience. They move together, so the model can't tell which one deserves the credit.[Penn State STAT 462]
Why it hurts (and what it doesn't hurt)
❌ Interpretation breaks
Coefficients become unstable: small data changes flip their size or even their sign. Standard errors inflate, so truly important variables can show high p-values ("not significant").✅ Prediction often survives
Overall fit (R²) and predictions can still be fine. It's mainly a problem when you need to explain which driver matters, which is exactly what analysts get asked.Detect it: correlation matrix, then VIF
- Correlation matrix of the predictors. A pairwise |r| above about 0.8 is a red flag. But it misses cases where three variables combine.
- Variance Inflation Factor for each predictor j: regress Xj on all the other predictors, take that R²j, and compute:
VIFj = 1 ÷ (1 − R²j)
Fix it
- Drop one of the correlated variables (keep the one that's easier to explain or measure).
- Combine them into one feature: a ratio, an index, or principal components (PCA).
- Regularise with ridge regression, which shrinks and stabilises the coefficients.
- More data helps a little. Centre variables before creating interaction or squared terms.
Retrieval check
Multicollinearity is a high correlation between …
What is its main harm?
Regressing X₁ on the other predictors gives R² = 0.9. What is VIF₁?
Which of these is not a fix for multicollinearity?
"City" has 3 categories and the model has an intercept. How many dummy columns?
Type it
R²j = 0.75. VIF = ?
What R²j gives a VIF of exactly 5?
Your turn
- In Excel, enter Age = 25, 28, 32, 35, 40, 45 and Experience = 2, 6, 8, 12, 18, 21.
- Compute
=CORREL(A2:A7,B2:B7). With only 2 predictors, VIF = 1/(1 − r²). Compute it with=1/(1-RSQ(A2:A7,B2:B7)). - Change Experience to exactly Age − 23 and recompute. VIF →
#DIV/0!. That's perfect multicollinearity. - Name 3 correlated predictor pairs from a business you know (e.g. ad spend and impressions).
- Say the "detect + fix" answer out loud in under 40 seconds.
Go deeper
Related: Lesson 7: p-values (why inflated standard errors hide significance) · Stats cheat sheet · Statistics question bank