PART 2: Estimating effective population size As you've leamed, the effective population size, Ne, is affected by several factors, notably the mating system, how skewed the sex ratio is, and how much the population varies over time. These factors are addressed based on adders in Box 9.2. For this exercise you will crank through the sorts of equations used in Box 9.2. We'll work with a hypothetical deer population. The Excel Template has these data: head count abundances of males and females, as well as the effective population sizes of males and females, for each of 6 years. A) On the Excel Template, use the appropriate equation from Box 9.2 to calculate for each year the overall effective population size, given the effective size of males and females. [2 pts] B) Calculate the arithmetic mean of the adult abundance over time. Give the answer below the column of adult abundance. [1 pt] C) Calculate the harmonic mean of the Ne over time. Although you can check yourself with the "Harmean" function in Excel, do your calculation with the formula in Box 9.2 so that you clearly understand what a harmonic mean is. [2 pts] D) What is the ratio of Ne/N? Show work [1 pt]. PART 2: Estimating effective population size As you've leamed, the effective population size, Ne, is affected by several factors, notably the mating system, how skewed the sex ratio is, and how much the population varies over time. These factors are addressed based on adders in Box 9.2. For this exercise you will crank through the sorts of equations used in Box 9.2. We'll work with a hypothetical deer population. The Excel Template has these data: head count abundances of males and females, as well as the effective population sizes of males and females, for each of 6 years. A) On the Excel Template, use the appropriate equation from Box 9.2 to calculate for each year the overall effective population size, given the effective size of males and females. [2 pts] B) Calculate the arithmetic mean of the adult abundance over time. Give the answer below the column of adult abundance. [1 pt] C) Calculate the harmonic mean of the Ne over time. Although you can check yourself with the "Harmean" function in Excel, do your calculation with the formula in Box 9.2 so that you clearly understand what a harmonic mean is. [2 pts] D) What is the ratio of Ne/N? Show work [1 pt]