Population Growth

NOTE: In these experiments you will use computer software to simulate different types of growth models. HYPOTHESES: 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 the number zero into cell A2. This row will represent the initial generation.

In cell A3 type this formula: = 1 + A2

Now 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.

NOTE: In the classic exponential growth equation, T is the generation, and NT is the number of organisms in the current generation. NT+1 will be is the number of individuals in the next generation.

Enter the exponential growth equation in cell B3 as the formula shown here: = B2 + (1 + E2) * B2

Now, 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, along with the 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. TIP: 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 1 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 1, 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 2.

Proceed to change the initial population size using the values in Table 2. Once the table is complete, save the Excel sheet and close it.

HYPOTHESES: 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 spreadsheet 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: = 1 + A2

Now, 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. NOTE: In the classic logistic growth equation the term K represents 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 formula below: = B2 + ((1 + E$2) * B2) * ((F$2 - B2) /F$2)

Now hit enter.

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.

Now set the max growth rate in cell E2 to 1.

Notice how the population responds when it rises over carrying capacity.

Continue to set the max growth rate to the values in Table 3 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 include these new data points to show when the population reaches carrying capacity.

Save the Excel sheet and close it.

Hypotheses: In our third simulation of predator-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 below: = 1 + A2

Now 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. NOTE: 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 formula below: =B2+(E$2*B2)-(F$2*C2*B2)

Hit enter.

Then type the prey growth equation in cell C3 as the displayed formula: =C2 + (F$2*G$2*B2*C2)-(H$2*C2)

Hit 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, observe the shape of the resulting population growth curve, and consider whether you think this type of growth could be sustained in nature.

Note how the growth rate R affected the population size after 10 generations in the exponential growth model.

Also consider how the initial population size affected the population size after 10 generations in the exponential growth model.

Now, consider the logistic growth model, and observe the shape of this graph, noting how it differs from the exponential growth model.

Then, note how the populations behave as they approach the carrying capacity in your logistic growth model.

Decide if you think that the maximum per capita growth rate, R max, influenced 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 predator-prey model, note whether the prey population responded to increasing predator population. Conversely, consider how the predators then respond to decreasing prey populations.