Would you explain how to find a missing data on the first data consecutively? I use a panel data set on my research from 2012-2020. Then, only one variable in one country I couldn't find the data for 2 years (2012-2013). What's the best method that I should use to find it? Does this MEAN Imputation method is good?
The COUNTA function counts cells containing any type of information, including error values and empty text (""). For example, if the range contains a formula that returns an empty string, the COUNTA function counts that value. The COUNTA function does not count empty cells.
This is a very useful and simple explanation of cleaning a missing data using different imputation strategy...Thank you for uploading this video...
You are most welcome
Would you explain how to find a missing data on the first data consecutively? I use a panel data set on my research from 2012-2020. Then, only one variable in one country I couldn't find the data for 2 years (2012-2013). What's the best method that I should use to find it? Does this MEAN Imputation method is good?
Really helpful 🙌
Glad it was helpful!
What if u have missing dates? How can you clean them?
SuperB Technique, Thank you so much
Glad you liked it!
Very inisghtful, thank you
Glad it was helpful!
How do I replace missing or handle missing data with Quantatitative Answers? But I am also below the 30% .
CAN WE USE JUST FIND AND REPLACE FOR EACH PARTICULAR COLUMN TO FILL M VALUES IN IT ?
If you are using find and replace. the number is not dynamic, if someone changes the above cells the number would not change using find and replace.
I get a no value to get percentage of missing counts?
Good job ❤
Thank you very much!
Will this not change, the aggregate of.the column
Yes, it will change the aggregation based on the aggregation function you are going to use.
How to deal with categorical missing values
I don't understand why your value are showing less or null by using counta
The COUNTA function counts cells containing any type of information, including error values and empty text (""). For example, if the range contains a formula that returns an empty string, the COUNTA function counts that value. The COUNTA function does not count empty cells.