|
|
|
| Demography Lab Data 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 occurred, 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 as the left-most column, 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 to make any comparisons you want, for instance with 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, which is a bit incredible. I would interpret this end of the curve with extreme caution, pending confirmation from the team that did this subset of the data.)
MALES:
|