Handling Missing Data

Handling Missing Data

Sometimes we may not have 100 percent access to all the data we would wish to have in order to carry out our analysis. In such scenarios, how can we work around this and ensure we are able to conduct an objective analysis?

Five Percent Threshold:

Option 1: Consider it safe to drop a certain proportion of the null values. For instance, if your sample size is 1,000, to determine the threshold for dropping, compute five percent of the total values (0.05 * 1,000 = 50).

Option 2: Substitute the missing values with the median. Why the median? It is not affected by skewness, making it a robust choice when handling missing data.

By carefully considering these options, you can maintain the objectivity of your analysis and avoid distorting your results.

?

?

#21DaysLinkedlnChallengeWithAmbibola ?Abimbola Arowolo

hashtag#DataThatMatters

Oluwasemilogo Akinlo

Molecular Biologist | Microbiologist | Data Analyst | Genomics & Bioinformatics

3 周

I will take these steps, next time I have missing data, thank you for sharing

要查看或添加评论,请登录

Bernadette Mutunge的更多文章

  • Piece of the Pie

    Piece of the Pie

    A pie chart is a useful visualization tool; however, if your audience is unable to distinguish between the different…

  • Visuals: The Appetizers to Deep Insights

    Visuals: The Appetizers to Deep Insights

    Visuals serve as appetizers to deep insights. While the number and type of visuals you use may vary depending on the…

    1 条评论
  • Excel Resources

    Excel Resources

    Today, I take a moment to celebrate this beautiful soul,@ Esther Anagu, MBA for sharing such useful resources. Reshare…

  • Outliers

    Outliers

    Have you ever wondered what is the best practice for handling outliers? The answer to this question is highly dependent…

    2 条评论
  • Strategic Clarity

    Strategic Clarity

    ?? #21Day DayConsistencyChallengewithAbimbola Any serious company or organization, whether small, medium, or…

    1 条评论

社区洞察

其他会员也浏览了