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.)
MALES:
|