Run a frequency of child's age in months for the bdeshc.sav data set by clicking Statistics, then Summarize, and then Frequencies and choose the variable chage. A table of frequencies will appear showing the percentage of children that fall in each age category. It will be apparent that there are often double the number in the 12 month intervals and also increases in the 6 month intervals. Did you find there were 1.4% in the 11 month age group while there were 3.4% in the 12 month group?
CHAGE (Child age in months)
Age in months |
Frequency |
Percent |
Valid Percent |
Cumulative Percent |
0 |
17 |
.3 |
.3 |
.3 |
1 |
65 |
1.2 |
1.2 |
1.5 |
2 |
93 |
1.7 |
1.7 |
3.1 |
3 |
94 |
1.7 |
1.7 |
4.8 |
4 |
85 |
1.5 |
1.5 |
6.4 |
5 |
96 |
1.7 |
1.7 |
8.1 |
6 |
113 |
2.0 |
2.0 |
10.1 |
7 |
104 |
1.9 |
1.9 |
12.0 |
8 |
86 |
1.5 |
1.5 |
13.5 |
9 |
78 |
1.4 |
1.4 |
14.9 |
10 |
82 |
1.5 |
1.5 |
16.4 |
11 |
76 |
1.4 |
1.4 |
17.7 |
12 |
188 |
3.4 |
3.4 |
21.1 |
13 |
143 |
2.6 |
2.6 |
23.7 |
14 |
118 |
2.1 |
2.1 |
25.8 |
15 |
90 |
1.6 |
1.6 |
27.4 |
16 |
98 |
1.8 |
1.8 |
29.2 |
17 |
77 |
1.4 |
1.4 |
30.6 |
18 |
99 |
1.8 |
1.8 |
32.3 |
19 |
59 |
1.1 |
1.1 |
33.4 |
20 |
72 |
1.3 |
1.3 |
34.7 |
21 |
55 |
1.0 |
1.0 |
35.7 |
22 |
65 |
1.2 |
1.2 |
36.8 |
23 |
56 |
1.0 |
1.0 |
37.8 |
24 |
214 |
3.8 |
3.8 |
41.7 |
25 |
134 |
2.4 |
2.4 |
44.1 |
26 |
82 |
1.5 |
1.5 |
45.6 |
27 |
87 |
1.6 |
1.6 |
47.1 |
28 |
86 |
1.5 |
1.5 |
48.7 |
29 |
70 |
1.3 |
1.3 |
49.9 |
30 |
85 |
1.5 |
1.5 |
51.4 |
31 |
70 |
1.3 |
1.3 |
52.7 |
32 |
68 |
1.2 |
1.2 |
53.9 |
33 |
57 |
1.0 |
1.0 |
54.9 |
34 |
64 |
1.1 |
1.1 |
56.1 |
35 |
59 |
1.1 |
1.1 |
57.2 |
36 |
278 |
5.0 |
5.0 |
62.1 |
37 |
140 |
2.5 |
2.5 |
64.7 |
38 |
151 |
2.7 |
2.7 |
67.4 |
39 |
118 |
2.1 |
2.1 |
69.5 |
40 |
104 |
1.9 |
1.9 |
71.3 |
41 |
76 |
1.4 |
1.4 |
72.7 |
42 |
100 |
1.8 |
1.8 |
74.5 |
43 |
77 |
1.4 |
1.4 |
75.9 |
44 |
79 |
1.4 |
1.4 |
77.3 |
45 |
72 |
1.3 |
1.3 |
78.6 |
46 |
89 |
1.6 |
1.6 |
80.2 |
47 |
61 |
1.1 |
1.1 |
81.3 |
48 |
299 |
5.4 |
5.4 |
86.6 |
49 |
143 |
2.6 |
2.6 |
89.2 |
50 |
103 |
1.8 |
1.8 |
91.1 |
51 |
77 |
1.4 |
1.4 |
92.4 |
52 |
82 |
1.5 |
1.5 |
93.9 |
53 |
71 |
1.3 |
1.3 |
95.2 |
54 |
83 |
1.5 |
1.5 |
96.7 |
55 |
43 |
.8 |
.8 |
97.5 |
56 |
39 |
.7 |
.7 |
98.2 |
57 |
45 |
.8 |
.8 |
99.0 |
58 |
40 |
.7 |
.7 |
99.7 |
59 |
18 |
.3 |
.3 |
100.0 |
Total |
5573 |
100.0 |
100.0 |
Age heaping can also be detected by running a graph of the frequencies. This is shown below for the Cambodia data set.
The graph below clearly illustrates age heaping in the 1996 MICS survey of households in Cambodia.
To produce this graph, open the camb.sav (Cambodia MICS data) in SPSS.
- Click on the Graphs menu.
- Click on the Bar menu.
- Click on Simple
- Click on Define
- For Bars Represent, click on % of cases.
- For Category Axis, choose chage and click on the arrow.
- Click on OK.