Heteroskedasticity tests (Part 1): Breusch-Pagan test (Excel)

How one can detect heteroskedasticity in their dataset? The simplest test is perhaps the Breusch-Pagan test that uses the concept of auxiliary regression to relate squared residuals to the initial independent variables. Today we will learn how to apply it in Excel and also discuss its advantages and limitations.
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

[@khurtsbaatarbold5761]

It is really helpful and clear, thank you

[@samuelmundia320]

Nice one...

[@arthurrambo4219]

thank you a lot

[@VASILIKININOU]

Very nice video!!! How can we fix heteroskedasticity, when detected? I am trying to detect herding using CSSD and CSAD, but I have to test for heteroskedasticity. How can I do that and fix the problem (probably there is heteroskedasticity).

[@jigsaudiobooks]

If F and chi-square are 70%, doesn't it mean that heteroskedasticity is present?