Data analyst Q&A 12. How can you handle missing values in a dataset?

iTECH PODCAST

12. How can you handle missing values in a dataset? The sample answer is… 1. Listwise deletion – in listwise deletion method, an entire record is excluded from analysis if any single value is missing 2. Average imputation – use the average value of the responses from the other participants to fill in the missing value 3. Regression substitution – You can use multiple-regression analysis to estimate a missing value 4. Multiple imputation - It creates plausible values based on the correlations for the missing data and then averages the simulated datasets by incorporating random errors in your predications.