Females 1860-1880
Make sure you can do the calculations by hand before running this.
Enter the number of people who died in each age class in Column B.
Human Life Table
Age (yr) Obs # that died # Alive at start of interval # Dying # Surviving Mort. Rate Surv. Rate
x in age class nx dx lx qx Sx
0-9.99 0 0 1000 #DIV/0! #DIV/0!
10-19.99 0 0 #DIV/0! #DIV/0! #DIV/0!
20-29.99 0 0 #DIV/0! #DIV/0! #DIV/0!
30-39.99 0 0 #DIV/0! #DIV/0! #DIV/0!
40-49.99 0 0 #DIV/0! #DIV/0! #DIV/0!
50-59.99 0 0 #DIV/0! #DIV/0! #DIV/0!
60-69.99 0 0 #DIV/0! #DIV/0! #DIV/0!
70-79.99 0 0 #DIV/0! #DIV/0! #DIV/0!
80-89.99 0 0 #DIV/0! #DIV/0! #DIV/0!
90+ 0 0 #DIV/0! #DIV/0! #DIV/0!
sum of # dying=
0
Survivorship Curve Linear Scale Survivorshi
3.5 1200
3
Log(Survival)
1000
2.5
2 800
1.5 600
lx
1 400
0.5
0 200
0
Years
Avg # Alive Life Expec For Graph
Lx Tx ex log(lx)
#DIV/0! #DIV/0! #DIV/0! 3
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
near Scale Survivorship Curve
Years
Males 1860-1880
Make sure you can do the calculations by hand before running this.
Enter the number of people who died in each age class in Column B.
Human Life Table
Age (yr) Obs # that died # Alive at start of interval # Dying # Surviving Mort. Rate Surv. Rate
x in age class nx dx lx qx Sx
0-9.99 0 0 1000 #DIV/0! #DIV/0!
10-19.99 0 0 #DIV/0! #DIV/0! #DIV/0!
20-29.99 0 0 #DIV/0! #DIV/0! #DIV/0!
30-39.99 0 0 #DIV/0! #DIV/0! #DIV/0!
40-49.99 0 0 #DIV/0! #DIV/0! #DIV/0!
50-59.99 0 0 #DIV/0! #DIV/0! #DIV/0!
60-69.99 0 0 #DIV/0! #DIV/0! #DIV/0!
70-79.99 0 0 #DIV/0! #DIV/0! #DIV/0!
80-89.99 0 0 #DIV/0! #DIV/0! #DIV/0!
90+ 0 0 #DIV/0! #DIV/0! #DIV/0!
sum of # dying=
0
Survivorship Curve Linear scale survivorship
3.5 1200
3
Log(Survival)
1000
2.5
2 800
1.5 600
lx
1 400
0.5
0 200
0
Years
Avg # Alive Life Expec For Graph
Lx Tx ex log(lx)
#DIV/0! #DIV/0! #DIV/0! 3
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
ear scale survivorship curve
Years
Females 1900-1920
Make sure you can do the calculations by hand before running this.
Enter the number of people who died in each age class in Column B.
Human Life Table
Age (yr) Obs # that died # Alive at start of interval # Dying # Surviving Mort. Rate Surv. Rate
x in age class nx dx lx qx Sx
0-9.99 0 0 1000 #DIV/0! #DIV/0!
10-19.99 0 0 #DIV/0! #DIV/0! #DIV/0!
20-29.99 0 0 #DIV/0! #DIV/0! #DIV/0!
30-39.99 0 0 #DIV/0! #DIV/0! #DIV/0!
40-49.99 0 0 #DIV/0! #DIV/0! #DIV/0!
50-59.99 0 0 #DIV/0! #DIV/0! #DIV/0!
60-69.99 0 0 #DIV/0! #DIV/0! #DIV/0!
70-79.99 0 0 #DIV/0! #DIV/0! #DIV/0!
80-89.99 0 0 #DIV/0! #DIV/0! #DIV/0!
90+ 0 0 #DIV/0! #DIV/0! #DIV/0!
sum of # dying=
0
Survivorship Curve Linear scale survivorshi
3.5 1200
3 1000
Log(Survival)
2.5 800
2
1.5 600
1 lx 400
0.5 200
0
0
Years
Avg # Alive Life Expec For Graph
Lx Tx ex log(lx)
#DIV/0! #DIV/0! #DIV/0! 3
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
near scale survivorship curve
Years
Males 1900-1920
Make sure you can do the calculations by hand before running this.
Enter the number of people who died in each age class in Column B.
Human Life Table
Age (yr) Obs # that died # Alive at start of interval # Dying # Surviving Mort. Rate Surv. Rate
x in age class nx dx lx qx Sx
0-9.99 0 0 1000 #DIV/0! #DIV/0!
10-19.99 0 0 #DIV/0! #DIV/0! #DIV/0!
20-29.99 0 0 #DIV/0! #DIV/0! #DIV/0!
30-39.99 0 0 #DIV/0! #DIV/0! #DIV/0!
40-49.99 0 0 #DIV/0! #DIV/0! #DIV/0!
50-59.99 0 0 #DIV/0! #DIV/0! #DIV/0!
60-69.99 0 0 #DIV/0! #DIV/0! #DIV/0!
70-79.99 0 0 #DIV/0! #DIV/0! #DIV/0!
80-89.99 0 0 #DIV/0! #DIV/0! #DIV/0!
90+ 0 0 #DIV/0! #DIV/0! #DIV/0!
sum of # dying=
0
Survivorship Curve Linear scale survivorshi
3.5 1200
3
Log(Survival)
1000
2.5
2 800
1.5 600
lx
1 400
0.5
0 200
0
Years
Avg # Alive Life Expec For Graph
Lx Tx ex log(lx)
#DIV/0! #DIV/0! #DIV/0! 3
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
near scale survivorship curve
Years
Survivorship Curve
3.5
3
Log(Survival)
2.5
2 Males 1860-1880
Females 1860
1.5 Females 1900
Males 1900-1920
1
0.5
0
Years
Linear Scale Survivorship Curve
1200
1000
800
Males 1860-1880
Females 1860
600
lx
Females 1900
400 Males 1900-1920
200
0
0-9.99 10- 20- 30- 40- 50- 60- 70- 80- 90+
19.99 29.99 39.99 49.99 59.99 69.99 79.99 89.99
Years
Males 1860-1880
Females 1860-1880
Females 1900-1920
Males 1900-1920
Males 1860-1880
Females 1860-1880
Females 1900-1920
Males 1900-1920