Variance inflation factors explained: Diagnosing multicollinearity (Excel)
HTML-код
- Опубликовано: 6 июл 2022
- Variance inflation factors (VIF) is a go-to technique for diagnosing multicollinearity. Today we are discussing the mathematical and statistical concepts behind variance inflation factors, their links to the definition and the consequences of multicollinearity, and learn how to efficiently calculate 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
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
I'm a novice when comes to this subject but trying to learn it, as I need it for a part of my dissertation. I have watched about 20 videos on the subject but no one has explained it as simply as you have. so thank you for bringing my search to an almost end on the topic.
HI Savva! I hope you are well. Great video! Just a suggestion, a very interesting topic (and related to inflation and its factors) that you could make a video is about exchange rates. In my opinion, the most difficult thing to value, since, unlike shares, they do not generate cash flows. The most widely used valuation models are econometric, often difficult to understand; and I think it would be good material for the channel to explain how to value some currency.
Hi Rodrigo, and glad you enjoyed the video! As for the exchange rate modelling, you could use standard time-series models such as GARCH for free-floating currencies and mean-reversion models such as Vasicek or CIR for explicitly or implicitly pegged currencies. In terms of valuation specifically, the go-to approaches that are grounded in theory are purchasing power parity (PPP) and interest parity models, however they do not work particularly well empirically :)
Oh yeah! The beard of knowlege strikes again!
Hello sir plz make a video how to use sequence with a formula like when in pair trading new data is update then next cell calculation are blank and if we have many pair this is hard to drag drop plz make a video on that thankyou