Cemetery Data Analysis

Today we went to the ARC and many students used excel for the first time (and realized what a nightmare it can be). Rather than use our data we will be using sample data which will be much easier to work with. You should use the paper I gave you in class for the data.

Please make graphs in excel comparing the following populations, all graphs will have age class on the X axis and survivorship on the Y axis. When you select the type of graph, make sure you choose scatter and then you can choose to have the points connected by lines. If you select line graph, it will not work!

Graph 1: Post-1900 females & Post 1900 males (this most closely resembles our cemetery)
Graph 2: Post-1900 females & pre 1820 females
Graph 3: Post 1900 males & pre 1820 males
Graph 4: The summary of both sexes comparing pre-1820 & post 1900.

In addition you will need to analyze this data and write in terms of any patterns or trends that you see. What type of surviorship curve (I,II or III) does each time period most closely resemble etc...

You will be graded on the following:
1. Whether or not the graphs are correct
2. Having a title and labels for each graph
3. How detailed, insightful and accurate your analysis of the graphs is.
4. There should be two graphs per page and your analysis should be no more than one page.

If you have lost the data I gave you in class you can see me tonight when I am on duty in Moore.

Click here for a link on how to make excel graphs