Solving large‐data consistency problems at Statistics Netherlands using macro‐integration techniques

Nino Mushkudiani, Jacco Daalmans and Reinier Bikker

Statistica Neerlandica, 2018, vol. 72, issue 4, 553-573

Abstract: The generalized multivariate Denton model for achieving consistency between large accounting frameworks developed at Statistics Netherlands (SN) is originally intended for benchmarking of supply and use (SU) tables of national accounts. The success of this application in the production process triggered using the model for other processes within the office. Currently, at SN, many production processes of national accounts, but also other departments, use the modifications of this optimization model for achieving consistency of data obtained from different sources. These include reconciliation and benchmarking of SU tables and of institutional sector accounts, ESA (European system of accounts), revisions of SU tables, benchmarking of gross fixed capital formation, Population Census tables, and energy statistics figures. The mathematical model is based on a quadratic optimization function and combines different features, such as linear constraints, ratio constraints, weights, soft and hard constraints, and inequalities. The optimization problems we deal with can be very large, consisting of 500,000 variables and over 100,000 constraints. This optimization problem is solved using the commercially available software tool XPRESS and the free software tool R. For the reconciliation of trade and transport statistics, similar optimization techniques are used. In this paper, we give an overview of production processes at SN using macro‐integration techniques.

Date: 2018
References: View references in EconPapers View complete reference list from CitEc
Citations:

Downloads: (external link)
https://doi.org/10.1111/stan.12158

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:bla:stanee:v:72:y:2018:i:4:p:553-573

Ordering information: This journal article can be ordered from
http://www.blackwell ... bs.asp?ref=0039-0402

Access Statistics for this article

Statistica Neerlandica is currently edited by Miroslav Ristic, Marijtje van Duijn and Nan van Geloven

More articles in Statistica Neerlandica from Netherlands Society for Statistics and Operations Research
Bibliographic data for series maintained by Wiley Content Delivery ().