How to fill missing values quickly/ Linear interpolation/ panel data/ Stata/

[@user-my4zf5vk3e]

Thank you for taking the time to make this video. I have learned and am very grateful.

[@bahadircakmakli1236]

hello, dear professor, when we complete the missing values in this way, is the reality in panel data analysis questioned for articles? Are there any sources that this is done in this way in the literature? thank you

[@NirmalSingh-yy4lc]

@@bahadircakmakli1236 This is linear interpolation of the data which is well accepted in the scientific research papers. I am giving reference of one such study. environmentalsystemsresearch.springeropen.com/articles/10.1186/s40068-015-0052-z

[@Paulo10386-..]

thank you so much, it's very hopeful

[@NirmalSingh-yy4lc]

You are welcome. Thanks

[@Chamomile136]

if the missing value happens at the beginning or at the end of data unit, what's method can I use to fix it?

[@filipfilipovic9438]

Sir, if data missing only at the beginning or at the end of data , would this method still be appropriate? Or is not, could method should i use ?

[@NirmalSingh-yy4lc]

You need to have some data for that particular crosssectional unit which you want to fill because as this metod interpolate। Using the crosssectional unit. In this case bank code.

[@ishfaqgulzar865]

for both extrapolation and interpolation how missing values will be derived especially in a panel data

[@NirmalSingh-yy4lc]

Interpolation I have illustrated in this video.. For extrapolation several videos are available on this platform. I myself hope to make one.

[@realchannelofwisdom]

Sir is it good method to deal with missing values....if is it then whats the reason?

[@NirmalSingh-yy4lc]

Definately better method then other methods, however its goodness depends on how much data you want to generate through this. You can fill limited values and not the majar partion of dataset.

[@ramsharma8843]

Namaskar sir, In Panel data can we handle missing values, actually interest coverage ratios for non banking companies are available but not for banking companies. What should I do, whether drop the companies or drop the variable or any other solution?

[@NirmalSingh-yy4lc]

You might have complete data on banking and non banking companies for other variables hence dropping companies does not seem a good idea you can consider dropping the variable.

[@ramsharma8843]

@@NirmalSingh-yy4lc yes sir, and thanking for reply Is there any solution also there🙏

[@NirmalSingh-yy4lc]

@@ramsharma8843 welcome, you can look for alternative proxies for interest coverage ratio. Explore the literature in this regard.

[@ramsharma8843]

@@NirmalSingh-yy4lc thanku sir, doing it

[@Pisangrai]

Thank you..

[@NirmalSingh-yy4lc]

Welcome

[@otmanerachedifatmazohra8204]

Thank you

[@NirmalSingh-yy4lc]

Welcome