Analysis
Generally, two types of analyses will be produced from a wealth survey: those oriented to a general audience, and more in-depth analyses of interest to academics or policy makers. The more general analysis is often made available at the time of the initial release of the wealth data set in order to publicise the release and highlight key findings. In-depth analysis usually takes more time and is often conducted by the more sophisticated users once the data are released by the organisation that conducted the survey. These analyses will be produced by a variety of users in various organisations and may be made available to the general public depending on the mandate of the individual or group sponsoring the analysis. In addition, the broad distribution of analysis based on the wealth data can be used to educate users on the correct interpretation of the wealth data.
Data tables
Data tables are one way to make a variety of data available to users who may not have the analytical skills, resources or data access required to produce their own output from the micro-data file of wealth data. Often the tabulated data are produced in a publication or in an on-line database to allow users to browse the data tables and choose those statistics that are of more interest to them. This is a way of providing broad access to a wide variety of data to a large number of users.
As noted in Chapter 3, there are many ways in which household wealth data can be grouped to look at different sub-sets of the population. Table 8.1 provides an example of how data for various groups can be presented in a table to provide a general picture of one aspect of wealth data, in this case net worth.
Table 8.1. Family net worth by selected characteristics of families in the United States
Thousands of 2010 US dollars
Family characteristic |
2004 |
2007 |
2010 |
|||
Median |
Mean |
Median |
Mean |
Median |
Mean |
|
All families |
107.2 |
517.1 |
126.4 |
584.6 |
77.3 |
498.8 |
Percentile of income | ||||||
Less than 20 |
8.6 |
83.6 |
8.5 |
110.3 |
6.2 |
116.8 |
20-39.9 |
38.8 |
139.8 |
39.6 |
141.3 |
25.6 |
127.9 |
40-59.9 |
82.8 |
224.0 |
92.3 |
220.6 |
65.9 |
199.0 |
60-79.9 |
184.0 |
392.9 |
215.7 |
393.9 |
128.6 |
294.0 |
80-89.9 |
360.9 |
563.7 |
373.2 |
638.1 |
286.6 |
567.3 |
90-100 |
1 070 |
2 925 |
1 172 |
3 475 |
1 194 |
2 944 |
Age of head (years) | ||||||
Less than 35 |
16.3 |
84.6 |
12.4 |
111.1 |
9.3 |
65.3 |
35-44 |
79.9 |
345.2 |
92.4 |
341.9 |
42.1 |
217.4 |
45-54 |
167.1 |
625.8 |
193.7 |
694.6 |
117.9 |
573.0 |
55-64 |
290.0 |
976.4 |
266.2 |
986.7 |
179.4 |
880.5 |
65-74 |
218.8 |
795.1 |
250.8 |
1.064.1 |
206.7 |
848.4 |
75 or more |
187.7 |
607.7 |
223.7 |
668.8 |
216.8 |
677.9 |
Family structure | ||||||
Single with child(ren) |
24.0 |
149.9 |
24.4 |
187.4 |
15.5 |
143.7 |
Single, no child, age less than 55 |
24.2 |
179.8 |
26.3 |
217.2 |
14.6 |
117.5 |
Single, no child, age 55 or more |
134.0 |
405.8 |
150.7 |
408.9 |
102.0 |
391.6 |
Couple with child(ren) |
140.6 |
580.5 |
147.5 |
629.1 |
86.7 |
555.7 |
Couple, no child |
240.2 |
868.2 |
236.2 |
998.6 |
205.7 |
864.8 |
Education of head | ||||||
No high school diploma |
23.7 |
157.1 |
34.8 |
149.7 |
16.1 |
110.7 |
High school diploma |
79.1 |
227.2 |
84.3 |
263.8 |
56.7 |
218.1 |
Some college |
79.8 |
355.7 |
88.8 |
384.5 |
50.9 |
272.2 |
College degree |
260.2 |
982.3 |
298.6 |
1 54.5 |
195.2 |
977.7 |
Table 8.1. Family net worth by selected characteristics of families in the United States
(cont.)
Family characteristic |
2004 |
2007 |
2010 |
|||
Median |
Mean |
Median |
Mean |
Median |
Mean |
|
Race or ethnicity of respondent | ||||||
White non-Hispanic |
162.2 |
648.3 |
179.4 |
727.4 |
130.5 |
654.5 |
Non-white or Hispanic |
28.5 |
176.2 |
29.7 |
240.3 |
20.4 |
175.9 |
Current work status of head | ||||||
Working for someone else |
77.4 |
310.7 |
98.5 |
369.1 |
55.2 |
298.8 |
Self-employed |
402.2 |
1 639.9 |
407.3 |
2 057.4 |
285.6 |
1 743.7 |
Retired |
160.9 |
539.8 |
169.9 |
569.1 |
151.1 |
485.3 |
Other not working |
13.6 |
186.7 |
6.0 |
130.1 |
11.9 |
137.5 |
Current occupation of head | ||||||
Managerial or professional |
227.3 |
995.6 |
258.8 |
1 174.8 |
167.3 |
1 047.0 |
Technical, sales, or services |
51.7 |
284.8 |
77.0 |
325.8 |
32.6 |
219.1 |
Other occupation |
65.0 |
169.8 |
68.4 |
201.3 |
46.6 |
162.8 |
Retired or other not working |
127.9 |
485.0 |
135.6 |
500.6 |
93.5 |
410.4 |
Region | ||||||
Northeast |
186.1 |
655.0 |
167.1 |
684.6 |
119.9 |
615.2 |
Midwest |
132.4 |
503.8 |
112.7 |
491.2 |
68.4 |
399.8 |
South |
73.4 |
401.0 |
102.0 |
525.9 |
68.2 |
440.8 |
West |
109.3 |
605.3 |
164.1 |
695.4 |
73.4 |
599.9 |
Urban status | ||||||
Metropolitan statistical area (MSA) |
120.1 |
582.0 |
138.8 |
652.6 |
78.4 |
553.6 |
Non-MSA |
68.2 |
203.5 |
82.0 |
253.9 |
74.5 |
236.1 |
Housing status | ||||||
Owner |
212.6 |
720.9 |
246.0 |
817.6 |
174.5 |
713.4 |
Renter or other |
4.6 |
62.3 |
5.4 |
74.7 |
5.1 |
57.2 |
Percentile of net worth | ||||||
Less than 25 |
2.0 |
-1.6 |
1.3 |
-2.3 |
.. -12.8 |
|
25-49.9 |
50.2 |
54.2 |
56.8 |
60.9 |
32.2 |
35.6 |
50-74.9 |
196.7 |
213.7 |
230.8 |
238.6 |
157.2 |
168.9 |
75-89.9 |
586.7 |
608.4 |
601.2 |
616.7 |
482.7 |
527.9 |
90-100 |
1 645.5 |
3 591.1 |
1 991.9 |
4176.9 |
1 864.1 |
3 716.4 |
..: Less than 0.05 (USD 50).
Source: United States Federal Reserve Bulletin, June 2012 article, “Changes in US Family Finances from 2007 to 2010”, Table 4, pp. 17-18.
As the power of desktop computing increases, so has the potential for statistical organisations to provide users with the ability to customise the tabular output to meet their own specific requirements through the use of self-help web-based table-builder products. Often the starting point of such products is aggregate data at the lowest level of detail possible from the micro-data file. Then users are provided with options on how to build their own tables based on the themes or variables of interest. One of the advantages of starting with aggregate data, rather than a micro-data file, is that less computing power is needed to group aggregate data than to produce tabulations for large micro-data files. Another advantage to this approach is that the detailed aggregate data can be screened for confidentiality prior to being made available to the general user population. An example of this type of product is the OECD.Stat web browser, which provides a single online platform for access to statistical databases from the OECD (http://stats.oecd.org).