Data Science

What are the best practices for handling missing data in a regression analysis model?

MA Asked by Mark Stevens · 22-01-2024
0 upvotes 5,659 views 0 comments
The question

I have a dataset where about 15% of the values in my independent variables are missing. I'm debating between using mean imputation or something more complex like Multiple Imputation by Chained Equations (MICE). What is the standard approach in the industry to ensure the regression coefficients stay unbiased?

3 answers

0
M
Answered on 25-01-2024

Avoid mean imputation if you can; it artificially reduces the variance of your dataset and can lead to biased results. For a 15% missing rate, MICE is generally the gold standard in modern data science. It creates multiple "complete" datasets by predicting the missing values based on other variables, then pools the results. This captures the uncertainty of the missing data far better than any single imputation method. If the data is Missing Completely at Random (MCAR), you might get away with listwise deletion, but MICE is safer for Missing at Random (MAR) scenarios.

0
KE
Answered on 27-01-2024

Before choosing an imputation method, have you analyzed the "missingness" pattern? Is it possible the data is Missing Not at Random (MNAR), which would require a different strategy? 

MA 29-01-2024

Kevin, that's a fair point. It seems people with higher incomes were less likely to report their salary in this survey, so it’s likely MNAR. How would I go about adjusting my regression model if the missing data is actually dependent on the value itself?

0
RY
Answered on 31-01-2024

MICE is great, but don't overlook simple K-Nearest Neighbors (KNN) imputation. It’s often easier to implement and can be very effective for numerical datasets. 

ME 02-02-2024

Ryan makes a good point. KNN is quite robust, although for very large datasets, the computational cost can be a bit higher than MICE or simpler methods.

Share your thoughts

Your email address will not be published. Required fields are marked (*)

Professional Counselling Session

Still have questions?
Schedule a free counselling session

Our experts are ready to help you with any questions about courses, admissions, or career paths. Get personalized guidance from industry professionals.

Request a Call Back

Search Online

We Accept

We Accept

Follow Us

"PMI®", "PMBOK®", "PMP®", "CAPM®" and "PMI-ACP®" are registered marks of the Project Management Institute, Inc. | "CSM", "CST" are Registered Trade Marks of The Scrum Alliance, USA. | COBIT® is a trademark of ISACA® registered in the United States and other countries.

Book Free Session