1.On an Excel sheet, create a model of the Logistic Growth curve. Be sure that you have: A specific place for input parameters (initial population, carrying capacity and growth rate), A graph showing population growth over a time period that demonstrates your population reaches its carrying capacity.
2.On a new sheet in Excel, using your population model, perform an analysis of the possible error in your ‘r’ value. What does this analysis show? This analysis can be used to evaluate the method you used to calculate ‘r’. discuss at least two other methods you could use to determine a better estimate of your population’s growth rate constant ‘r’.