Hands-on Exercises for Age & Sex Structure



Hands-on Exercises for Session 3

Please complete all exercises using Viet Nam 2009 data

1. Population Pyramids (PYRAMID.xls)

a. Construct a population pyramid in Excel

b. Analyze the pyramid’s main features and note any potential errors in the data

2. Age (mis)reporting (AGESEX.xls, SINGAGE.xls)

a. Calculate and graph age ratios by 5-year, and if available 1-year, age groups

b. Calculate and plot the sex ratio by 5-year age group

c. Calculate the age-sex accuracy index

d. Identify terminal digits that seem to be preferred in the plot for either males or females

e. Analyze your results and note any potential errors in the data

3. Smooth the population by age and sex data and explain your results (AGESMTH.xls)

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download