Age Heaping Effect

Return to Data Cleaning

Exercise 1 :

Run a frequency to see the age heaping in the Bangladesh data set by doing the following:

1.  Open SPSS data base bdeshage.sav

2.  In the Data Editor, click on Statistics, then Summarize, then Frequencies, then choose the variable age and place it in the variable box by clicking the > arrow key.

3.  Look at the table of frequencies that shows the percentage of children that are in each age category. 

4.  Is there a pattern where certain months have higher percentages?  Which months are they?

5.  What percent are in the 23 month age group?  In the 24 month group?



It will be apparent that there are often double the number in the 12 month intervals and as well as  increases in the 6 month intervals. This is especially evident for older age groups. You should have found that there were 1.7% in the 23 month age group while there were 4.0% in the 24 month group.



Age heaping can also be detected by running a graph of the frequencies in the bdeshage.sav. Create the graph as follows:

1.  Click on the Graphs menu.

2.  Click on the Bar menu.

3.  Click on Simple

4.  Click on Define

5.  For Bars Represent, click on % of cases.

6.  For Category Axis, choose age and click on the arrow.

7.  Click on OK.



Does your graph look like the one below?

ex3_1.jpg (36171 bytes)


Return to Top of Page