The Treasury

Global Navigation

Personal tools

Appendix D: Comparisons over time

Table 11: Link rates over time
  Unlinked Linked Percent linked
06/07 1,083 4,704 81.3%
07/08 1,326 5,631 80.9%
08/09 1,143 5,580 83.0%
09/10 918 5,412 85.5%
10/11 954 6,078 86.4%
11/12 1,089 6,081 84.8%
12/13 849 4,998 85.5%
13/14 1,191 5,652 82.6%
14/15 2,070 8,997 81.3%
Total 10,626 53,136 83.3%

Notes that because all counts have been randomly rounded to base 3, the people in each year may not sum to the total people in all years. Linked means linked to the IRD data.

Table 12: Mean HES and IRD total comparable income over time
HES year Mean IRD
overall income
(1)
Mean HES
overall income
(2)
Percentage
difference
(3)
06/07 28,451 29,351 3.2%
07/08 30,913 32,383 4.8%
08/09 31,576 33,493 6.1%
09/10 32,035 32,873 2.6%
10/11 32,638 34,280 5.0%
11/12 33,742 34,942 3.6%
12/13 35,595 37,020 4.0%
13/14 36,545 37,095 1.5%
14/15 35,914 37,581 4.6%
Overall average 33,286 34,609 4.0%

Notes: Values in columns (1) and (2) have been rounded to the nearest dollar. Means are calculated on the entire linked sample. IRD income is used as the denominator in the percentage difference calculation. Overall average weights each year by the number of people in that year.

Table 13: Conditional mean IRD and HES total comparable income over time
 HES Year Conditional mean
IRD income
(1)
Conditional mean
HES income
(2)
Percentage
difference
(3)
06/07 34,850 35,576 2.0%
07/08 37,371 38,418 2.7%
08/09 39,039 40,698 4.1%
09/10 39,449 40,110 1.6%
10/11 40,542 41,879 3.2%
11/12 42,424 42,832 1.0%
12/13 44,008 45,220 2.7%
13/14 45,066 45,423 0.8%
14/15 44,177 45,496 2.9%
Overall average 41,071 42,063 2.4%

Notes: Values in columns (1) and (2) have been rounded to the nearest dollar. Conditional means are calculated for people in the linked sample who have reported earnings in both data sources. IRD income is used as the denominator in the percentage difference calculation.

Table 14: Log comparable income over time
Year (1)
ln(HES
comparable
income)
(2)
ln(IRD
comparable
income)
(3)
ln(HES) - ln(IRD
comparable
income)
(4)
abs[ln(HES)
- ln(IRD)]
06/07 10.041 10.074 -0.033 0.348
  (1.126) (1.018) (0.77) (0.688)
07/08 10.165 10.129 0.036 0.305
  (1.006) (1.024) (0.62) (0.54)
08/09 10.226 10.199 0.027 0.293
  (0.998) (1.004) (0.616) (0.542)
09/10 10.201 10.182 0.019 0.307
  (1.059) (1.03) (0.665) (0.59)
10/11 10.237 10.216 0.021 0.303
  (1.04) (1.021) (0.656) (0.582)
11/12 10.293 10.271 0.022 0.288
  (1.028) (1.019) (0.649) (0.582)
12/13 10.326 10.313 0.012 0.287
  (0.989) (0.964) (0.614) (0.543)
13/14 10.333 10.323 0.01 0.297
  (1.032) (1.014) (0.635) (0.561)
14/15 10.335 10.316 0.02 0.305
  (1.009) (1) (0.63) (0.551)
Average 10.248 10.232 0.016 0.303
  (1.033) (1.014) (0.649) (0.574)
N 42,006 42,006 42,006 42,006

Notes: Columns (1) and (2) present mean of log HES and IRD comparable income in each year. Column (3) reports the difference of Column (1) and (2), ie, MEAN(ln_HES - ln_IRD). Column (4) reports the average of the absolute value of the log difference, ie, MEAN(ABS(ln_HES - ln_IRD)). All calculations are on the linked subsample people who have positive (greater than $1) reported incomes. The total reported in the last row has been randomly rounded to base 3.

Page top