Mechanism, Method and Coverage in a Survey with 51 Percent Incomplete Records
← Chapter 202
Capstone 39 · Technical Report
Technical Report

Mechanism, Method and Coverage in a Survey with 51 Percent Incomplete Records

Four missing-data methods scored against known removed values, bias and interval coverage over 150 replications, and a delta-adjustment sensitivity analysis for a non-ignorable mechanism.

Data  1,400 respondents, county health assessment, gaps in three covariates
Estimands  Adjusted BMI coefficient on systolic BP; population mean household income
Validation  Removed values retained, so all methods are scored against the complete-data analysis
Where this comes from
Chapter Chapter 202 · Missing Data: What Dropping Rows Costs You
Part Part XXXIII · Capstone Projects: Specialized Methods
Dataset capstone-missing-data-imputation.xlsx
Notebook View the analysis

Abstract

Objective. To determine which missing-data method to adopt for a survey in which 51.2 percent of records are incomplete, and to establish whether either of two estimands is recoverable.

Design. Gaps were imposed on a complete extract under three mechanisms, so the removed values are available for scoring. Activity minutes were made MCAR at 15.5 percent. BMI was made MAR at 31.5 percent through a logistic model in systolic blood pressure and age, that is, dependent on the OUTCOME of the target regression. Income was made MNAR at 17.0 percent through a logistic model in income itself. Four methods were compared: complete-case, unconditional mean imputation, single conditional-mean imputation via iterative chained equations without noise, and proper multiple imputation with m = 20 combined by Rubin's rules. The entire study was then replicated 150 times to estimate bias and 95 percent interval coverage.

Result. The complete-data estimate was 0.980 mm Hg per BMI unit. Over 150 replications, coverage was 96.0 percent for complete data, 82.7 for complete-case, 78.0 for mean imputation, 88.7 for multiple imputation, and 2.7 percent for single conditional-mean imputation, which carried a bias of +0.330 against a between-replication standard deviation of 0.089. Fraction of missing information on the target coefficient was 25.4 percent. For mean income, all three feasible methods returned 59.4k against a true 68.2k; delta-adjustment located a tipping point at 35k.

1. Data and preprocessing

The extract contained 1,406 rows. Six duplicate respondent identifiers were removed. Three sentinel conventions were present and were converted to explicit missingness: -1 in activity minutes (204 rows), 999 in income (143 rows), and the string not measured in BMI (111 rows), the last of which caused the column to be read as object dtype. Naive completeness on the raw file reported 29.6 percent of rows affected; after sentinel conversion the figure was 51.2 percent, leaving 683 complete cases of 1,400.

2. Evidence on the mechanisms

ColumnMissingMean SBP when observedMean SBP when missingMechanism
Activity14.4%134.3134.9MCAR
BMI31.5%131.0141.7MAR, on the outcome
Income17.0%MNAR
Observed-data evidence. The income row cannot be filled from observed data, which is the definition of the problem.

Respondents missing BMI averaged 10.7 mm Hg higher systolic pressure and were 7.7 years older, both observed, so the mechanism is MAR. It is nonetheless the case that complete-case analysis is biased here, because the missingness depends on the regression outcome rather than only on covariates. For income, the true mean among non-responders was 110.9k against 59.4k among responders, a fact available only from the retained values.

3. Single-dataset estimates

MethodEstimateSE95% CI
Complete data0.9800.0550.872 to 1.087
Complete-case, n = 6830.8740.0770.724 to 1.025
Mean imputation0.8950.0720.753 to 1.037
Single regression imputation1.3240.0631.200 to 1.448
Multiple imputation, m = 200.9540.0660.826 to 1.083
Adjusted coefficient of BMI on systolic blood pressure, mm Hg per unit.

Three of the four feasible intervals contain the complete-data estimate on this realization, which is why a single dataset cannot discriminate between methods. Single regression imputation is both the furthest from the target and the narrowest of the methods using all n, having imputed BMI from a model containing the outcome and then analyzed the imputations as observations.

4. Bias and coverage over 150 replications

MethodMean estimateBiasSDCoverage
Complete data0.901+0.0010.05996.0%
Complete-case0.822-0.0780.07782.7%
Mean imputation0.814-0.0860.07178.0%
Single regression imputation1.230+0.3300.0892.7%
Multiple imputation, m = 60.882-0.0180.07388.7%
Target value 0.90. Coverage is the proportion of nominal 95 percent intervals containing it.
A bar chart of five methods against a dashed line at 95 percent: complete data 96 percent, complete-case 83, mean imputation 78, single regression imputation 3, multiple imputation 89.
Figure 1. Empirical coverage of nominal 95 percent intervals by method.

Mean imputation attenuates through variance reduction in the imputed covariate. Complete-case is biased downward because selection operates on the outcome. Single conditional-mean imputation is biased upward because the imputation model conditions on the outcome and contributes no imputation variance, producing intervals that are simultaneously displaced and too narrow. Multiple imputation retains a residual bias of -0.018 and coverage of 88.7 percent, attributable to the MNAR income covariate, which no MAR-based procedure can address.

5. A non-ignorable estimand

MethodMean household incomeGrant eligibility below $65k
Complete-case59.40kqualifies
Mean imputation59.40kqualifies
Multiple imputation, m = 2059.42kqualifies
Complete data68.16kdoes not qualify
Agreement among the three feasible methods reflects a shared MAR assumption, not corroboration.

A delta-adjustment was applied to the imputed income values, shifting each non-responder's imputation by a constant delta and recomputing the mean. With a 17.0 percent non-response rate the estimate rises by 0.17 per unit of delta, crossing the eligibility threshold at delta = 35k. The retained values imply an actual delta near 52k, 1.5 times the tipping point. The reportable quantity is the tipping point.

6. Limitations

The replication study is conditional on this data-generating process, these missingness rates and this imputation specification; the ordering of methods is not guaranteed to transfer, although the mechanism behind the single-imputation failure is general. The MAR assumption supporting the BMI estimand is untestable outside this constructed setting. Every arm used the same imputation model specification, so the comparison is not sensitive to misspecification of that model. Multiple imputation was run at m = 6 in the replication study for tractability against m = 20 in the primary analysis, which slightly understates its coverage.

From Statistics, Data Science and AI: A Visual Handbook by John Fisher. Every statistic, table, and figure in this report is reproduced by the companion notebook.