## The Annals of Applied Statistics

- Ann. Appl. Stat.
- Volume 7, Number 4 (2013), 1983-2006.

### Calibrated imputation of numerical data under linear edit restrictions

Jeroen Pannekoek, Natalie Shlomo, and Ton De Waal

#### Abstract

A common problem faced by statistical institutes is that data may be missing from collected data sets. The typical way to overcome this problem is to impute the missing data. The problem of imputing missing data is complicated by the fact that statistical data often have to satisfy certain edit rules and that values of variables across units sometimes have to sum up to known totals. For numerical data, edit rules are most often formulated as linear restrictions on the variables. For example, for data on enterprises edit rules could be that the profit and costs of an enterprise should sum up to its turnover and that the turnover should be at least zero. The totals of some variables across units may already be known from administrative data (e.g., turnover from a tax register) or estimated from other sources. Standard imputation methods for numerical data as described in the literature generally do not take such edit rules and totals into account. In this article we describe algorithms for imputing missing numerical data that take edit restrictions into account and ensure that sums are calibrated to known totals. These algorithms are based on a sequential regression approach that uses regression predictions to impute the variables one by one. To assess the performance of the imputation methods, a simulation study is carried out as well as an evaluation study based on a real data set.

#### Article information

**Source**

Ann. Appl. Stat., Volume 7, Number 4 (2013), 1983-2006.

**Dates**

First available in Project Euclid: 23 December 2013

**Permanent link to this document**

https://projecteuclid.org/euclid.aoas/1387823307

**Digital Object Identifier**

doi:10.1214/13-AOAS664

**Mathematical Reviews number (MathSciNet)**

MR3161710

**Zentralblatt MATH identifier**

1283.62166

**Keywords**

Linear edit restrictions sequential regression imputation Fourier–Motzkin elimination benchmarking

#### Citation

Pannekoek, Jeroen; Shlomo, Natalie; De Waal, Ton. Calibrated imputation of numerical data under linear edit restrictions. Ann. Appl. Stat. 7 (2013), no. 4, 1983--2006. doi:10.1214/13-AOAS664. https://projecteuclid.org/euclid.aoas/1387823307