Survivorship Analysis and Graphing Techniques

The video tutorial explains how to create a survivorship curve using spreadsheet software. It covers setting up initial data, using formulas to calculate survivorship, creating tables, and graphing the data. The tutorial also provides tips on customizing graphs and ensuring accurate data representation.

What is the first step in creating a survivorship curve?

• Drawing the curve on paper

• Calculating percentages

• Creating a graph

• Setting up a spreadsheet with initial data

Which formula operation is used to calculate the number of individuals surviving at each age?

• Multiplication

• Division

• Subtraction

• Addition

How do you calculate the survivorship percentage for a cohort?

• Subtract the number of deaths from the initial population

• Multiply the number of survivors by 100

• Divide the number of survivors by the initial population

• Divide the number of deaths by the initial population

What is the purpose of creating a survivorship table?

• To list all the ages

• To organize data for graphing

• To compare different cohorts

• To calculate the total number of deaths

What is the first step in graphing the survivorship data?

• Highlighting the age column

• Inserting a pie chart

• Calculating the average age

• Copying the data to a new sheet

Which key is used to select multiple columns for graphing?

• Alt

• Control

• Shift

• Command

What should you do if the data columns are not adjacent when graphing?

• Use the command key to select them

• Rearrange the columns

• Graph them separately

• Ignore the non-adjacent columns

What is the final step in customizing the graph?

• Adding a legend

• Adding a title

• Adjusting the font size

• Changing the background color

Why is it important to include both cohorts in the graph?

• To ensure accuracy in calculations

• To fill up space on the graph

• To compare the survivorship of different groups

• To make the graph look more complex

What should you do if you have questions about the process?

• Search online for answers

• Contact the instructor

• Ignore the questions

• Guess and check