Multicollinearity tests: Farrar-Glauber and Haitovsky (Excel)

How might one detect multicollinearity in a regression model? Two powerful and conceptually simple diagnostic tests exist to identify whether your independent variables are orthogonal, multicollinear, or somewhere in between, namely the Farrar-Glauber test and the Haitovsky test. Today, we are investigating their usability and learning how to apply these in Excel.
Don't forget to subscribe to NEDL and give this video a thumbs up for more videos in Econometrics!
Please consider supporting NEDL on Patreon: / nedleducation

[@NEDLeducation]

You can find the spreadsheets for this video and some additional materials here: drive.google.com/drive/folders/1sP40IW0p0w5IETCgo464uhDFfdyR6rh7
Please consider supporting NEDL on Patreon: www.patreon.com/NEDLeducation