AutoSave OF A HP G ... Module 3 answer sheet 3 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Geneva 16 v P A w 9 a Wraa Text General Insert v v W X [G AYO Fich Delete Paste BIU - div = = - - Merge & Center Sensitivity Conditional Format Cell Formatting as Table Styles Format v v Sort & Filter Find & Select Analyze Data L5 x fx T B C D E F G H I Exercise 4. Show the survivorship values you used to create each type of survivorship curve. It will be the series of Sy from the table, starting at the top with 1000, and working down the table in the Sx column (i.e. the yellow cells in the 26 table) (3 points): 27 28 1) Type 1 1000, 29 30 2) Type II 1000, 31 3) Type III 32 1000, 33 34 Sheet1 + Ready + 216% EXERCISE 4: What is the pattern of survivorship with age? Survival is just the flip side of mortality: a 25% chance of survival is the same as a 75% chance of (The only possibilities are survive or die so the two probabilities must add up to 100%) Let's focus on survival. Species differ in the pattern of age-specific survival. As we have seen, this has dramatic consequences for population growth rates. Ecologists identify three basic patterns of survival as shown in the graph below: TYPE I is high early survival rate TYPE II is constant survival rate (linear in log scale) TYPE III is low early survival rate Log number surviving 11 HU Age or time T The data for these survivorship curves come from life tables. Number surviving is just sx To determine the pattern of survivorship with age, we simply plot Log (sx) versus Age (a plot of log (1x) versus age will show the same pattern) Let's look at an example. Below is the first data column in a life table, Sx the number alive in each age class. In this life table, we have 10 age classes, no animals live past 9 years The graph on the right is semi-log plot of survival. What type of survival curve is this? SURVIVORSHIP CURVE 0 1 SX 1000 900 32 2 3 log sx 3 2.9542 2.9031 2.8451 2.7782 2.699 2.6021 2.4771 800 700 600 500 400 300 4 LOG NUMBER ALIVE (Sx) 26 5 6 24 7 22 8 200 2.301 9 100 2 0 10 10 0 AGE EXERCISE 4: Change the number surviving in the sx column below and look at the survivorship curves that result See if you can generate the 3 main types of survivorship curves. Hint For Type Il you can copy and paste a function to get a constant rate of survival. i) Make the value of Sx+1 equal the value of Su multiplied by some fraction. ii) Copy and paste this to all sx cells SURVIVORSHIP CURVE 0 Sx 1000 log sx 3 35 1 0 #NUM! 2 0 #NUM! 3 0 #NUMI LOG NUMBER ALIVE 4 0 #NUM! 5 0 #NUM! 05 O O 05 15 35 4 45 25 3 AGE AutoSave OF A HP G ... Module 3 answer sheet 3 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Geneva 16 v P A w 9 a Wraa Text General Insert v v W X [G AYO Fich Delete Paste BIU - div = = - - Merge & Center Sensitivity Conditional Format Cell Formatting as Table Styles Format v v Sort & Filter Find & Select Analyze Data L5 x fx T B C D E F G H I Exercise 4. Show the survivorship values you used to create each type of survivorship curve. It will be the series of Sy from the table, starting at the top with 1000, and working down the table in the Sx column (i.e. the yellow cells in the 26 table) (3 points): 27 28 1) Type 1 1000, 29 30 2) Type II 1000, 31 3) Type III 32 1000, 33 34 Sheet1 + Ready + 216% EXERCISE 4: What is the pattern of survivorship with age? Survival is just the flip side of mortality: a 25% chance of survival is the same as a 75% chance of (The only possibilities are survive or die so the two probabilities must add up to 100%) Let's focus on survival. Species differ in the pattern of age-specific survival. As we have seen, this has dramatic consequences for population growth rates. Ecologists identify three basic patterns of survival as shown in the graph below: TYPE I is high early survival rate TYPE II is constant survival rate (linear in log scale) TYPE III is low early survival rate Log number surviving 11 HU Age or time T The data for these survivorship curves come from life tables. Number surviving is just sx To determine the pattern of survivorship with age, we simply plot Log (sx) versus Age (a plot of log (1x) versus age will show the same pattern) Let's look at an example. Below is the first data column in a life table, Sx the number alive in each age class. In this life table, we have 10 age classes, no animals live past 9 years The graph on the right is semi-log plot of survival. What type of survival curve is this? SURVIVORSHIP CURVE 0 1 SX 1000 900 32 2 3 log sx 3 2.9542 2.9031 2.8451 2.7782 2.699 2.6021 2.4771 800 700 600 500 400 300 4 LOG NUMBER ALIVE (Sx) 26 5 6 24 7 22 8 200 2.301 9 100 2 0 10 10 0 AGE EXERCISE 4: Change the number surviving in the sx column below and look at the survivorship curves that result See if you can generate the 3 main types of survivorship curves. Hint For Type Il you can copy and paste a function to get a constant rate of survival. i) Make the value of Sx+1 equal the value of Su multiplied by some fraction. ii) Copy and paste this to all sx cells SURVIVORSHIP CURVE 0 Sx 1000 log sx 3 35 1 0 #NUM! 2 0 #NUM! 3 0 #NUMI LOG NUMBER ALIVE 4 0 #NUM! 5 0 #NUM! 05 O O 05 15 35 4 45 25 3 AGE