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 (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.

"Get 15% discount on your first 3 orders with us"
Use the following coupon
"FIRST15"

Order Now