Cemetery Class Data: Master with Formulas and Sample data (make copy and delete data before using with students). Delete columns U and V initially. Then paste in after students practice the math by hand for "Pre-1900 Males"

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1		Group 1a	Group 1b	Group 2a	Group 2b	Group 3a	Group 3b	Group 4a	Group 4b	Group 5a	Group 5b	Group 6a	Group 6b	Group 7a	Group 7b	Group 8a	Group 8b	Group 9a	Group 9b	Total
2	Age Group	#Deaths	#Deaths	#Deaths	#Deaths	#Deaths	#Deaths	#Deaths	#Deaths	#Deaths	#Deaths	#Deaths	#Deaths	#Deaths	#Deaths	#Deaths	#Deaths	#Deaths	#Deaths		Surv	Survivorship (%)
3	0-4																			0	0	#DIV/0!
4	5-9																			0	0	#DIV/0!
5	10-14																			0	0	#DIV/0!
6	15-19																			0	0	#DIV/0!
7	20-24																			0	0	#DIV/0!
8	25-29																			0	0	#DIV/0!
9	30-34																			0	0	#DIV/0!
10	35-39																			0	0	#DIV/0!
11	40-44																			0	0	#DIV/0!
12	45-49																			0	0	#DIV/0!
13	50-54																			0	0	#DIV/0!
14	55-59																			0	0	#DIV/0!
15	60-64																			0	0	#DIV/0!
16	65-69																			0	0	#DIV/0!
17	70-74																			0	0	#DIV/0!
18	75-79																			0	0	#DIV/0!
19	80-84																			0	0	#DIV/0!
20	85-89																			0	0	#DIV/0!
21	90-94																			0	0	#DIV/0!
22	95-99																			0	0	#DIV/0!
23	100-104																			0	0	#DIV/0!
24
25																				0
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100