A New Approach to Round Tabular Data
Controlled Rounding is a technique to replace each cell value in a table with a multiple of a base number such that the new table satisfies the same equations as the original table. Statistical agencies prefer a solution where cell values already multiple of the base number remain unchanged, while the others are one of the two closest multiple of the base number (i.e., rounded up or rounded down). This solution is called zero-restricted rounding. Finding such a solution is a very complicated problems, and on some tables it may not exist. This paper presents a mathematical model and an algorithm to find a good-enough near-feasible solution for tables where a zero-restricted rounding is complicated. It also presents computational results showing the behavior of the proposal in practice.
KeywordsFeasible Solution Base Number Protection Level Rounded Table Marginal Cell
Unable to display preview. Download preview PDF.
- 5.Cox, L.H., George, J.A.: Controlled rounding for tables with subtotals. Annals of Operations Research, 141–157 (1989)Google Scholar
- 6.Dalenius, T.: A simple procedure for controlled rounding. Statistisk Tidskrift 3, 202–208 (1981)Google Scholar
- 7.Fagan, J.T., Greenberg, B.V., Hemmig, R.: Controlled rounding of three dimensional tables. Technical report, Bureau of the Census, SRD/RR-88/02 (1988)Google Scholar
- 8.Fellegi, I.P.: Controlled random rounding. Survey Methodology, 123–133 (1975)Google Scholar
- 9.Moravek, J., Vlach, M.: On necessary conditions for the existence of the solution to the multi-index transportation problem. Operations Research, 542–545 (1967)Google Scholar