Why Missingness Needs Its Own Investigation
A renewal model may have a fully recorded outcome but an incomplete application predictor, such as annual mileage, vehicle use, or a telematics score. The first response should not be to delete every incomplete record or fill every gap with an average. Missingness can differ across renewal outcomes and policy groups, and either pattern may change what the modeling data represent.
This investigation has two distinct purposes. First, describe where and for whom values are missing. Second, choose a handling rule that can be reproduced when the model is fitted and when new renewal applications are scored. A difference in missingness rates is evidence of an association, not by itself proof of why values are missing.
Calculate rates using the relevant subset as the denominator. For example, to compare missingness by renewal outcome, divide the number of missing predictor values among renewed policies by the total number of renewed policies, and do the analogous calculation for nonrenewed policies. The share of all missing records that belong to a group answers a different question and should not be substituted for that rate.
Compare Outcomes and Groups Before Choosing a Rule
For each important predictor, summarize its missingness against the observed outcome and policy groups. A compact table can reveal whether a single overall rate hides important differences. If the outcome is binary, report the rate for each outcome level; for group comparisons, report rates within each group. Where practical, examine outcome and group together, because the overall outcome comparison can be affected by differences in group composition.
The usual missingness labels describe assumptions about the process, not conclusions that can be read directly from a table:
- Missing completely at random (MCAR): whether \(X\) is missing is independent of the observed data and the unobserved value of \(X\). This is a strong condition.
- Missing at random (MAR): after conditioning on observed information, whether \(X\) is missing does not depend on the unobserved value of \(X\). For instance, missingness might vary by an observed application channel.
- Missing not at random (MNAR): missingness still depends on the unobserved value of \(X\), even after conditioning on observed information. A missingness-rate table alone generally cannot establish or rule out this dependence.
A difference in rates by \(Y\) or \(G\) rules out the simplest interpretation that the observed missingness pattern is unrelated to those variables, but it does not establish MNAR. For instance, rates may differ by outcome because outcome groups have different mixes of observed policy groups. Conversely, similar rates across the groups inspected do not prove MCAR: unmeasured information or the unobserved values themselves may still affect missingness.
Worked Example: Comparing Missingness by Renewal Outcome
In a hypothetical training extract, annual mileage is missing for 180 of 1,200 renewed policies and 75 of 300 nonrenewed policies. Calculate each outcome-specific missingness rate, the overall rate, and the difference between the two outcome-specific rates. State what the comparison does and does not show.
Method. Calculate each rate using the total number of policies in that outcome group, then calculate the overall rate using all policies.
For renewed policies, the missingness rate is \(180/1{,}200=0.15\), or 15.00%. For nonrenewed policies, it is \(75/300=0.25\), or 25.00%. The difference, nonrenewed minus renewed, is \(25.00\%-15.00\%=10.00\) percentage points.
There are \(1{,}200+300=1{,}500\) policies and \(180+75=255\) missing mileage values. The overall rate is \(255/1{,}500=0.17\), or 17.00%. As a check, weighting the two group rates by their group sizes gives \((1{,}200/1{,}500)(0.15)+(300/1{,}500)(0.25)=0.12+0.05=0.17\).
Missingness is more common among the nonrenewed policies in this extract. This is an association with the recorded outcome; it does not show that missing mileage caused nonrenewal or reveal the missing mileage values. The common mistake is to report \(75/255\), the fraction of all missing values belonging to nonrenewed policies, as the nonrenewed missingness rate. That fraction is \(29.41\%\) and has the wrong denominator for the requested comparison.
Why Group Comparisons Can Change the Interpretation
A marginal comparison combines records from different groups. If groups have different sizes or different outcome rates, the combined rates can obscure the pattern within each group. The appropriate next step is to show the outcome-specific missingness rates within important policy groups, not to infer a mechanism from a single portfolio-wide percentage.
Worked Example: Checking Whether Group Composition Explains a Difference
In a hypothetical renewal portfolio, the following counts are recorded for one predictor:
| Policy group | Outcome | Missing predictor values | Total policies |
|---|---|---|---|
| A | Renewed | 90 | 300 |
| A | Not renewed | 30 | 100 |
| B | Renewed | 20 | 400 |
| B | Not renewed | 10 | 200 |
Calculate the outcome-specific rates within each group and the marginal rates. Explain why the marginal comparison alone is incomplete.
Within group A, the renewed rate is \(90/300=30.00\%\), and the nonrenewed rate is \(30/100=30.00\%\). Within group B, the renewed rate is \(20/400=5.00\%\), and the nonrenewed rate is \(10/200=5.00\%\). In each group, the two outcome-specific missingness rates are equal.
Across groups, the renewed total is \(300+400=700\), with \(90+20=110\) missing, for a rate of \(110/700=15.71\%\). The nonrenewed total is \(100+200=300\), with \(30+10=40\) missing, for a rate of \(40/300=13.33\%\). The marginal difference is \(15.71\%-13.33\%=2.38\) percentage points, even though there is no within-group difference in this table.
The explanation is visible in the group mix: \(300/700\) of renewed policies are in group A, compared with \(100/300\) of nonrenewed policies. Group A has a higher missingness rate than group B, so the different mixes affect the marginal rates. The correction to the common mistake “missingness is associated with renewal because the marginal rates differ” is to inspect the relevant group-specific rates before making that claim. This table still does not establish why values are missing.
A Justification for Stratified Missingness Rates
The effect of group composition follows from the law of total expectation. Let \(G\) be a discrete policy group and \(C\) the missingness indicator. Within a fixed outcome level, the overall missingness probability is a weighted average of the group-specific probabilities:
The weights \(P(G=g\mid Y=y)\) can differ by outcome. Consequently, the overall rates can differ even when \(P(C=1\mid G=g,Y=y)\) is the same across outcome levels within every group. The preceding example has exactly this structure: the within-group rates match, while the mixes of groups differ.
More generally, for a response \(Y\) and observed information \(Z\), the conditional-expectation identity is
This follows by conditioning the expectation of \(Y\), among records with \(C=1\), on the observed information \(Z\). If \(Z\) is discrete, the right-hand side can be written as \(\sum_z E[Y\mid Z=z,C=1]P(Z=z\mid C=1)\). If \(Z\) is continuous, the corresponding expression is an integral over the conditional distribution of \(Z\) given \(C=1\); the displayed sum is not valid for a general continuous \(Z\).
Choose a Handling Strategy That Can Be Reproduced
The handling rule depends on the modeling purpose, the extent and pattern of missingness, and what information will be available when a renewal application is scored. No single method is correct for every case.
- Complete-case analysis uses only records with all required predictors observed. It is simple, but it loses information and can change the modeled population when inclusion is selective. Do not assume it is harmless merely because the number of deleted rows seems small.
- Imputation replaces missing values with estimates based on observed data. A median or mode is simple and reproducible; a conditional rule can reflect known group differences. A single imputed value does not restore the uncertainty in the missing value, so it should not be presented as if it were observed.
- A missingness indicator records whether the value was missing and can be used alongside an imputed value when that pattern may carry predictive information. It does not, by itself, correct selection bias or establish a causal interpretation.
- A separate missing category may be operationally useful for a categorical predictor when “not supplied” is a meaningful recorded state. It should not be confused with an actual value of the predictor.
For a prediction task, any imputation or encoding rule used at scoring time must be computable from information available then. The renewal outcome is useful for diagnosing training data, but it is not available when predicting that outcome for a new application. Using it to impute a predictor for deployment would make the fitted procedure impossible to reproduce at prediction time and can leak target information into model fitting.
A reproducible procedure separates diagnosis from transformation. First describe missingness in the training data by outcome and relevant groups. Then define the handling rule using only permitted information. Estimate quantities such as group medians on the training set, store them with the model, and apply those same values to validation, test, and scoring records. Do not calculate a new median on each later data set. Specify a fallback for a group with no observed training values, as well as how an unseen group will be treated. Record which variables receive indicators and how missing and novel categories are encoded.
For each predictor, count observed and missing values, then calculate rates by outcome and policy group using each subset’s own denominator.
Check whether marginal differences persist within important groups. Treat observed associations as diagnostic evidence, not proof of MCAR, MAR, or MNAR.
Choose deletion, imputation, or explicit missingness encoding based on the modeling objective and the information available at scoring.
Fit preprocessing quantities on training data, save the rules, apply them unchanged to later data, and check that no scoring-time outcome is required.
Worked Example: Fitting and Applying Groupwise Median Imputation
A hypothetical training set records annual mileage in thousands of miles. Among urban policies, the observed values are 4, 6, 8, 10, 12, and 14; two other urban values are missing. Among rural policies, the observed values are 8, 10, 12, 14, and 16; one other rural value is missing. Specify a groupwise-median procedure, calculate its training medians, and apply it to a validation record with missing mileage.
Method. Calculate each median from observed training values in that group only. Impute missing mileage with the stored group median, and create an indicator equal to 1 when the original value was missing and 0 otherwise.
The sorted urban observed values are already \(4,6,8,10,12,14\). With six values, the median is the average of the third and fourth values: \((8+10)/2=9\) thousand miles. The sorted rural observed values are \(8,10,12,14,16\). With five values, the median is the third value, \(12\) thousand miles.
The two missing urban training values are each replaced by 9, and the missing rural training value is replaced by 12. Their missingness indicators are 1; indicators for the observed values are 0. A validation record in the urban group with missing mileage receives 9 thousand miles and indicator 1. A validation record in the rural group with missing mileage receives 12 thousand miles and indicator 1.
The values 9 and 12 are fitted once using the training data and stored for later use. The validation values do not contribute to those medians. If a new group has no stored median, the procedure must use a predeclared fallback based only on training data, or explicitly flag that the case needs another permitted handling rule. The common mistake is to recompute medians separately on validation data; that changes the transformation and makes model evaluation inconsistent.
Common Traps in a Renewal Case
- Using the wrong denominator. The percentage of missing records that renewed is not the missingness rate among renewed policies.
- Interpreting association as mechanism. Different rates by outcome or group do not prove that the outcome or the missing value caused missingness.
- Relying only on a portfolio-wide rate. A single rate can conceal group patterns or differences in group composition.
- Imputing with information unavailable at scoring. A model cannot use a future renewal outcome to fill in a predictor for a new application.
- Refitting preprocessing on validation or test data. Store training-derived values and apply them consistently, including a defined rule for groups not represented in training.
Check Your Understanding
For each problem, calculate the requested quantities and distinguish a descriptive pattern from a conclusion about its cause.
- A predictor is missing for 48 of 240 renewed policies and 30 of 120 nonrenewed policies. Calculate both outcome-specific rates, their difference, and the overall missingness rate. (Answer: renewed 20.00%; nonrenewed 25.00%; difference 5.00 percentage points; overall \(78/360=21.67\%\).)
- In group A, 60 of 200 values are missing; in group B, 20 of 400 are missing. Calculate each group’s rate and the portfolio rate. Does this establish MNAR? (Answer: A 30.00%; B 5.00%; overall \(80/600=13.33\%\); no, the rates do not establish MNAR.)
- Observed training values for a group are 3, 5, 7, 9, and 11. One training record and one validation record in that group have missing values. Under median imputation with an indicator, give the imputed values and indicators. (Answer: median \(7\); impute 7 for each missing value; each missingness indicator is 1.)
- Missingness rates are 10% for renewed and 20% for nonrenewed policies. State one justified conclusion and one conclusion that is not justified from these rates alone. (Answer: missingness is associated with the recorded outcome in this extract; the rates alone do not prove that missingness caused nonrenewal or establish MNAR.)
- A group median is calculated as 8,500 miles in training. A validation record in that group has missing mileage, and its renewal outcome is known for evaluation. What mileage should be used under a deployment-ready median-imputation rule, and should the outcome be used to calculate a new value? (Answer: use 8,500 miles and a missingness indicator of 1; do not use the outcome or refit the median on validation data.)