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. Year 2010 2011 2012 2013 2014 2015 ADULT ABUNDANCE Female Male Total 147 120 169 144 194 158 77 81 53 59 64 74 267 313 352 130 140 138 EFFECTIVE POPULATION SIZE Total Ne Nef Nern 58 68 77 22 24 26 48 58 63 29 34 30 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].