Tutorials › Multiple Imputation by Chained Equations (MICE) › Diagnosing Heaping and Rounding Artifacts

Convergence and Diagnostics Against Observed Data · Tutorial 230 of 497

Diagnosing Heaping and Rounding Artifacts

Compare observed and imputed value patterns to identify lost heaping, artificial rounding, and precision that the measurement process does not support.

Advanced 12 min read

What You'll Learn

  • Define heaping and rounding patterns using the measurement scale and recording process
  • Calculate and compare selected value frequencies in observed and imputed values
  • Detect when imputations lose a genuine heaping pattern or introduce unsupported decimal places
  • Distinguish a diagnostic warning from evidence of a defective imputation model
  • Choose whether a pattern calls for a changed imputation model, a measurement-aware model, or no correction

Why Digit Patterns Matter

Two sets of measurements can have similar centers and spreads while differing in how their values are recorded. Self-reported ages may cluster at multiples of five or ten; a device may record a laboratory measurement to the nearest tenth; and a fitted imputation model may instead generate smooth values at arbitrary decimal places. These patterns can reveal information about measurement and recording that is not obvious in a density plot or summary of means and standard deviations.

In MICE, the observed values and imputed values are not generally interchangeable samples. Observed values belong to people whose measurements were recorded, while imputed values fill in measurements missing for other people. Their marginal patterns may differ for legitimate reasons, including differences in predictors or in the missingness mechanism. A digit-pattern comparison is therefore a diagnostic question: are the imputed values compatible with the measurement process, and is there a discrepancy that the imputation model should explain?

Definition: Heaping is an excess frequency of values at particular points, such as multiples of five or ten, relative to nearby values. Rounding is the recording of a value to a specified resolution, such as the nearest integer or tenth. A value has unsupported precision when its recorded digits imply a level of measurement detail that the actual measurement or recording process did not provide.

Define the Pattern Before Counting It

A useful check begins with the variable’s meaning and measurement history, not with a convenient digit test. Ask whether the variable is a count, a self-report, a device measurement, or a value transformed from another measurement. Establish the units and the smallest meaningful or recorded increment. An integer-valued count has a different support from a continuous measurement rounded to the nearest integer. Likewise, an age recorded in whole years may reflect both the measurement convention and respondents’ tendency to report preferred ages.

For a specified event \(A\), such as “the value is a multiple of five,” calculate its frequency among observed values and among imputed values. If \(O\) denotes the indices with observed measurements and \(M\) the indices with missing measurements, one simple comparison is:

$$ \hat q_{\mathrm{obs}}(A)=\frac{1}{|O|}\sum_{i\in O} I(Y_i\in A), \qquad \hat q_{\mathrm{imp}}^{(l)}(A)=\frac{1}{|M|}\sum_{i\in M} I(Y_i^{(l)}\in A). $$

Here \(I(\cdot)\) equals one when the condition is true and zero otherwise, and \(l\) identifies an imputed data set. Calculate the imputed frequency separately in each completed data set, then summarize its variation across imputations. Do not pool all imputed cells across imputations and treat them as independent observations: each set of imputations represents uncertainty about the same missing entries.

The comparison is descriptive. Even if observed and imputed values are generated under a well-specified model, their marginal pattern need not match: the missing cases can differ from the observed cases. Under missing completely at random, marginal patterns might be expected to agree apart from sampling and imputation variability, but that expectation does not hold in general under missing at random. More directly, if the measurement process is the same for both groups, imputed values should normally respect its units, support, and recording resolution. That requirement is not the same as demanding identical frequencies of every digit.

Worked Example: Checking for Lost Heaping

Suppose a hypothetical questionnaire records age in whole years. Among 120 observed ages, 54 are multiples of five. In one completed data set, 15 of the 60 imputed ages are multiples of five. Calculate the two frequencies and interpret their difference.

For the observed values, the multiple-of-five frequency is \(54/120=0.450\), or 45.0%. For the imputed values, it is \(15/60=0.250\), or 25.0%. The difference, imputed minus observed, is \(0.250-0.450=-0.200\), or −20.0 percentage points.

This is a substantial descriptive discrepancy: the imputations show less heaping at multiples of five than the observed values. If the heaping reflects how respondents report their ages, the imputation model may be smoothing away a feature of the recorded data. But these groups contain different people, so the result alone does not establish a modeling error. Check whether age heaping is plausible for the target group and whether the missing cases could have a different age distribution. A conditional comparison or a measurement-aware imputation model may be needed before concluding that the pattern was lost.

Connect the Pattern to the Recording Rule

A fixed rounding rule creates a lattice of possible recorded values. If a continuous measurement \(X\) is reported to the nearest increment \(u\), the recorded value is \(R=u\,\mathrm{round}(X/u)\). Thus \(R\) can take values spaced \(u\) units apart. For example, values reported to the nearest tenth lie on a grid of tenths. An imputed value with additional nonzero digits may be incompatible with the recorded variable, even if it is a plausible value for an unobserved latent measurement.

$$ R=u\,\mathrm{round}(X/u) \quad\Longrightarrow\quad R\in\{\ldots,-u,0,u,2u,\ldots\}. $$

This distinction depends on what is being imputed. If the analysis concerns the recorded measurement, the imputation should represent values at the recorded resolution. If the scientific target is the underlying unrounded quantity, imputing a latent value is a different modeling task: a recorded value \(R=r\) corresponds to an interval of possible latent values, approximately from \(r-u/2\) to \(r+u/2\), rather than revealing the exact \(X\). Silently treating the recorded number as exact or rounding arbitrary model draws can each misrepresent the target.

Worked Example: Detecting Unsupported Decimal Places

Consider hypothetical assay results reported to the nearest 0.1 unit. Eighty observed values are all recorded with one decimal place. Among 40 imputed results from one completed data set, 28 have a nonzero hundredths digit. Compare the frequencies.

The observed frequency of a nonzero hundredths digit is \(0/80=0\). The corresponding imputed frequency is \(28/40=0.700\), or 70.0%. For example, an imputed value of 4.27 units has a nonzero hundredths digit, whereas 4.20 units is represented at the stated tenth-unit resolution.

If the analysis variable is the assay result as recorded, the many hundredths digits are unsupported by this recording rule. The model may be producing smooth continuous draws rather than values on the recorded grid. A suitable response is to revisit how the outcome is represented and imputed. Rounding all draws to tenths might be appropriate if the estimand is the recorded result, but it is not automatically harmless: rounding changes values and can affect variation and associations. If the target is an underlying continuous quantity, the model should instead represent the relationship between that quantity and the rounded observations.

Quantify and Investigate the Discrepancy

A rate difference is easy to communicate, but its interpretation depends on the pattern selected. For terminal digits, one may compare the full distribution of last digits rather than only grouping values into “round” and “not round.” For measurements rounded to a known increment, count values on the permitted grid and values off it. For a suspected heaping point, compare its frequency with frequencies at nearby values. State the rule in advance and report counts as well as percentages; a percentage based on a few observed values can be unstable.

The following justification explains why a grid check is appropriate when the recorded variable is rounded. If every recorded value is rounded to increment \(u\), then by the recording rule each value equals an integer multiple of \(u\). Therefore, an off-grid imputed value cannot be a possible value of that recorded variable under the same rule. This establishes a compatibility warning, not the cause of the warning: the model may be targeting the latent quantity, the recording rule may have been misstated, or the imputation implementation may be inappropriate.

Worked Example: Comparing Terminal-Digit Heaping

In a hypothetical data set, weekly work hours are self-reported as whole numbers. Of 150 observed reports, 72 end in zero or five. Of 60 imputed reports, 18 end in zero or five. Calculate the proportions, their difference, and their ratio.

The observed proportion is \(72/150=0.480\), or 48.0%. The imputed proportion is \(18/60=0.300\), or 30.0%. The difference is \(0.300-0.480=-0.180\), a decrease of 18.0 percentage points. The ratio is \(0.300/0.480=0.625\).

Thus the imputed values show 62.5% of the observed rate of reports ending in zero or five. This could indicate that the imputation model does not reproduce the response heaping present in self-reports. It is not proof: the missing respondents might report work hours differently, or their true conditional distribution might have fewer round values. Review the measurement context and the model’s conditional behavior before deciding whether to change the imputation procedure.

Compare Diagnostics and Recognize Failure Modes

DiagnosticWhat it can revealMain limitation
Counts or proportions at selected valuesExcess frequency at multiples of five, ten, or another meaningful pointResults depend on choosing a substantively justified pattern
Terminal-digit frequenciesOverrepresentation or loss of particular last digitsDigits can reflect the variable’s real distribution, not just reporting behavior
On-grid versus off-grid countsWhether values respect a known rounding incrementOnly interpretable when the target variable and resolution are clear
Histograms or density comparisonsBroad shape differences that may accompany heapingMay conceal individual digit patterns or depend on display choices

Common failure modes include assuming every multiple-of-five pattern is a defect, treating observed and imputed marginal proportions as if they must be equal, and examining just one completed data set. A digit pattern may be a genuine feature of self-report, a consequence of a device, or an artifact of data processing. Conversely, a smooth-looking imputed distribution can conceal an important mismatch in recording resolution. Review value frequencies alongside the data dictionary, units, and known measurement procedures.

Avoid using a uniform terminal-digit distribution as a default benchmark. Uniformity is justified only when the variable and its measurement process make that benchmark plausible. For example, genuine ages or work hours need not have equally frequent terminal digits. Likewise, an apparent excess of zeroes may come from a real mass at zero rather than rounding. Comparing nearby values and understanding the measurement process are more informative than mechanically declaring any unequal digit frequencies suspicious.

Choose a Response Proportional to the Evidence

When imputations lose a plausible heaping pattern, investigate whether the imputation model represents the process that generated the recorded values. When they contain unsupported precision, first clarify whether the target is the recorded or latent measurement. Depending on that answer, a model that respects the recording scale, an explicit measurement model, or a justified post-processing rule may be considered. Any change should be checked for its effects on distributions and on the substantive analyses; post hoc rounding is not a universal repair.

These checks complement rather than replace distributional comparisons. Density plots and empirical distribution functions can reveal broad shape differences, while targeted digit counts can reveal fine-scale patterns. A pattern discrepancy is a reason to investigate, not a standalone test of validity or a guarantee that a revised model is correct. Sparse observed values, uncertain recording histories, and differences between observed and missing cases all limit what can be concluded from the marginal comparison.

Key takeaway: Define a heaping or rounding pattern from the measurement process, calculate its frequency among observed and imputed values, and interpret any discrepancy in context. Compatibility with the recorded resolution is often a clearer requirement than equality of marginal digit frequencies.

Check Your Understanding

Answer each question, then compare with the solution immediately below it.

  1. A variable is recorded to the nearest integer. In a completed data set, 9 of 30 imputed values have a nonzero decimal part. What is the frequency, and what does it suggest?
  2. Among 100 observed ages, 40 are multiples of ten; among 50 imputations, 15 are. Find both proportions and their difference, imputed minus observed.
  3. Why is a difference between observed and imputed heaping proportions not, by itself, proof of a defective imputation model?
  4. A laboratory reports a measurement to the nearest tenth, but the analysis seeks the underlying unrounded quantity. Should all imputations simply be rounded to tenths? Explain.

Solutions. (1) \(9/30=0.300\), or 30.0%. If the target is the recorded integer variable, decimal values are incompatible with its resolution and warrant investigation; this does not establish why they arose. (2) The observed proportion is \(40/100=0.400\); the imputed proportion is \(15/50=0.300\). The difference is \(0.300-0.400=-0.100\), or −10.0 percentage points. (3) Imputed and observed values belong to different cases, and those cases can have different distributions. The comparison is diagnostic and must be interpreted with the missingness and measurement context in mind. (4) No. Rounding would discard information about the latent target. If the goal is the underlying quantity, the model should account for the fact that observed values represent intervals of possible underlying values rather than exact measurements.

Clinical Biostats