Тёмный

Autocorrelation tests (Part 2): Breusch-Godfrey LM test (Excel) 

NEDL
Подписаться 26 тыс.
Просмотров 7 тыс.
50% 1

How one can easily test for serial correlation of lag order higher than one? The Breuch-Godfrey LM (Lagrange multiplier) test is most likely the answer! Today, we are learning how to apply this test in Excel and how to use F and Chi-squared distributions to explicitly test for autocorrelation presence.
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

Опубликовано:

 

15 июл 2020

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 29   
@NEDLeducation
@NEDLeducation 4 года назад
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
@vaibhavbadgi5752
@vaibhavbadgi5752 3 года назад
How can one interpret p- value of 48% in Breuch-Godfrey LM (Lagrange multiplier) test.
@NEDLeducation
@NEDLeducation 3 года назад
@@vaibhavbadgi5752 Hi Vaibhav, and thanks for the question! The interpretation could be the following: as p-value is higher than 10%, there is no significant dependence in the model residuals, hence no autocorrelation, and the model is properly specified in this regard. Hope it helps!
@PhilosophySoldier
@PhilosophySoldier 3 года назад
Great video! Keep going!
@NEDLeducation
@NEDLeducation 3 года назад
Glad you liked the video :)
@phanquochung3924
@phanquochung3924 2 года назад
thank you teacher
@hlingnau8057
@hlingnau8057 2 месяца назад
Thanks for this very helpful video. I am still struggling a bit with the results of my time series though... . DurbinWatson is 2,108 . BreuschGodfrey show 0,000% as p-value for both F-stat and Chi-sq . BoxPierce and LjungBox show 67,5% and 67,0% as p-values. So yes, I guess that means there is some strong signs for autocorrelation which does not surprise me but I am puzzled about the results of BoxPierce and LjungBox being rather elevated? Heinrich
@vladimirabaev4117
@vladimirabaev4117 4 месяца назад
Супер!
@futurestradinginunder7minu872
@futurestradinginunder7minu872 4 года назад
Excellent video as always! I keep seeing references online to the Breusch (same person?) -Pagan & White test. Can you tell us what the difference is?
@NEDLeducation
@NEDLeducation 4 года назад
Hi again and thanks for the feedback! As for the question: yes, Breusch is the same person indeed, he developed an autocorrelation test with Godfrey (Breusch-Godfrey LM test), and a heteroskedasticity test with Pagan (Breusch-Pagan). We have got a video on Breuch-Pagan as well: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-p2TmKdbn5Uk.html Regarding White test, we also have got a video on this: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-c-VGDK8xvz8.html Breuch-Pagan-White can sometimes be mentioned jointly as the logic of the two tests is ultimately similar - to apply auxiliary regressions to determine whether there is heteroskedasticity in the data. White differs from Breuch-Pagan slightly as it includes more regressors. Hope it helps!
@igorcarvalho8253
@igorcarvalho8253 2 года назад
Hi NEDL, great video, and I have several questions to ask. 1. Does this test use to test for serial correlation? 2. I run Breusch pagan test for serial correlation and I found my DW is less than two, what can I do to solve the issues?
@NEDLeducation
@NEDLeducation 2 года назад
Hi Igor, and thanks for the excellent questions! 1. Yes, serial correlation and autocorrelation are most often interchangeable terms. 2. If you found the current model suffers from autocorrelation, you can apply the model to the first differences or rates of change of the dependent variable instead of its levels, include lags of the dependent variable as additional regressors, or use HAC standard errors (the latter is however only implementable if you use the matrix method to do regressions).
@igorcarvalho8253
@igorcarvalho8253 2 года назад
@@NEDLeducation thanks so much for your answers, however when I wacthed your videos I was kind of confuse a bit cause I always run the data using regression analysis, and when I saw you run each one of them using just excel, I was kind of confuse a bit, can I use HAC standard errors in just regression analysis terms?
@ducthien0224
@ducthien0224 2 года назад
Great video!! Ton of thanks for making these definitions easier to understand and more practical by demonstrating them in Excel. One question here please, the Chi-square stats is also used to test for an issue called Conditional Heteroskedasticity. Is it what your presentation here on the Chi-square stats is about? And to my learning, which is still limited, the degree of freedom (df) of Chi-square stats is k = # independent variables, which is 4 in this case, including 3 lags and the SP500. If i'm correct, then how come the p-value of Chi-square only takes the df of 3? Hope to have your further explanation. Thank you!
@NEDLeducation
@NEDLeducation 2 года назад
Hi Thien, and thanks for the comment, glad you are enjoying the videos! As for your questions: 1) The tests in this video are all addressing the issue of autocorrelation, for heteroskedasticity, please have a look further into the econometrics playlist, for example here is a tutorial on Breusch-Pagan test for heteroskedasticity: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-p2TmKdbn5Uk.html and on the ARCH test: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Fl7k4pynuN0.html that opens up the realm of ARCH/GARCH volatility modelling. 2) The choice of three degrees of freedom is simply due to us having three lags. Hope this helps!
@ducthien0224
@ducthien0224 2 года назад
@@NEDLeducation thank you so much, sir! I'm really grateful!!
@raffaeleberti3293
@raffaeleberti3293 3 года назад
Awesome video as usual! If I have to perform the test referring only to Tesla, not considering SP500, how could I do it? What column do I consider when I go to do the LINEST, if not SP500? Another question is that when I go to do the LINEST function I can't get the table, but only a value! Why?
@NEDLeducation
@NEDLeducation 3 года назад
Hi Raffaele, and glad you liked the video! To omit independent variables from the estimations, you can simply calculate the residuals as demeaned dependent variable (here - demeaned Tesla returns), and apply the test to lagged residuals. Hope this helps!
@genchmot3688
@genchmot3688 4 года назад
Great video. If the result of 3 lag has no significant autocorrelation, should we go on to test lag 2 and lag 1 too?
@NEDLeducation
@NEDLeducation 4 года назад
Hi Mot, many thanks for your feedback and for the question! Overall, not really, the only circumstance where there might be significant autocorrelation at some lags but none as shown by F-stat or Chi-squared stat is when you include too many lags and only some of these are meaningful. To double-check, you could look at t-stats for individual autoregressive coefficients. If none of them are high, it can be used as additional evidence against the presence of autocorrelation. Hope it helps!
@user-mg2by8sf6r
@user-mg2by8sf6r 3 года назад
Hi Савва! Thank you for your video. Right now I'm trying to implement this autocorrelation test using some of Python's modules. I'm trying to use Statsmodels OLS function on your date (Resid ~ SP500 + Resid (-1) + Resid (-2) + Resid (-3) but the summary table shows me completely different results: for example, my F-statistic is 0.1750, R^2 is 0.001 and all coefficients are not like on your video.
@NEDLeducation
@NEDLeducation 3 года назад
Hi and thanks for the comment! Glad to hear you are implementing your own Python code based on the tutorial! The reason for the discrepancy could be the lagged residuals. Here, I assume lagged residuals for the missing values are zeroes, Python most likely drops them by default. Hope it helps!
@user-mg2by8sf6r
@user-mg2by8sf6r 3 года назад
@@NEDLeducation Hi Савва, thank you for your reply. Actually, no, I've replaced all nan values with 0. The interesting part is that Durbin-Watson test showed that same results as in your video. But B-G LP test has this problem
@kabirbansal2693
@kabirbansal2693 Год назад
Hii, great video I had a doubt suppose I did this BG test with one independent variable and 2 lags and result shows there is a Autocorrelation but my Lag 1 p-value is very low and lag 2 p-value is quite high so should I only consider Lag 2 errors for autoregression?
@antoniofernandes5751
@antoniofernandes5751 3 года назад
Hi, thanks for this amazing video! I would like to ask a question, in my case, i am applying a linear regression model for a water quality dataset, my X values are pollution sources and my Y is a contaminant concentration, my samples are sampling sites. Is it correct to apply lags in this case? Regards
@NEDLeducation
@NEDLeducation 3 года назад
Hi Antonio, and glad you liked the video! As for your question, if I recall correctly, your data is cross-sectional (so one measurement at some point in time for a number of sites). Here, autocorrelation is not an issue (it is conventional to test for autocorrelation in time series data, in your example that would be measuring pollution at one source every single day). While it would be not theoretically incorrect to apply autocorrelation tests here, it has little interpretative value. You might check for heteroskedasticity instead if you worry about assumption violation as is is more of a concern for cross-sectional data. I have got a series of videos on that, so check this out if you are interested: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-p2TmKdbn5Uk.html Hope it helps!
@antoniofernandes5751
@antoniofernandes5751 3 года назад
@@NEDLeducation understood, thank you very much!
@antoniofernandes5751
@antoniofernandes5751 3 года назад
@@NEDLeducation do u have any publications in the scope of linear regression modelling? i would like to cite you! Regards
Далее
What is autocorrelation? Extensive video!
36:02
Просмотров 134 тыс.
Serial Correlation (Autocorrelation)
18:05
Просмотров 1,3 тыс.
LASSO explained: Machine learning in Excel
19:04
Просмотров 4,4 тыс.
Testing for Heteroscedasticity
7:37
Просмотров 79 тыс.