De

Here are the raw data for our lab. Let's plot the data as the actual values/1000 (the numbers here) rather than their logs (which we looked at in lab). This makes the differences in the top portion of the graphs, where much of the interesting variation occured) a lot easier to see.

Drag and paste these tables into an Excel spreadsheet. When you highlight an area to plot with the chart wizard include the numbers for age class, and then select 'line graph' from the options. The wizard will include the age classes as the labels on the x-axis, which will facilitate your interpretation of the data.

Once you have them in a spreadsheet, you can cut and paste so that you have males and females from a given time period next to each other for graphical comparison. Just make sure you have the age classes as the left-most column and include them in the highlighted area before launching the chart wizard.

FEMALES:

(Please note that there probably is a problem with the data for the cohort 1950-2000. The data as presented say that 86 of the cohort died between ages 94 and 99, and that 25 made it past 100 years old. I would interpret this end of the curve with extreme caution, pending confirmation from the team that did this subset of the data.)

age class fem <1900 fem<49 fem >1949
0 1000 1000 1000
1 944 914 974
2 900 874 974
3 844 848 974
4 811 848 964
9 800 828 959
14 778 808 959
19 767 775 959
24 722 748 959
29 700 715 949
34 656 669 949
39 611 616 938
44 533 576 928
49 422 510 892
54 378 483 887
59 311 457 816
64 267 417 765
69 211 364 724
74 167 265 668
79 111 205 581
84 89 126 505
89 4 20 362
94 4 7 239
99 4 0 86
100+ 0 0 25

MALES:

age class male<00 male <49 male >1949
0 1000 1000 1000
1 838 927 978
2 795 904 978
3 709 882 978
4 709 882 978
9 701 882 978
14 641 865 978
19 598 860 978
24 590 826 968
29 538 792 928
34 530 742 906
39 453 685 893
44 402 646 880
49 342 567 848
54 316 534 791
59 265 500 737
64 239 427 657
69 179 371 617
74 145 292 502
79 128 180 413
84 85 101 266
89 60 51 146
94 26 28 40
99 9 11 13
100+ 0 0 0