How to make a survivorship curve on excel

Population Ecology Activity
Subject
Science

Question Description
In this unit, you learned that the characteristics of a population at a given time can be represented graphically using birth and death rate data, among many other parameters. In Part I of this activity, you will work with a simple data set to create a human survivorship curve and answer questions about the results and the data itself. In Part II, you will work with interactive age structure diagrams in an online simulator to analyze population growth trends for both China and the United States. For an example of an age structure diagram, see the presentations for the Unit II Lesson.

This assignment consists of both a Word document and Excel file. Both files must be uploaded to Blackboard for full credit.

Click here to access the assignment worksheet. Complete the worksheet, and submit it in Blackboard.

Click here to access the assignment Excel template. Complete the table, and submit it in Blackboard.

Attachment preview
Name:
Population Ecology Activity

Introduction
In Unit II, you learned that the characteristics of a population at a given time can be represented graphically using birth and death rate data, among many other parameters. In Part I of this activity, you will work with a simple data set to create a human survivorship curve and answer questions about the results and the data itself. In Part II, you will work with interactive age structure diagrams (see unit lesson part II, Slide 21, Figure 3 for an example) in an online simulator to analyze population growth trends for both China and the United States.

Part I: Constructing a Survivorship Curve
Survivorship curves are created by estimating the age of an organism at the time of its death and the number of deaths within each age bracket inside of a given population of organisms. Once constructed, survivorship curves create a general picture of the life history of that organism. The two biggest influences on the shape of a survivorship curve are predation and disease. There are three general survivorship curve types: