Population Growth

In these experiments you will use computer software to simulate different types of growth models. First you will examine logistic growth. The experimental hypothesis might be that if we increase either R, the reproductive rate or the initial population size, NT, that this will increase the population size after 10 generations in an exponential growth model compared to unmanipulated control populations.

The null hypothesis may be that populations of different R and initial population size will have the same population size as control groups after 10 generations. To build an exponential population growth model, first open a new workbook in Excel. Save the file to a secure location and name it exponential growth.

Label cell A1 generation, and cell B1 population size. Type zero into cell A2.This row will represent the initial generation. In cell A3 type the formula equals one plus A2 and hit enter.

Click on cell A3 and drag the small box in the bottom right corner to cell A12 for 10 generations. Type the number two in cell B2.This will represent the initial population size in the model. Label cell E1 growth rate, and in cell E2 type the number 0.05.

This value represents the proportion of new offspring produced by each individual for each generation, or R in the exponential growth model. Here T is the generation. So NT is the number of organisms in the current generation and NT plus one is the number of individuals in the next generation.

Enter the exponential growth equation in cell B3 as the formula shown here and hit enter. Click cell B3 and drag the small square in the bottom right corner down to cell B12 to simulate 10 generations of exponential growth. To observe the results, select all data with headers in columns A and B.Click insert and select scatter plot with smooth lines and markers from the toolbar.

A scatter plot should appear in the sheet. If it does not, check to see if a new sheet was created in the workbook. Label the Y axis population size and the X axis generation.

Title the chart exponential growth of a population. Observe how the population increases in a classic exponential growth pattern. Next create table one labeling the growth rate R as the header of column A, and population size after 10 generations as the second column.

Record the population size at generation 10 for the growth rate of 0.05, the rate we just simulated. Now set the growth rate in cell E2 to 0.1 and repeat the steps to generate a new scatter plot. Record the population size at generation 10.

Continue to alter the growth rate using the values in table one, noticing how the Y axis changes to accommodate the increasing values. After completing table one, set the growth rate back to 0.05 and change the initial population size in cell B2 to 100 individuals. Record the population size at generation 10 in a new table, table two as shown.

Proceed to change the initial population size using the values in table two. Once table two is complete, save the Excel sheet and close it. In a logistic growth model, the experimental hypothesis could be that populations will approach and meet the carrying capacity, and any populations with sizes greater than the carrying capacity will decrease in the subsequent generation.

The null hypothesis might be that population growth will not follow a logistic S-shaped curve in the logistic models, and that generations with population sizes greater than the carrying capacity will continue to increase or stay the same in the next generation. To build a logistic population growth model, open a new spread sheet in Excel. Save the file as logistic growth in the same folder as before.

Then label cell A1 generation and B1 population size. Type the number zero in cell A2.This row will represent the initial generation. In cell A3 type the formula equals one plus A2 and hit enter.

Now click on cell A3 and drag the small box in the bottom right corner to cell A12 to number up to the 10th generation. Type the number two in cell B2 to represent the initial population size. Label cell E1 as max growth rate and cell F1 as carrying capacity.

Finally set the max growth rate in cell E2 to 0.05. This value will represent the maximum growth rate the population may achieve, R max, in the discrete logistic equation. In this equation the term K is carrying capacity.

As the population size of the current generation or NT, approaches the carrying capacity, the growth of the population begins to slow. Now set the carrying capacity in cell F2 to 50. Enter the logistic growth equation in cell B3 as the displayed formula and hit enter.

Then drag the formula down to cell B12 to add it to all 10 generations. To observe the results of this exercise, highlight all data and headers in columns A and B, then click insert and select scatter plot with smooth lines and markers. Label the Y axis population size and the X axis generation.

Title the chart as logistic growth of a population. Observe the growth of the population as it nears carrying capacity and record the generation that the population meets or exceeds carrying capacity in a new table as shown. In this example, the population size exceeds its carrying capacity at the seventh generation at the maximum growth rate of 0.05.

Now set the max growth rate in cell E2 to one. Notice how the population responds when it rises over carrying capacity. Continue to set the max growth rate to the values in table three and record the generation at which the population rises two or above carrying capacity.

Now set the max growth rate back to 0.05 and set the carrying capacity to 1, 000. Notice how the graph changes as the growth approaches the carrying capacity. Drag the formulas in A12 and B12 down to A14 and B14.

Adjust the plot to includes these new data points to show when the population reaches carrying capacity. Finally save the Excel sheet and close it. In our third simulation of predatory-prey logistics, the experimental hypothesis could be that predator populations will increase as prey populations increase and that the two populations will experience growth and decline dependent on the population of the other species.

The null hypothesis may be that the two populations will show patterns of growth unrelated to the other species'population size. To build a predator-prey model, open a new spreadsheet in Excel. Save the file in the same folder as the other two models and name it predator-prey model.

Label cell A1 time, cell B1 prey and cell C1 predator. In cell A2 type zero and hit enter. In cell A3 type the formula equals one plus A2 and hit enter.

Drag the formula down to cell A802 as the model will require many time points to visualize changes of both populations. Now type 100 into cell B2 to represent the initial prey population and type 25 into cell C2 as the initial predator population. Label cell E1 prey growth rate, cell F1 consumption of prey by predator, cell G1 conversion efficiency and cell H1 starvation of predator.

Type the number 0.02 in cell E2.This value represents the growth rate of the prey species or R in the prey population model. Here the prey population is represented as VT and the predator population as CT.The value A is the per capita attack rate of the predator species on the prey. In the predator population model, variables are introduced for predators produced per prey consumed, F or conversion efficiency as well as for the starvation rate of the predators noted as Q.Type 0.0005 in cell F2 for the attack rate in both the prey population and the predator population model.

Then type 0.8 in cell G2 to represent the conversion efficiency and 0.05 in cell H2 for the starvation rate in the predator population equation. Now type the prey growth equation in cell B3 as the displayed formula and hit enter. Then type the prey growth equation in cell C3 as the displayed formula, again hitting enter.

Hold down the shift keys and click to select both cells B3 and C3.Click the small box at the bottom right corner of cell B3 and drag the two formulas down to row 802 to simulate the predator and prey populations over 800 generations. To visualize the data, select all of the data and headers in columns A, B and C.Click insert and select scatter plot with smoothed lines. A chart showing the population change of the predator and the prey populations should appear.

Label the Y axis of the plot population size and the X axis time. Title the plot predator-prey interactions. Observe the interactions between the predator and prey populations.

Set the initial predator population to zero and observe what happens in the plot. Now set the initial predator population to 120 and observe what happens to the predator population when there are more predators than prey. Finally set the initial prey population to zero and observe what happens to the population of the predators.

Experiment with other values to see what other interactions can be created. When finished save the workbook and close it. In the exponential growth model built in the first activity, what is the shape of the resulting population growth curve?

Do you think this type of growth could be sustained in nature? How did the growth rate R affect the population size after 10 generations in the exponential growth model? How did the initial population size affect the population size after 10 generations in the exponential growth model?

Now consider the logistic growth model. What is the shape of this curve? How did populations behave as they approach the carrying capacity in your logistic growth model?

How did the maximum per capita growth rate, R max, influence how quickly populations reached carrying capacity in the logistic growth model? Also, consider what happens to population size when populations are over carrying capacity in the logistic growth model or what might happen if the carrying capacity is lowered. In the predatory-prey model, how do prey populations respond to increasing predator populations?

How do predators respond to decreasing prey populations?