- 86
- 372 293
Komal Kanwar Shekhawat
India
เข้าร่วมเมื่อ 24 ส.ค. 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
มุมมอง: 190
วีดีโอ
8. XLOOKUP in Excel || Beginner's Guide to Excel || Excel Tutorial
มุมมอง 2175 หลายเดือนก่อน
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
มุมมอง 1185 หลายเดือนก่อน
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
มุมมอง 2376 หลายเดือนก่อน
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
มุมมอง 2746 หลายเดือนก่อน
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
มุมมอง 1326 หลายเดือนก่อน
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
มุมมอง 1797 หลายเดือนก่อน
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
มุมมอง 1617 หลายเดือนก่อน
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- th-cam.com/video/9b2XKEyLiyE/w-d-xo.htmlsi=mk...
1. Interface of MS Excel || Beginner's Guide to Excel || Excel Basics Tutorial
มุมมอง 1677 หลายเดือนก่อน
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
มุมมอง 4827 หลายเดือนก่อน
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
มุมมอง 2Kปีที่แล้ว
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_
มุมมอง 1.7Kปีที่แล้ว
Treatment of Missing Values || Forecasting in EVIEWS || @komalkanwarshekhawat_
Engle Granger Residuals Based Cointegration Test || EViews@komalkanwarshekhawat_
มุมมอง 942ปีที่แล้ว
Engle Granger Residuals Based Cointegration Test || EViews@komalkanwarshekhawat_
Paired Sample t Test || SPSS Software || Paired t Test using SPSS @komalkanwarshekhawat_
มุมมอง 235ปีที่แล้ว
Paired Sample t Test || SPSS Software || Paired t Test using SPSS @komalkanwarshekhawat_
How to decide Optimal Lag in EViews || EViews Tutorials @komalkanwarshekhawat_
มุมมอง 2.4Kปีที่แล้ว
How to decide Optimal Lag in EViews || EViews Tutorials @komalkanwarshekhawat_
System GMM in EViews || EViews Tutorials || EViews@komalkanwarshekhawat_
มุมมอง 5Kปีที่แล้ว
System GMM in EViews || EViews Tutorials || EViews@komalkanwarshekhawat_
What is GMM ?? || Difference GMM and System GMM
มุมมอง 1.9Kปีที่แล้ว
What is GMM ?? || Difference GMM and System GMM
Generalized Method of Moments || GMM Model || Difference and System GMM
มุมมอง 2.8Kปีที่แล้ว
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
มุมมอง 1.5Kปีที่แล้ว
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
มุมมอง 1.1Kปีที่แล้ว
Model Selection Criteria || R Square || Adjusted R Square || AIC || SIC
How to arrange Cross- Sectional Data? || EViews Tutorials || Cross- Sectional Data
มุมมอง 1.1Kปีที่แล้ว
How to arrange Cross- Sectional Data? || EViews Tutorials || Cross- Sectional Data
How to convert a series in Log in EViews? || EViews Tutorials || EViews @komalkanwarshekhawat_
มุมมอง 2Kปีที่แล้ว
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
มุมมอง 2.5Kปีที่แล้ว
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
มุมมอง 3.6Kปีที่แล้ว
How to convert Yearly Data to Quarterly/ Monthly data? || EViews || EViews Tutorials
What is a Dummy Variable ? || DUMMY VARIABLES || ECONOMETRICS
มุมมอง 1.6K2 ปีที่แล้ว
What is a Dummy Variable ? || DUMMY VARIABLES || ECONOMETRICS
Second Generation Panel Unit Root Test || EViews Tutorials || CADF || CIPS || PANIC
มุมมอง 8K2 ปีที่แล้ว
Second Generation Panel Unit Root Test || EViews Tutorials || CADF || CIPS || PANIC
Time Series Analysis || EViews Tutorials
มุมมอง 2.8K2 ปีที่แล้ว
Time Series Analysis || EViews Tutorials
Gravity Model of Trade || Part 2 || EViews Tutorials
มุมมอง 4.5K2 ปีที่แล้ว
Gravity Model of Trade || Part 2 || EViews Tutorials
Gravity Model of International Trade || Part I || EViews Tutorials
มุมมอง 8K2 ปีที่แล้ว
Gravity Model of International Trade || Part I || EViews Tutorials
Impulse Response Function || EViews || EViews Tutorials
มุมมอง 2.2K2 ปีที่แล้ว
Impulse Response Function || EViews || EViews Tutorials