RUclips recently changed the way my content will be monetised. My channel now needs 1,000 subscribers. So it would be amazing if you show your support by both watching my videos and subscribing to my channel if you haven’t done so already. Monetising my videos allows me to invest back into the channel with some new equipment so this small gesture from you will be extremely huge for me. Many thanks for your support….CrunchEconometrix loves to teach, help me stay online.
Dear prof. I have a question, if our both dependent and independent variables are I(1), can we perform standart regression (ols) using first differenced series?
Hi Pretty John, thanks for the positive feedback and kind remarks about my RUclips video. Deeply appreciated! Please may I know from where (location) you are reaching me?
Hello sir, I have a question, when I manually find the Dickey Fuller statistic value, the statistic value is very slightly different from the value generated from the Eviews program, although I use the same data, what is the reason? I mean the normal Dickey Fuller test, not the developer
@@Tiwo455 Yes I do. But I request that all queries be posted on the comment section of the respective RUclips video so that other users can benefit from the discussion. May I know from where (location) you are reaching me?
RUclips recently changed the way my content will be monetised. My channel now needs 1,000 subscribers. So it would be amazing if you show your support by both watching my videos and subscribing to my channel if you haven’t done so already. Monetising my videos allows me to invest back into the channel with some new equipment so this small gesture from you will be extremely huge for me. Many thanks for your support….CrunchEconometrix loves to teach, help me stay online.
Thank you Gaal. Greetings from Uganda
U're welcome, Samuel!🙏😊 Humble thanks from Nigeria 🇳🇬.
Explained in easy method.
well explained . greetings from Sri Lanka
Thanks Ferrari, for the positive feedback. Deeply appreciated!
Thanks so much. It is a great benefit to me watching this vedio and eased my job.
Thank you once again.
Glad it helped, Tsegaye...thanks!
Great thanks. I am waiting for more econometric test using excel
U're welcome, Hareedy. But highly unlikely because the Excel application is not built for robust econometric procedures like EViews, Stata, R etc.
hello, the ADF number that she is using to reject the hypothesis is from STATA right? can we calculate that number in excel? or not
Not sure if you can do that in Excel.
Really clear and well explained, thank you!
Thanks a lot, Nilesh. I am humbled by the positive feedback, grateful!
Thanks!
Good day mam. Can u do a forecast for ardl to predict in future using ARDL instead of VAR. I have problem to do it. :( thanks
Hi Iffah, I have no idea about using ARDL for forecast. You may want to check out other online resources. Thanks.
Dear prof. I have a question, if our both dependent and independent variables are I(1), can we perform standart regression (ols) using first differenced series?
Yes, you can.
Thank you so much ma'am. It is so helpful.
Hi Pretty John, thanks for the positive feedback and kind remarks about my RUclips video. Deeply appreciated! Please may I know from where (location) you are reaching me?
Do we employ the ADF test even for independant variables?
Hi Shristi, yes.
how do we include trend in ADF in excel?
Hi Linna, generate the trend variable, t and include it in the estimation.
@@CrunchEconometrix thank you for reply :)
Hello sir, I have a question, when I manually find the Dickey Fuller statistic value, the statistic value is very slightly different from the value generated from the Eviews program, although I use the same data, what is the reason?
I mean the normal Dickey Fuller test, not the developer
Hi Khaled, you don't expect to get the same results across different analytical software. Stick to one.
I was trying to apply the regression but i had a problem in applying two rows on input range
Why not follow my guide as shown in the clip?
This well explained Ma'am! Could you link me to the research paper that you have used in this video at 2:56 ?
Hi Vighnesh, the ADF test is very popular. You can easily get references online. I only showed how to perform the test in Excel.
How do we calculate the lagged value of the dependent variable in excel?
Hi Oshin, how do you mean? The coefficient is automatically derived.
Regression X range and Y range must have the same number of rows (sample values ) regardless of labels
Hi Tionge, your query is not quite clear.
CrunchEconometrix I was able to solve it ,Thank you .Do you reply to email enquirers ?
@@Tiwo455 Yes I do. But I request that all queries be posted on the comment section of the respective RUclips video so that other users can benefit from the discussion. May I know from where (location) you are reaching me?
thanks
You are welcome, Dr. Das. Please may I know from where (location) you are reaching me?
From Silchar, Assam
i think that critical value for number of observation =86 , 5% significance in the video is not correct
Hi Pedro, and what do you suggest is the correct CV?