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 (Nx). Use Table 10.1 on p. 228 as your template.
3. Estimate survivorship to a given age class (lx) by taking Nx for that age class and dividing it by the original number in the cohort (500). Create a column for lx.
4. Estimate survival rate (Sx) from class to class by dividing the number of individuals in a given class Nx by the number of individuals in the previous age class (N(x-1)). Plot Sx
5. Plot Nx 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.