UHV Calculating Age Of Indivuduals

The obvious approach to the problem would be:

1. Calculate age-at-death for each individual

2. Classify the individuals into age categories (0-9; 10-19 … 100+, for example; you can go finer with 5 year interval, but that’s too much work) based on the age-at-death; determine the number of individuals in each age category (use Excel for binning, or do it by hand). Create a column of age categories (x)

3. Calculate how many survivors you have after each age interval (for example, if 5 people died in 1-9 category, you have 500-5=495 survivors going into 10-19 age class; if 10 people died in 10-19 age class, you have 495-10=485 survivors going into 20-29 class, etc.); create a column of survivors (N_x). Use Table 10.1 on p. 228 as your template.

3. Estimate survivorship to a given age class (l_x) by taking N_x for that age class and dividing it by the original number in the cohort (500). Create a column for l_x.

4. Estimate survival rate (S_x) from class to class by dividing the number of individuals in a given class N_x by the number of individuals in the previous age class (N_(x-1)). Plot S_x

5. Plot N_x on the Y-axis with x on the X-axis; make sure to change the Y-axis to semi-log. What is the shape of the survivorship curve? What type of curve do you call that?

I want it in a table and a graph.