For Natural Science Guru

profileMylifeiznme
lab3_cemeterylabworksheet__1_.xls
Home>Physics homework help>For Natural Science Guru

template- 2 lines on graph

dx= number dying during age interval x to x+1
nx= number alive at start of age interval x
lx= proportion surviving to start age interval x
1. Notice the two cells highlighted in yellow and labelled "Category 1" and "Category 2". Replace the generic names with more specific names.
For example, Category 1 might be "Females" and Category 2 might be "Males." Just type right into the same cells where "Category 1" and "Category 2" currently appear.
2. From your data, determine the number of people of each age class who died while at that age. These are your dx numbers.
Enter these numbers in the dx columns highlighted in yellow; the rest of the table and the graph should appear automatically
3. If you want to see an example of a filled-in worksheet, go to the "example" worksheet within this spreadsheet- click on the example tab at the bottom of the spreadsheet.
Category 1 Category 2
Age class Age at start x dx nx lx log(1000*lx) dx nx lx log(1000*lx)
0-9 0 0 0 0 0 0 0 0
10-19 10 1 0 0 0 0 0 0
20-29 20 2 0 0 0 0 0 0
30-39 30 3 0 0 0 0 0 0
40-49 40 4 0 0 0 0 0 0
50-59 50 5 0 0 0 0 0 0
60-69 60 6 0 0 0 0 0 0
70-79 70 7 0 0 0 0 0 0
80-89 80 8 0 0 0 0 0 0
90-99 90 9 0 0 0 0 0 0
100-109 100 10 0 0 0 0 0 0
110-119 110 11 0 0 0 0 0 0
120+ 120 12 0 0 0 0 0 0
Total 0 0

template- 2 lines on graph
Category 1
Category 2
Age (years)
log(1000*lx)

template- 4 lines on graph

dx= number dying during age interval x to x+1
nx= number alive at start of age interval x
lx= proportion surviving to start age interval x
1. See the worksheet "template- 2 lines on graph" for more detailed instructions
cohort1 Females, Cohort 1 Males, Cohort 1
Age class Age at start x dx nx lx log(1000*lx) dx nx lx log(1000*lx)
0-9 0 0 0 0 0 0 0 0
10-19 10 1 0 0 0 0 0 0
20-29 20 2 0 0 0 0 0 0
30-39 30 3 0 0 0 0 0 0
40-49 40 4 0 0 0 0 0 0
50-59 50 5 0 0 0 0 0 0
60-69 60 6 0 0 0 0 0 0
70-79 70 7 0 0 0 0 0 0
80-89 80 8 0 0 0 0 0 0
90-99 90 9 0 0 0 0 0 0
100-109 100 10 0 0 0 0 0 0
110-119 110 11 0 0 0 0 0 0
120+ 120 12 0 0 0 0 0 0
Total 0 0
cohort2 Females, Cohort 2 Males, Cohort 2
Age class Age at start x dx nx lx log(1000*lx) dx nx lx log(1000*lx)
0-9 0 0 0 0 0 0 0 0
10-19 10 1 0 0 0 0 0 0
20-29 20 2 0 0 0 0 0 0
30-39 30 3 0 0 0 0 0 0
40-49 40 4 0 0 0 0 0 0
50-59 50 5 0 0 0 0 0 0
60-69 60 6 0 0 0 0 0 0
70-79 70 7 0 0 0 0 0 0
80-89 80 8 0 0 0 0 0 0
90-99 90 9 0 0 0 0 0 0
100-109 100 10 0 0 0 0 0 0
110-119 110 11 0 0 0 0 0 0
120+ 120 12 0 0 0 0 0 0
Total 0 0

template- 4 lines on graph
Females, Cohort 1
Males, Cohort 1
Females, Cohort 2
Males, Cohort 2
Age (years)
log(1000*lx)

example

dx= number dying during age interval x to x+1
nx= number alive at start of age interval x
lx= proportion surviving to start age interval x
Data from the burial records of Trinity Church, an Episcopalian parish in St. Mary's City, Maryland
(http://ftp.rootsweb.com/pub/usgenweb/md/stmary/cemeteries/trinity.txt)
Born 1801-1850 Females born 1801-1851 Males born 1801-1850
Age class Age at start x dx nx lx log(1000*lx) dx nx lx log(1000*lx)
0-9 0 0 4 83 1 3 9 92 1 3
10-19 10 1 1 79 0.9518072289 2.9785489989 1 83 0.902173913 2.955290265
20-29 20 2 7 78 0.9397590361 2.9730165103 7 82 0.8913043478 2.950026025
30-39 30 3 4 71 0.8554216867 2.9321802563 6 75 0.8152173913 2.911273436
40-49 40 4 4 67 0.8072289157 2.9069967103 10 69 0.75 2.8750612634
50-59 50 5 7 63 0.7590361446 2.8802624571 11 59 0.6413043478 2.8070641843
60-69 60 6 14 56 0.6746987952 2.8291099346 20 48 0.5217391304 2.71745341
70-79 70 7 24 42 0.5060240964 2.704171198 16 28 0.3043478261 2.483370204
80-89 80 8 14 18 0.2168674699 2.3361944127 11 12 0.1304347826 2.1153934187
90-99 90 9 4 4 0.0481927711 1.682981899 1 1 0.0108695652 1.0362121727
100-109 100 10 0 0 0 0 0 0 0 0
110-119 110 11 0 0 0 0 0 0 0 0
120+ 120 12 0 0 0 0 0 0 0 0
Total 83 92
Born 1851-1900 Females born 1851-1900 Males born 1851-1900
Age class Age at start x dx nx lx log(1000*lx) dx nx lx log(1000*lx)
0-9 0 0 13 157 1 3 17 142 1 3
10-19 10 1 4 144 0.9171974522 2.9624628397 4 125 0.8802816901 2.9446216686
20-29 20 2 7 140 0.8917197452 2.9502283833 9 121 0.8521126761 2.9304970259
30-39 30 3 6 133 0.847133758 2.9279519886 5 112 0.7887323944 2.8969296783
40-49 40 4 6 127 0.8089171975 2.9079040685 4 107 0.7535211268 2.8770954333
50-59 50 5 11 121 0.7707006369 2.8868857179 14 103 0.7253521127 2.8605488803
60-69 60 6 23 110 0.7006369427 2.8454930327 22 89 0.6267605634 2.7971016623
70-79 70 7 35 87 0.5541401274 2.7436196002 35 67 0.4718309859 2.6737864583
80-89 80 8 35 52 0.3312101911 2.5201036912 26 32 0.2253521127 2.3528616339
90-99 90 9 15 17 0.1082802548 2.034549269 6 6 0.0422535211 1.625862906
100-109 100 10 2 2 0.0127388535 1.1051303433 0 0 0 0
110-119 110 11 0 0 0 0 0 0 0 0
120+ 120 12 0 0 0 0 0 0 0 0
Total 157 142
The data shown below are not included in the graph- they are included as an extra example
Born 1901-1950 Females Males
Age class Age at start x dx nx lx log(1000*lx) dx nx lx log(1000*lx)
0-9 0 0 7 67 1 3 15 114 1 3
10-19 10 1 3 60 0.8955223881 2.9520764477 7 99 0.8684210526 2.9387303433
20-29 20 2 0 57 0.8507462687 2.929800053 9 92 0.8070175439 2.906882976
30-39 30 3 2 57 0.8507462687 2.929800053 1 83 0.7280701754 2.862173241
40-49 40 4 11 55 0.8208955224 2.9142878868 7 82 0.7192982456 2.856909001
50-59 50 5 3 44 0.6567164179 2.8173778738 20 75 0.6578947368 2.8181564121
60-69 60 6 10 41 0.6119402985 2.786709054 16 55 0.4824561404 2.6834578382
70-79 70 7 14 31 0.4626865672 2.6652868911 24 39 0.3421052632 2.5341597557
80-89 80 8 14 17 0.2537313433 2.4043741187 11 15 0.1315789474 2.1191864077
90-99 90 9 3 3 0.0447761194 1.651046452 4 4 0.0350877193 1.54515514
100-109 100 10 0 0 0 0 0 0 0 0
110-119 110 11 0 0 0 0 0 0 0 0
120+ 120 12 0 0 0 0 0 0 0 0
Total 67 114
Females Males
Age class Age at start x dx nx lx log(1000*lx) dx nx lx log(1000*lx)
0-9 0 0 0 0 0 0 0 0
10-19 10 1 0 0 0 0 0 0
20-29 20 2 0 0 0 0 0 0
30-39 30 3 0 0 0 0 0 0
40-49 40 4 0 0 0 0 0 0
50-59 50 5 0 0 0 0 0 0
60-69 60 6 0 0 0 0 0 0
70-79 70 7 0 0 0 0 0 0
80-89 80 8 0 0 0 0 0 0
90-99 90 9 0 0 0 0 0 0
100-109 100 10 0 0 0 0 0 0
110-119 110 11 0 0 0 0 0 0
120+ 120 12 0 0 0 0 0 0
Total 0 0
Females Males
Age class Age at start x dx nx lx log(1000*lx) dx nx lx log(1000*lx)
0-9 0 0
10-19 10 1
20-29 20 2
30-39 30 3
40-49 40 4
50-59 50 5
60-69 60 6
70-79 70 7
80-89 80 8
90-99 90 9
100-109 100 10
110-119 110 11
120+ 120 12
Total

example
Females born 1801-1851
Males born 1801-1850
Females born 1851-1900
Males born 1851-1900
Age (years)
log(1000*lx)