This video guides you on how to mitigate the problem of missing values in your data using AVERAGED data. I showed how to create 5-year averages.

CrunchEconometrix LinkedIn Page: https://www.linkedin.com/company/cruncheconometrix

Excel Dataset: https://www.researchgate.net/publication/384972618_Mitigate_Missing_Values_Using_Averages

Stata Dofile: https://www.researchgate.net/publication/384972462_Stata_Dofile_on_How_to_Mitigate_Missing_Values_using_Averaged_Data

CrunchEconometrix videos should be supported by relevant readings from econometrics textbooks, journal articles and other resources to properly harness the simplicity of the video tutorials.