- 86
- 368 352
Komal Kanwar Shekhawat
India
Registrace 24. 08. 2013
Hello everyone!
I'm Komal Kanwar Shekhawat, working in Economics & Finance Cell, NITI Aayog, Government of India (Think Tank).
This channel has been created with the motive to help those who want to learn Econometrics and Regression analysis (for both Time series data and Panel data) using various statistical software.
We all are aware of the fact that the demand of the time is to gain expertise in statistics and econometrics analysis.
The channel will upload videos on how to perform Statistical and Econometrics analysis using:
- EVIEWS
- SPSS
- STATA
- R
Also, join my telegram group for discussion and queries.
Keep following and do SUBSCRIBE to the channel to catch up the next video.
Happy Learning!
**The views expressed/ content uploaded is solely that of the creater and does not necessarily reflect the views of my associated institution.
I'm Komal Kanwar Shekhawat, working in Economics & Finance Cell, NITI Aayog, Government of India (Think Tank).
This channel has been created with the motive to help those who want to learn Econometrics and Regression analysis (for both Time series data and Panel data) using various statistical software.
We all are aware of the fact that the demand of the time is to gain expertise in statistics and econometrics analysis.
The channel will upload videos on how to perform Statistical and Econometrics analysis using:
- EVIEWS
- SPSS
- STATA
- R
Also, join my telegram group for discussion and queries.
Keep following and do SUBSCRIBE to the channel to catch up the next video.
Happy Learning!
**The views expressed/ content uploaded is solely that of the creater and does not necessarily reflect the views of my associated institution.
9. Text Functions in Excel || Beginner's Guide to Excel || Excel Tutorial
Hello everyone,
This video explains some of the most important Text Functions in MS Excel.
In this video I have specifically discussed the following Text Functions-
1. TRIM
2. PROPER
3. UPPER
4. LOWER
Do watch the video till end. Do SUBSCIBE to the channel.
Please subscribe to the channel. Happy learning !!
#excel #msexcel #keyboard #keyboardshortcuts
Link to join telegram channel: t.me/kshekhawat
This video explains some of the most important Text Functions in MS Excel.
In this video I have specifically discussed the following Text Functions-
1. TRIM
2. PROPER
3. UPPER
4. LOWER
Do watch the video till end. Do SUBSCIBE to the channel.
Please subscribe to the channel. Happy learning !!
#excel #msexcel #keyboard #keyboardshortcuts
Link to join telegram channel: t.me/kshekhawat
zhlédnutí: 184
Video
8. XLOOKUP in Excel || Beginner's Guide to Excel || Excel Tutorial
zhlédnutí 213Před 5 měsíci
Hello everyone, This video explains how to use XLOOKUP function in MS Excel. XLOOKUP is a very powerful and useful function that can be utilized when you are dealing with a large set of data. The XLOOKUP function searches a range or an array, and then returns the item corresponding to the first match it finds. If no match exists, then XLOOKUP can return the closest (approximate) match. It is ty...
7. HLOOKUP in Excel || Beginner's Guide to Excel || Excel Tutorial
zhlédnutí 117Před 5 měsíci
Hello everyone, This video explains how to use HLOOKUP function in MS Excel. HLOOKUP is a very powerful and useful function that can be utilized when you are dealing with a large set of data. HLOOKUP stands for Horizontal Lookup and can be used to retrieve information from a table by searching a row for the matching data and outputting from the corresponding column. While VLOOKUP searches for t...
6. VLOOKUP in Excel || Beginner's Guide to Excel || Excel Tutorial
zhlédnutí 234Před 5 měsíci
Hello everyone, This video explains how to use VLOOKUP function in MS Excel. VLOOKUP is a very powerful and useful function that can be utilized when you are dealing with a large set of data. The VLOOKUP function is a premade function in Excel, which allows searches across columns. It is typed =VLOOKUP and has the following parts: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup...
5. How to create Pivot Table || Beginner's Guide to Excel || Excel Tutorial
zhlédnutí 273Před 6 měsíci
Hello everyone, This video explains how to create basic Pivot tables in MS Excel in the most easiest way. PivotTable is a powerful tool to calculate, summarize, and analyse data that lets you see comparisons, patterns, and trends in your data. Do watch the video till end. Do SUBSCIBE to the channel. The subsequent videos will explain how to create advance Pivot tables in MS Excel Please subscri...
4. Most Useful Excel Tricks || Beginner's Guide to Excel || Excel Tutorial
zhlédnutí 132Před 6 měsíci
Hello everyone... This video explains some of the most useful MS Excel tricks. Using these MS Excel tricks can make your task efficient. The video explains- 1. How to select a range of cells in Excel. 2. How to create serial number. 3. How to seperate First name & Last name 4. How to put together Full name. Do watch the video till end. Keep following and do subscribe to watch more such content....
3. Most Useful Excel Keyboard Shortcuts || Beginner's Guide to Excel || Excel Tutorial
zhlédnutí 178Před 6 měsíci
Hello everyone..... This video explains the most useful MS Excel Keyboard Shortcuts. The video mentions the following Excel Keyboard shortcuts - Save - Print - Cut - Paste - Copy - Create Table - Up & Down Navigation - Navigation across Excel sheets and so forth..... The video focuses on the most quick and simple way to use Excel Keyboard Shortcuts to make task efficient. Do watch the video til...
2. Graphical presentation in Excel || Beginner's guide to Excel || Excel Tutorial
zhlédnutí 159Před 6 měsíci
Hello everyone..... This video explains how to represent data in MS Excel using graphs/ charts. The video shows the basic components/ elements that can be used to generate graphs. The video focuses on the most quick and simple way to create graph. Do watch the video till end. Watch this video on 'Interface of MS Excel' - A beginner's guide to Excel- czcams.com/video/9b2XKEyLiyE/video.htmlsi=mk0...
1. Interface of MS Excel || Beginner's Guide to Excel || Excel Basics Tutorial
zhlédnutí 160Před 7 měsíci
Hello everyone!! This videos explains - 'The Interface of MS Excel'. If you are beginner, then this MS Excel video is for you. This is the first video in MS Excel series. The video explains: 1. How to open new workbook in Excel? 2. What is a cell and range in Excel? 3. Menu tabs in Excel 4. Different Groups/ Segments in Excel The subsequent videos shall explain all the functionalities of MS Exc...
OLS Method & Descriptive Statistics in STATA | STATA Tutorial
zhlédnutí 462Před 7 měsíci
Hello everyone!! This video explains - How to obtain the descriptive statistics of a data set and how to run an OLS model in STATA. 1. The video first explains how to obtain the descriptive statistics of the data set in STATA. The video also mentions about additional descriptives that could be obtain in STATA by following simple steps. 2. The second half of the video explains how to run OLS mod...
Block Exogeneity Wald Tests/ VAR Granger Causality/ EViews Tutorial
zhlédnutí 1,9KPřed 11 měsíci
Hello everyone!! This video explains how to " run Block Exogeneity Wald Tests/ VAR Granger Causality" using EVIEWS. In the first part, the video first explains the VAR Granger Causality test. In the second part, the video mentions about the Block Exogeneity Wald test and how to run this method in EViews. Watch this video till end ✌️👍 1. 👉 Link to join telegram channel: t.me/kshekhawat 2. 👉 VAR ...
Treatment of Missing Values || Forecasting in EVIEWS || @komalkanwarshekhawat_
zhlédnutí 1,7KPřed rokem
Treatment of Missing Values || Forecasting in EVIEWS || @komalkanwarshekhawat_
Engle Granger Residuals Based Cointegration Test || EViews@komalkanwarshekhawat_
zhlédnutí 924Před rokem
Engle Granger Residuals Based Cointegration Test || EViews@komalkanwarshekhawat_
Paired Sample t Test || SPSS Software || Paired t Test using SPSS @komalkanwarshekhawat_
zhlédnutí 235Před rokem
Paired Sample t Test || SPSS Software || Paired t Test using SPSS @komalkanwarshekhawat_
How to decide Optimal Lag in EViews || EViews Tutorials @komalkanwarshekhawat_
zhlédnutí 2,3KPřed rokem
How to decide Optimal Lag in EViews || EViews Tutorials @komalkanwarshekhawat_
System GMM in EViews || EViews Tutorials || EViews@komalkanwarshekhawat_
zhlédnutí 5KPřed rokem
System GMM in EViews || EViews Tutorials || EViews@komalkanwarshekhawat_
What is GMM ?? || Difference GMM and System GMM
zhlédnutí 1,9KPřed rokem
What is GMM ?? || Difference GMM and System GMM
Generalized Method of Moments || GMM Model || Difference and System GMM
zhlédnutí 2,8KPřed rokem
Generalized Method of Moments || GMM Model || Difference and System GMM
How to Find Lag of a Variable ? | Generate Lags in EViews | Lag Variable | EViews Tutorials
zhlédnutí 1,5KPřed rokem
How to Find Lag of a Variable ? | Generate Lags in EViews | Lag Variable | EViews Tutorials
Model Selection Criteria || R Square || Adjusted R Square || AIC || SIC
zhlédnutí 1,1KPřed rokem
Model Selection Criteria || R Square || Adjusted R Square || AIC || SIC
How to arrange Cross- Sectional Data? || EViews Tutorials || Cross- Sectional Data
zhlédnutí 1,1KPřed rokem
How to arrange Cross- Sectional Data? || EViews Tutorials || Cross- Sectional Data
How to convert a series in Log in EViews? || EViews Tutorials || EViews @komalkanwarshekhawat_
zhlédnutí 2KPřed rokem
How to convert a series in Log in EViews? || EViews Tutorials || EViews @komalkanwarshekhawat_
How to convert a series into First Difference and Second Difference? || EViews Tutorials || EViews
zhlédnutí 2,5KPřed rokem
How to convert a series into First Difference and Second Difference? || EViews Tutorials || EViews
How to convert Yearly Data to Quarterly/ Monthly data? || EViews || EViews Tutorials
zhlédnutí 3,5KPřed rokem
How to convert Yearly Data to Quarterly/ Monthly data? || EViews || EViews Tutorials
What is a Dummy Variable ? || DUMMY VARIABLES || ECONOMETRICS
zhlédnutí 1,6KPřed rokem
What is a Dummy Variable ? || DUMMY VARIABLES || ECONOMETRICS
Second Generation Panel Unit Root Test || EViews Tutorials || CADF || CIPS || PANIC
zhlédnutí 8KPřed 2 lety
Second Generation Panel Unit Root Test || EViews Tutorials || CADF || CIPS || PANIC
Time Series Analysis || EViews Tutorials
zhlédnutí 2,8KPřed 2 lety
Time Series Analysis || EViews Tutorials
Gravity Model of Trade || Part 2 || EViews Tutorials
zhlédnutí 4,5KPřed 2 lety
Gravity Model of Trade || Part 2 || EViews Tutorials
Gravity Model of International Trade || Part I || EViews Tutorials
zhlédnutí 8KPřed 2 lety
Gravity Model of International Trade || Part I || EViews Tutorials
Impulse Response Function || EViews || EViews Tutorials
zhlédnutí 2,1KPřed 2 lety
Impulse Response Function || EViews || EViews Tutorials
how to convert annual panel data to semi-annual panel data inside eviews?
Thank you for your favor and reply, I have installed Eviews 12 and this option was shown to me. but my data is an unbalanced panel, and Eviews gave an error that this test (panel unit root with cross-sectional dependence) cannot be performed for an unbalanced panel. Please introduce me to the link of the video where you have taught the unit root test test (the second generation of the unit root test, with cross-sectional dependence) for the unbalanced panel. I looked for it myself, but I didn't find anything, thanks. My emphasis is on the unbalanced panel.
Thank you !
pleasse ye be bata dy ke hum FTAbothin and FTAonein include kry
how we include pairs of countries please tell me
Hello and thank you for your scientific and valuable content, I need this answer urgently. thanks. At minute 5:51, when your mouse is on the unit root test, a small black triangle can be seen on the right side of the unit root, which shows two separate parts: 1. cross-sectionally dependent 2. cross-sectionally independent But for me, in my eviwes it is not displayed like that, and two options 1. cross sectionally dependent 2. cross-sectionally independent Is it not displayed !! My Eviews is version 11, what is the cause of this problem?
This option is available in Eviews 12.
@@komalkanwarshekhawat_ Thank you for your favor and reply, I have installed Eviews 12 and this option was shown to me. but my data is an unbalanced panel, and Eviews gave an error that this test (panel unit root with cross-sectional dependence) cannot be performed for an unbalanced panel. Please introduce me to the link of the video where you have taught the unit root test test (the second generation of the unit root test, with cross-sectional dependence) for the unbalanced panel. I looked for it myself, but I didn't find anything, thanks. My emphasis is on the unbalanced panel.
Where is the part 2 to SYS-GMM? Thank you
Can you examine long-run and short-run effects using IV-GMM?
Hello mam how to get longrun coefficient of cross sectional data in eviews ardl?
Thanks for the video. Is this also applicable to the panel regression (OLS)?
how can i and how many days are required to learn panel regression with gmm ?
Very helpful video, thank you!
Hi, may I know what is the name for this test that used for endogeneity? May I know would it be possible for me to have references to test for endogeneity?
Is it necessary that for causality test variables should be stationary
Thank you very much for the video and the explanation. When we are referring to "shock" of the impulse variable, do we mean like a negative or positive "shock" will result in a positive reaction of the response variable?
Hi Ma'am, I have a question. Now I know how to get long-term coefficients, but what about the significance of thse long-run coefficients? How to get p-value for those? Also, which are the short-run coefficients? I am doing NARDL on STATA and I got variables like var1 and d(var1), I thought var1 could be long-run and and d(var1) could be short-run. I am using the NARDL module created by Marco Sunder. Could you please help me
Excellent video! Clear and easy to understand.
Thank you 🙏
Amazing 😍 video mam
Thanks a lot 😊
Veri nice video🎉🎉👌👌🥰
Thank you 🙏
That's helpful mam and very easy to understand ❤ Thank you mam.
Glad, you liked it. 😊
That's helpful and insightful, ma'am. Thank you for sharing:)
Glad you enjoyed it! 😊
knowledgeable video mam 🙌🏻👏🏻
Thanks a lot 😊
❤😊
🤗🙏
👏👏🥰
🤗🙏
I have one problem remove autocorrelation through lag the p value is less than 0.05 how I can slove these problem if using the log but data are both type of data positive and negative can it handle the data change into positive and using log ?
Thanks
Welcome 🙏
Thank you very much Komal! Your videos are very helpful for my Ph D.
Grateful to know this. 🙏
very helpful video, please tell how to have long run causality test results using Block Exogeneity Wald Test, from where we can have ECT values and how to interpret them ?
Hello...i am getting "N/A" for my dummy variable when doing the granger causality test...please explain
thank sir
Unless you are willing to make assumptions, there is no way to convert yearly data into monthly or quarterly data. If you are willing to make the assumption that whatever it is you have data on happens at a uniform rate throughout the year then quarterly data would just be yearly data divided by 4.
do we check for heteroscedasticity and autocorrelation after selecting the model based on chow test, hausman test and breusch pagan test of should be check for heteroscedasticity and autocorrelation in initial stage
how did you determine the 10 lags in the command (aic 10)?
Ma'am, I guess this was a mistake at 10.35 onwards. You said since p<0.05 (which is the case here), "we cannot reject H0, and hence we accept the alternate hypothesis of having no unit root, i.e. data is stationary." However, this conclusion is not correct: if p>0.05, yes we do not reject H0, meaning that in the case of stationarity, we would ACCEPT H0 (not H1), that is, data has a unit root or is non-stationary. I think you need to clarify this, as it will lead to a lot of confusion for others watching this video.
You are correct.
Menit 2:20 oke
perfect... in short time.. optimum gyaan shared
Hello how can i generate impulse response function for parsimonious VAR model ? there is no option for that in eviews
Thank you so much for your videos, they are very useful for me. My question is if I can use this model to estimate the effect of the trade agreement on the exports of a single trading partner, without using the data panel for several countries.
Thank you
Is your data of t-bill in percentage?
Why does panel ardl doesn't have rsquare value
thank you...also show on spss how anova &.Acnova model results are interpreted
Welcome 🙏 Video is already uploaded, kindly watch - czcams.com/video/oBOr6pNF_Qg/video.htmlsi=SbY3jRsTtRNMBk8W
For unbalanced panel fata how to do it in ky case problem of csd cone so i want to run cips but since data unbalanced i cant apply also cadf is not giving t value what shall i do
Dear Komal, Can you please help me how to apply quantile VAR approach?????
Thanks so kindly for this informative video. However, the interpolation feature is not available in the student version of "Eviews 12". Can you help with an alternative?
Dear, the interpolation feature is available.
What possibly could be reason preventing the feature to displayed?
Is it that missing value should be consistent with each other? Should the missing values have the same gap?
Hank you so much ❤❤❤
Welcome 🙏
Thank you very much, Komal, for a nice explanation.
Welcome 🙏
Greetings. Do you have time series data analysis videos?
Yes, please check the 'Time series Analysis' playlist.
Ma'am how can I contact you?
Mail your query - kshekhawat599@gmail.com Join my Telegram channel- t.me/kshekhawat
Good explanation
Thank you 🙏