BISC 111/113:Lab 11: Population Growth 2: Difference between revisions

From OpenWetWare
Jump to navigationJump to search
(30 intermediate revisions by 5 users not shown)
Line 1: Line 1:
<div class=noprint> <!-- This div tag ensures that the header won't be printed when students go to print course materials from the site. -->  
<div class=noprint> <!-- This div tag ensures that the header won't be printed when students go to print course materials from the site. -->  
<div style="padding: 10px; width: 730px; color: #2171B7; background-color: #B3CD4E">
<div style="padding: 10px; width: 730px; color: #2171B7; background-color: #A9F5A9">
<center><font face="trebuchet ms" style="color:#2171B7" size="5">'''BISC 111/113: Introductory Organismal Biology'''</font><br>
<center><font face="trebuchet ms" style="color:#2171B7" size="5">'''BISC 111/113: Introductory Organismal Biology'''</font><br>
</center>
</center>
Line 6: Line 6:
</div>
</div>
[[Image:Sunflowers in France.jpg|750px]]
[[Image:Sunflowers in France.jpg|750px]]
<div style="padding: 10px; color: #2171B7; background-color: #B3CD4E; width: 730px">
<div style="padding: 10px; color: #2171B7; background-color: #A9F5A9; width: 730px">
<center>
<center>
[[BISC 111/113 | <font face="trebuchet ms" style="color:#2171B7"> '''Introduction to Organismal Biology Lab''' </font>]] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
[[BISC 111/113 | <font face="trebuchet ms" style="color:#2171B7"> '''Introduction to Organismal Biology Lab''' </font>]] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Line 39: Line 39:
=='''Objectives'''==
=='''Objectives'''==
#To finish the ''Tribolium'' experiment by conducting final counts and start processing data
#To finish the ''Tribolium'' experiment by conducting final counts and start processing data
#To explore computer simulation programs that model population growth and interactions
#To explore simple models of population growth and interactions in Excel


=='''Lab 11 Overview'''==
=='''Lab 11 Overview'''==
I. Complete the ''Tribolium'' population growth experiment
I. Complete the ''Tribolium'' population growth experiment


<dl>II. Model changes in beetle population using Excel
<dl>II. Model changes in population size using Excel


<dd>a. Linear Growth<br>
<dd>a. Geometric Growth<br>
<dd>b. Exponential Growth<br>
<dd>b. Exponential Growth<br>
<dd>c. Logistic Growth<br>
<dd>c. Linear Growth<br>
<dd>d. Logistic Growth
</dl>
</dl>
III. Model beetle populations in Stella


IV. Assignment
III. Assignment


=='''Completing the ''Tribolium'' population growth experiment'''==
=='''Completing the ''Tribolium'' population growth experiment'''==
Line 64: Line 64:


=='''Population Growth and Interactions: Background'''==
=='''Population Growth and Interactions: Background'''==
<b> Population Structure:</b><br>
'''Population Structure'''<br>
A population is a group of individuals of the same species in a given area with the potential to interbreed. Each population has a <b>structure</b> that includes features such as density, spacing, and movement of individuals over time and space.<br><br>
A population is a group of individuals of the same species in a given area with the potential to interbreed. Each population has a <b>structure</b> that includes features such as density, spacing, and movement of individuals over time and space.<br>


<b>Spatial structure</b> addresses the dispersal of individuals in space and can be classified as evenly spaced, clumped or totally random. <b>Genetic structure</b> of a population describes the distribution of genetic variation within that group. There is genetic variation among individuals within the population. This variation is the basis of the population’s ability to respond to environmental changes through adaptive evolution.
<b>Spatial structure</b> addresses the dispersal of individuals in space and can be classified as evenly spaced, clumped or totally random. <b>Genetic structure</b> of a population describes the distribution of genetic variation within that group. There is genetic variation among individuals within the population. This variation is the basis of the population’s ability to respond to environmental changes through adaptive evolution.
Line 71: Line 71:
The study of '''population dynamics''' examines the ways that populations grow or shrink over time. Reproduction and immigration account for population increases, and death and emigration account for decreases. While some populations may reproduce continually, others experience discrete periods of reproductive growth. Because some populations (e.g. human) have no distinct reproductive season, the population grows more or less continuously. <br><br>
The study of '''population dynamics''' examines the ways that populations grow or shrink over time. Reproduction and immigration account for population increases, and death and emigration account for decreases. While some populations may reproduce continually, others experience discrete periods of reproductive growth. Because some populations (e.g. human) have no distinct reproductive season, the population grows more or less continuously. <br><br>


'''Population Growth:'''<br>
'''Geometric Growth'''<br>
Mathematical models offer a way to describe and predict population growth over time and under a variety of conditions.  Generally, populations grow by multiplication, because all individuals have the potential to contribute to the population by reproducing.  It follows then that the amount of growth that occurs is proportional to population size.  As an example, consider the measurements of a population’s size below.  How fast is this population growing?<br>
Mathematical models offer a way to describe and predict population growth over time and under a variety of conditions.  Generally, populations grow by multiplication, if all individuals have the potential to contribute equally to the population by reproducing.  It follows then that the amount of growth that occurs is proportional to population size.  As an example, consider the measurements of a population’s size below.  How fast is this population growing?<br>
 
<center>
<center>[[Image:111.F11PopulationTable.png|250px]]</center>
{| border="1"
|+
! &nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; '''Year measured''' &nbsp; &nbsp;&nbsp;&nbsp;  &nbsp;&nbsp;    !!&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;  '''Population size''' &nbsp;&nbsp; &nbsp;   
|-
| &nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;2006 || &nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;100 || 
|-
| &nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;2007 || &nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;160 || 
|-
| &nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;2008 || &nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;256 || 
|-
| &nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;2009 || &nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;410 || 
|-
|
|}
</center>


To calculate the <i>per capita growth rate</i> (the average contribution each individual makes to the population’s growth) from 2006 to 2007, we simply compute 160/100 = 1.6.  This population has grown by 60% during the year (a factor of 1.6).  Doing this for all subsequent 1-yr intervals (256/160 = 1.6, 410/256 = 1.6) we see that the population is growing at a constant rate of 1.6 from year to year.  When calculated for such discrete time intervals as from year to year, this is known as the <i>geometric growth rate</i> of the population, and is symbolized by λ (the Greek letter “lambda”):
To calculate the <i>per capita growth rate</i> (the average contribution each individual makes to the population’s growth) from 2006 to 2007, we simply compute 160/100 = 1.6.  This population has grown by 60% during the year (a factor of 1.6).  Doing this for all subsequent 1yr intervals (256/160 = 1.6, 410/256 = 1.6) we see that the population is growing at a constant rate of 1.6 from year to year.  When calculated for discrete time intervals such as from year to year, this is called the <i>geometric growth rate</i> of the population, and is symbolized by λ (the Greek letter “lambda”):
<blockquote>
<blockquote>
<center><b>λ = N<sub>t</sub> / N<sub>t-1</sub> </b></center>
<center><b>λ = N<sub>t</sub> / N<sub>t-1</sub> </b></center>
where N<sub>t</sub> is population size at some time interval “t”, and <br>
where '''N<sub>t</sub>''' is population size at some time interval “t”, and <br>
N<sub>t-1</sub> is population size at the previous time interval “t-1”.  <br>
'''N<sub>t-1</sub>''' is population size at the previous time interval “t-1”.  <br>
With a little algebra, and we can use this simple equation to give a powerful result:<br>
</blockquote>
<center><b>N<sub>t</sub> = N<sub>t-1</sub> *  λ </b></center><br>
With a little algebra, we can use this simple equation as a powerful tool to make predictions about the population's growth:<br>
<blockquote> <center><b>N<sub>t</sub> = N<sub>t-1</sub> *  λ </b></center><br>


which is the same as:<br><center><b>N<sub>t+1</sub> = N<sub>t</sub> *  λ </b></center><br>
which is the same as:<br><center><b>N<sub>t+1</sub> = N<sub>t</sub> *  λ </b></center><br>
</blockquote>
</blockquote>


If we followed a population’s growth from its initial size (<b>N<sub>0</sub></b>) at “time zero” (t = 0), its size after one year (or any specified time unit) would be <b>N<sub>1</sub> = N<sub>0</sub> *  λ.</b>  At year two, <b>N<sub>2</sub> = N<sub>1</sub> *  λ</b>, but because <b>N<sub>1</sub> = N<sub>0</sub> *  λ</b>,  <b>N<sub>2</sub></b> also = <b>N<sub>0</sub> *  λ * λ</b>,  or <b>N<sub>0</sub> *  λ<sup>2</sup></b>.
If we followed a population’s growth from its initial size (<b>N<sub>0</sub></b>) at “time zero” (t = 0), its size after one year (or any specified time unit) would be <b>N<sub>1</sub> = N<sub>0</sub> *  λ.</b>  At year two, <b>N<sub>2</sub> = N<sub>1</sub> *  λ</b>, but because <b>N<sub>1</sub> = N<sub>0</sub> *  λ</b>,  <b>N<sub>2</sub></b> is also = <b>N<sub>0</sub> *  λ * λ</b>,  or <b>N<sub>0</sub> *  λ<sup>2</sup></b>.


<blockquote>To generalize this expression:<br>
<blockquote>
To generalize this expression:<br>
<center><b>N<sub>t</sub> = N<sub>0</sub> *  λ<sup>t</sup></b>.<br><br></center>
<center><b>N<sub>t</sub> = N<sub>0</sub> *  λ<sup>t</sup></b>.<br><br></center>
</blockquote>
</blockquote>


'''Exponential Growth'''<br>
We can use this expression to predict the population size at any future time “t” from some initial size (<b>N<sub>0</sub></b>), if the population growth rate (<b>λ</b>) is constant.  In our example above where N<sub>0</sub> = 100 individuals, after 15 years the population would be predicted to be quite large under a constant population growth rate of 1.6 (N<sub>15</sub> = 100 *  1.6<sup>15</sup> , or > 115 * 10<sup>3</sup> individuals).<br><br>
We can use this expression to predict the population size at any future time “t” from some initial size (<b>N<sub>0</sub></b>), if the population growth rate (<b>λ</b>) is constant.  In our example above where N<sub>0</sub> = 100 individuals, after 15 years the population would be predicted to be quite large under a constant population growth rate of 1.6 (N<sub>15</sub> = 100 *  1.6<sup>15</sup> , or > 115 * 10<sup>3</sup> individuals).<br><br>


Line 104: Line 121:


<blockquote>
<blockquote>
<center><b><i>d</i>N/<i>d</i>t = rN</b> </center><br>
<center><b><i>d</i>N/<i>d</i>t = rN<sub>t</sub></b> </center><br>
Where<br>
Where<br>
<b>N</b><sub>t</sub> = population size (at time “t”), and<br>
<b>N</b><sub>t</sub> = population size (at time “t”), and<br>
Line 110: Line 127:
</blockquote>
</blockquote>


You can also see that <b>r = (<i>d</i>N/<i>d</i>t)*/ N t </b>.  And so during exponential growth, <b>r</b> is the per capita rate of increase of the population.  
You can also see that <b>r = (<i>d</i>N/<i>d</i>t)/N<sub>t</sub> </b>.  And so during exponential growth, <b>r</b> is the per capita rate of increase of the population.  


Exponential population growth displays a J-shaped curve of N over time. Compare exponential growth to a simple <b>linear model</b>:
Exponential population growth displays a ''J''-shaped curve of N over time. Compare exponential growth to a simple <b>linear model</b>:
<blockquote>
<blockquote>
Exponential growth: <b>N<sub>t</sub> = N<sub>0</sub> * e<sup>rt</sup></b><br>
Exponential growth: <b>N<sub>t</sub> = N<sub>0</sub> * e<sup>rt</sup></b><br>
Linear growth: <b>N<sub>t</sub> = N<sub>0</sub> + bt </b> <br>
Linear growth: <b>N<sub>t</sub> = N<sub>0</sub> + b*t </b> <br>


Where:<br>
Where:<br>
Line 123: Line 140:
</blockquote>
</blockquote>


 
'''Linear Growth.''' <br>
Linear models may be appropriate over short time intervals, but seldom describe long-term population growth because they fail to include an increasing number of reproductive individuals as the population grows.  However, while exponential growth models are more realistic than the linear models, neither reflects the dynamics of most natural populations over the long term.  There are several reasons for this, as we will see below.  Nonetheless, “'''r'''” is a very useful parameter in modeling (describing & predicting) population growth as an integrator of life history traits (e.g., when & how much to reproduce) and growth potential.<br><br>
Linear models may be appropriate over short time intervals, but seldom describe long-term population growth because they fail to include an increasing number of reproductive individuals as the population grows.  However, while exponential growth models are more realistic than the linear models, neither reflects the dynamics of most natural populations over the long term.  There are several reasons for this, as we will see below.  Nonetheless, “'''r'''” is a very useful parameter in modeling (describing & predicting) population growth as an integrator of life history traits (e.g., when & how much to reproduce) and growth potential.<br><br>


'''Logistic Growth.''' <br>
Exponential growth, if unchecked, could lead to unimaginable numbers of everything from bacteria to elephants.  After all, the exponential rate of population increase is proportional to the population size; the bigger the population gets, the faster it grows!  Of course, most natural populations never achieve their potential for unlimited size; Darwin was keenly aware of this fact.  A third model, the '''logistic population growth model''', tends to be more realistic because it takes into account “environmental resistance” ('''K''') or carrying capacity.  '''K''' is the maximum, or equilibrium, population size that can be sustained theoretically by the environment.  When '''K''' is reached the population growth rate is zero due to a balance of births and deaths.  '''K''' is influenced by resource availability, waste accumulation, and other density-dependent factors (see below).   
Exponential growth, if unchecked, could lead to unimaginable numbers of everything from bacteria to elephants.  After all, the exponential rate of population increase is proportional to the population size; the bigger the population gets, the faster it grows!  Of course, most natural populations never achieve their potential for unlimited size; Darwin was keenly aware of this fact.  A third model, the '''logistic population growth model''', tends to be more realistic because it takes into account “environmental resistance” ('''K''') or carrying capacity.  '''K''' is the maximum, or equilibrium, population size that can be sustained theoretically by the environment.  When '''K''' is reached the population growth rate is zero due to a balance of births and deaths.  '''K''' is influenced by resource availability, waste accumulation, and other density-dependent factors (see below).   


In logistic population growth, '''''d''N/''d''t = r N<sub>t</sub> *[(K- Nt)/K]'''<br>  
In logistic population growth, '''''d''N/''d''t = r N<sub>t</sub> *[(K- N<sub>t</sub>)/K]'''<br>  


Here, '''K''' = the carrying capacity, and other terms are as defined above.<br> <br>   
Here, '''K''' = the carrying capacity, and other terms are as defined above.<br> <br>   
Line 144: Line 162:
The models we have presented are more often representative of laboratory populations growing under controlled conditions, rather than the patterns seen in natural populations.  In the logistic model, as long as the population size (N) is less than the carrying capacity (K) the population will increase, and the rate of increase slows as N approaches K. However, even this model is often too simple to capture the dynamics of natural populations. If you read any of the original articles by Park about ''Tribolium'' beetles, you see that the growth curves are complex and not usually predictable. It is important to understand that K in the logistic equation is fixed, but that in reality K will continually change as environmental characteristics (e.g., availability of food & space) change.  <br><br>   
The models we have presented are more often representative of laboratory populations growing under controlled conditions, rather than the patterns seen in natural populations.  In the logistic model, as long as the population size (N) is less than the carrying capacity (K) the population will increase, and the rate of increase slows as N approaches K. However, even this model is often too simple to capture the dynamics of natural populations. If you read any of the original articles by Park about ''Tribolium'' beetles, you see that the growth curves are complex and not usually predictable. It is important to understand that K in the logistic equation is fixed, but that in reality K will continually change as environmental characteristics (e.g., availability of food & space) change.  <br><br>   


Models of natural populations must account for the complexity of multiple interacting environmental factors.  For example, in many populations, there are distinct breeding seasons and periods of growth so it becomes important to measure the population at the same time each year to take into account when the majority of births and deaths occur.  The resources supporting populations are dynamic quantities, as are habitat characteristics, interspecific competitors, predators, and pathogens. And now, natural populations are facing the challenges of rapid local and global climate change. <br><br>  
Models of natural populations must account for the complexity of multiple interacting environmental factors.  For example, in many populations, there are distinct breeding seasons and periods of growth so it becomes important to measure the population at the same time each year to take into account when the majority of births and deaths occur.  The resources supporting populations are dynamic quantities, as are habitat characteristics, interspecific competitors, predators, and pathogens. And now, natural populations are facing the challenges of rapid local and global climate change. <br><br>


'''Population Regulation'''<br>
'''Population Regulation'''<br>
'''Density-dependent''' factors such as predators, quality of cover, parasites, diseases, and amount of food determine K, and therefore, may regulate populations by maintaining or restoring them to some to some equilibrium size.<br><br>
'''Density-dependent''' factors such as predators, quality of cover, parasites, diseases, and amount of food determine K, and therefore, may regulate populations by maintaining or restoring them to some equilibrium size.<br><br>


'''Density-independent''' factors, in particular, environmental factors such as temperature, precipitation, and disturbances (e.g., fire, floods, earthquakes, tsunamis) can also alter the rate of population growth. These factors, however, are density independent because they affect a certain proportion of the population independently of population size (and largely independent of individual fitness).  
'''Density-independent''' factors, in particular, environmental factors such as temperature, precipitation, and disturbances (e.g., fire, floods, earthquakes, tsunamis) can also alter the rate of population growth. These factors, however, are density independent because they affect a certain proportion of the population independently of population size (and largely independent of individual fitness).<br><br>


As it turns out, density-dependence is difficult to demonstrate in nature, in part because of frequent changes in environmental conditions. As a result, some ecologists refute the concept of “equilibrium” entirely and are currently interested in models based on chaos theory.  Chaotic systems behave in unpredictable ways, even though the factors influencing them may be quite deterministic.  As the number of such interacting factors increases, the ultimate “trajectory” a system takes, such as how a population grows, depends strongly on the starting conditions, and can be highly unpredictable.  Chaos typifies many such “complex systems”.
Density-dependence is difficult to demonstrate in nature, in part because of frequent changes in environmental conditions. As a result, some ecologists refute the concept of “equilibrium” entirely and are currently interested in models based on chaos theory.  Chaotic systems behave in unpredictable ways, even though the factors influencing them may be quite deterministic.  As the number of such interacting factors increases, the ultimate “trajectory” a system takes, such as how a population grows, depends strongly on the starting conditions, and can be highly unpredictable.  Chaos typifies many such “complex systems”.


=='''Modeling Population Growth using Excel'''==
=='''Modeling Population Growth using Excel'''==
<dl>In Excel, you will produce three figures that demonstrate:
<dl>In Excel, you will produce figures that demonstrate:
<dd>a. geometric growth<br>
<dd>a. geometric growth<br>
<dd>b. exponential growth<br>
<dd>b. exponential growth<br>
<dd>c. linear growth<br>
<dd>c. linear growth<br>
<dd>d. logistic growth(br>
<dd>d. logistic growth<br>
</dl>
</dl>
Figures should cover a '''12-month time period''' with an estimated population size for each month.  Don’t worry about creating a fancy graph -- just plot the data to make sure you have set up the model correctly. Based on these equations, we will spend the remainder of our time modeling our own beetle populations using the Stella modeling program.<br><br>
Figures should cover a '''12-month time period''' with an estimated population size for each month.  Don’t worry about creating a fancy graph -- just plot the data to make sure you have set up the model correctly. <br><br>


a) '''Geometric Growth''' typifies a population that grows at a ''fixed'' proportion ('''λ''') of population size over equal time intervals.  Assume that this pattern of growth applies here.  First, calculate '''λ''' from the first two time intervals at t = 0 and t = 1 month.  Then, calculate N<sub>t</sub> for the remaining months, and plot against time using a dot-and-line graph.   
a) '''Geometric Growth''' typifies a population that grows at a ''fixed'' proportion ('''λ''') of population size over equal time intervals.  Assume that this pattern of growth applies here.  First, calculate '''λ''' from the first two time intervals at t = 0 and t = 1 month.  Then, calculate N<sub>t</sub> for the remaining months, and plot against time using a line scatter graph.   
<blockquote>
<blockquote>
'''Geometric model:    N<sub>t</sub> = N<sub>0</sub> *  λ<sup>t</sup>'''  
'''Geometric model:    N<sub>t</sub> = N<sub>0</sub> *  λ<sup>t</sup>'''  
Line 170: Line 188:
! &nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; '''Time (t, months)''' &nbsp; &nbsp;&nbsp;&nbsp;  &nbsp;&nbsp;    !!&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;  '''Number of Individuals (N<sub>t</sub>)''' &nbsp;&nbsp; &nbsp;     
! &nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; '''Time (t, months)''' &nbsp; &nbsp;&nbsp;&nbsp;  &nbsp;&nbsp;    !!&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;  '''Number of Individuals (N<sub>t</sub>)''' &nbsp;&nbsp; &nbsp;     
|-
|-
| 0 || &nbsp; &nbsp;&nbsp;10 (= N<sub>0</sub>) ||   
| &nbsp; &nbsp;&nbsp;0 || &nbsp; &nbsp;&nbsp;10 (= N<sub>0</sub>) ||   
|-
|-
| 1 || &nbsp; &nbsp;&nbsp;45 ||   
| &nbsp; &nbsp;&nbsp;1 || &nbsp; &nbsp;&nbsp;45 ||   
|-
|-
| 2 || &nbsp; &nbsp;&nbsp;... ||   
| &nbsp; &nbsp;&nbsp;2 || &nbsp; &nbsp;&nbsp;... ||   
|-
|-
| 3 || &nbsp; &nbsp;&nbsp;... ||   
| &nbsp; &nbsp;&nbsp;3 || &nbsp; &nbsp;&nbsp;... ||   
|-
|-
| 4, etc. || &nbsp; &nbsp;&nbsp;... ||   
| &nbsp; &nbsp;&nbsp;4, etc. || &nbsp; &nbsp;&nbsp;... ||   
|-
|-
|}
|}
</blockquote>
</blockquote>
b) During '''Exponential Growth''', the rate of population growth depends on the population size; the larger the population, the faster it grows!  This is the same as in geometric growth, except that we apply an instantaneous measure of growth, '''r'''.  In the following case, let’s assume that '''r = 1'''; this “intrinsic rate” of population growth seems small, but watch what happens in a very short amount of time.
b) During '''Exponential Growth''', the rate of population growth depends on the population size; the larger the population, the faster it grows!  This is similar to geometric growth, except that we apply an instantaneous measure of growth, '''r'''.  In the following case, let’s assume that '''r = 1'''; this “intrinsic rate” of population growth seems small, but watch what happens in a very short amount of time.


<blockquote>
<blockquote>
'''Exponential model:    Nt = N0ert'''<br>
'''Exponential model:    N<sub>t</sub> = N<sub>0</sub>e<sup>rt</sup>'''<br>
In Excel, the command for “e” is EXP.  The right hand of the above expression would be calculated as '''N<sub>0</sub>*EXP(r*t)'''
In Excel, the command for “e” is EXP.  The right hand of the above expression would be calculated as '''N<sub>0</sub>*EXP(r*t)'''
     
     
Line 192: Line 210:
! &nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; '''Time (t, months)''' &nbsp; &nbsp;&nbsp;&nbsp;  &nbsp;&nbsp;    !!&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;  '''Number of Individuals (N<sub>t</sub>)''' &nbsp;&nbsp; &nbsp;     
! &nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; '''Time (t, months)''' &nbsp; &nbsp;&nbsp;&nbsp;  &nbsp;&nbsp;    !!&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;  '''Number of Individuals (N<sub>t</sub>)''' &nbsp;&nbsp; &nbsp;     
|-
|-
| 0 || &nbsp; &nbsp;&nbsp;10 (= N<sub>0</sub>) ||   
| &nbsp; &nbsp;&nbsp;0 || &nbsp; &nbsp;&nbsp;10 (= N<sub>0</sub>) ||   
|-
|-
| 1 || &nbsp; &nbsp;&nbsp;10 * EXP(1*1) = 27 ||   
| &nbsp; &nbsp;&nbsp;1 || &nbsp; &nbsp;&nbsp;10 * EXP(1*1) = 27 ||   
|-
|-
| 2 || &nbsp; &nbsp;&nbsp;... ||   
| &nbsp; &nbsp;&nbsp;2 || &nbsp; &nbsp;&nbsp;... ||   
|-
|-
| 3 || &nbsp; &nbsp;&nbsp;... ||   
| &nbsp; &nbsp;&nbsp;3 || &nbsp; &nbsp;&nbsp;... ||   
|-
|-
| 4, etc. || &nbsp; &nbsp;&nbsp;... ||   
| &nbsp; &nbsp;&nbsp;4, etc. || &nbsp; &nbsp;&nbsp;... ||   
|-
|-
|}
|}
</blockquote>
</blockquote>


Plot the data using a scatter plot without lines.  After you plot your data, click on the series of data points, go the Chart/Add Trendline, choose exponential fro type, then in options choose “Display equation” on chart.  The equation should exactly match your model of exponential population growth with time.   
Plot the data using a scatter plot without lines.  After you plot your data, click on the series of data points, go to Chart/Add Trendline, choose exponential for type, then in options choose “Display equation” on chart.  The equation should exactly match your model of exponential population growth with time.   


3)  Linear population growth is characterized by a fixed amount of growth per time interval; a constant number of individuals accrues within a given time period. In the following case the population adds 20 beetles each month (b = 20) to an initial population of 10.
c'''Linear population growth''' is characterized by a ''fixed amount'' of growth per time interval; a constant number of individuals accrues within a given time period. In the following case the population adds 20 beetles each month ('''b = 20''') to an initial population of 10.
Linear model: Nt = N0 + bt 
'''<blockquote>
'''Linear model: N<sub>t</sub> = N<sub>0</sub> + b*t''' <br>
           
           
{| border="1"  
{| border="1"  
Line 214: Line 233:
! &nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; '''Time (t, months)''' &nbsp; &nbsp;&nbsp;&nbsp;  &nbsp;&nbsp;    !!&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;  '''Number of Individuals (N<sub>t</sub>)''' &nbsp;&nbsp; &nbsp;     
! &nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; '''Time (t, months)''' &nbsp; &nbsp;&nbsp;&nbsp;  &nbsp;&nbsp;    !!&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;  '''Number of Individuals (N<sub>t</sub>)''' &nbsp;&nbsp; &nbsp;     
|-
|-
| 0 || 10 (= N<sub>0</sub>) ||   
| &nbsp; &nbsp;&nbsp;0 || &nbsp; &nbsp;&nbsp;10 (= N<sub>0</sub>) ||   
|-
|-
| 1 || 10 + 20*1 = 30 ||   
| &nbsp; &nbsp;&nbsp;1 || &nbsp; &nbsp;&nbsp;10 + 20*1 = 30 ||   
|-
|-
| 2 || 10 + 20*2 = 50 ||   
| &nbsp; &nbsp;&nbsp;2 || &nbsp; &nbsp;&nbsp;... ||   
|-
|-
| 3 || 10 + 20*3 = 70 ||   
| &nbsp; &nbsp;&nbsp;3 || &nbsp; &nbsp;&nbsp;... ||   
|-
|-
| 4, etc. || ... ||   
| &nbsp; &nbsp;&nbsp;4, etc. || &nbsp; &nbsp;&nbsp;... ||   
|-
|-
|} ...
|}
</blockquote>
Plot the data using a scatter plot without lines.  After you plot your data, click on the series of data points, go the Chart/Add Trendline, choose linear for type, then in options choose “Display equation” on chart.  You should see that the equation exactly matches your model of population growth with time.
Plot the data using a scatter plot without lines.  After you plot your data, click on the series of data points, go to the "'''Chart/Add Trendline'''", choose "'''linear'''" for type, then in options choose “'''Display equation'''” on chart.  You should see that the equation exactly matches your model of population growth with time.<br><br>
 
Compare exponential and linear model outputs.  Explain why the exponential model produces a J-shaped curve rather than a linear straight line.  (Hint:  Identify the impact of N on population growth and what happens as N increases).
 
4)  Now, on your own, try to set up a third spreadsheet to model logistic growth.
    Logistic model:    Nt = (N0K)/(N0+[K- N0]e-rt)


Start at N0= 10, and set r = 1; let’s set K = 10000.  
Compare exponential and linear model outputs. Explain why the exponential model produces a ''J''-shaped curve rather than a linear straight line. (HintIdentify the impact of N on population growth and what happens as N increases).<br><br>
Your Excel formula for Nt would be: (10*10000)/(10+(10000-10)*EXP(-1*t))
 
Excel will not plot a logistic equation through the data points, so just link the points using a dot-and-line plot to see the overall pattern of population change with time.
 
You should see an S-shaped curve. Can you explain why the population increases more rapidly at intermediate size than at relatively large or small sizes?
 
==============================
 
'''a. Linear population growth''' is characterized by a fixed rate of growth; a constant number of individuals accrues within a given time period. In the following case the population adds 20 beetles each month (b = 20) to an initial population of 10.
<blockquote>
'''Linear''' model: '''N<sub>t</sub> = N<sub>0</sub> + bt '''
         
{| border="1"
|+
! &nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; '''Time (t, months)''' &nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;    !!&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;  '''Number of Individuals (N<sub>t</sub>)''' &nbsp;&nbsp; &nbsp;   
|-
| 0 || 10 (= N<sub>0</sub>) || 
|-
| 1 || 10 + 20*1 = 30 || 
|-
| 2 || 10 + 20*2 = 50 || 
|-
| 3 || 10 + 20*3 = 70 || 
|-
| 4, etc. || ... || 
|-
|}
</blockquote>
Plot the data using a scatter plot without lines.  After you plot your data, click on the series of data points, go the Chart/Add Trendline, choose linear for type, then in options choose Display equation on chart.  You should see that the equation exactly matches your model on population growth with time.<br><br>


b. During '''exponential growth,''' the rate of population growth depends on the population size; the larger the population, the faster it grows!  In the following case, let’s assume that r = 1; this “intrinsic rate” of population growth seems small, but watch what happens in a very short amount of time.<br><br>
d) '''Logistic Growth.''' Now, on your own, try to set up a third spreadsheet to model logistic growth.
<blockquote>
<blockquote>
'''Exponential''' model: N<sub>t</sub> = N<sub>0</sub>e<sup>rt</sup>
'''Logistic model:     N<sub>t</sub> = (N<sub>0</sub>K)/(N<sub>0</sub>+[K- N<sub>0</sub>]e<sup>-rt</sup>)'''<br><br>
In Excel, the command for “e” is EXP.  The right hand of the above expression would be calculated as '''N<sub>0</sub>*EXP(r*t).'''
   
{| border="1"
|+
! &nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; '''Time (t, months)''' &nbsp; &nbsp;&nbsp;&nbsp;  &nbsp;&nbsp;    !!&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;  '''Number of Individuals (N<sub>t</sub>)''' &nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; 
|-
| 0 || 10 (= N<sub>0</sub>) || 
|-
| 1 || 10*EXP(1*1) = 27 || 
|-
| 2 || 10*EXP(1*2) = 74 || 
|-
| 3 || 10*EXP(1*3) = 201 || 
|-
| 4, etc. || ... || 
|-
|}
</blockquote>
Again, plot the data using a scatter plot without lines.  After you plot your data, click on the series of data points, go the Chart/Add Trendline, choose exponential fro type, then in options choose Display equation on chart.  The equation should exactly match your model of exponential population growth with time. 
 
Explain why the exponential model produces a J-shaped curve rather than a linear straight line.  (Hint:  Identify the impact of N on population growth and what happens as N increases).
 


c. Now, on your own, try to set up a third spreadsheet to model '''logistic growth'''.
Start at N<sub>0</sub> = 10, and set r = 1; let’s set K = 10,000.  
<blockquote>
Your Excel formula for '''N<sub>t'''</sub> would be: =(10*10000)/(10+((10000-10)*EXP(-1*t))).</blockquote>
'''Logistic model: N<sub>t</sub> = (N<sub>0</sub>K)/(N<sub>0</sub>+[K- N<sub>0</sub>]e<sup>-rt</sup>)'''<br><br>


If N<sub>0</sub>= 10, r = 1; and K = 10000, your Excel formula for '''N<sub>t</sub>''' would be:<br><br> '''(10*10000)/(10+(10000-10)*EXP(-1*t))'''
Excel will not plot a logistic equation through the data points, so just link the points using a line scatter graph or smooth line plot to see the overall pattern of population change with time.<br><br>
</blockquote>
Excel will not plot a logistic equation through the data points, so just link the points using a dot-to-dot scatter plot to see the overall pattern of population change with time. <br><br>


You should see an S-shaped curve. Can you explain why the population increases more rapidly at intermediate size than at relatively large or small sizes?
You should see an S-shaped curve. Can you explain why the population increases more rapidly at intermediate size than at relatively large or small sizes?


=='''Building Models of Beetle Populations in Stella'''==
=='''Assignment'''==
a) Building a simple '''exponential''' Stella model that you can be adapted to a '''logistic''' model.
1. Prepare for a workshop style presentation and discussion as described by your lab instructor. The oral presentations are designed to expand your knowledge of population growth and interactions and to reflect on our ''Tribolium'' beetle experiment. The oral presentations topics and format will be described by your lab instructor. Be sure to sign up before leaving lab today.


<center>Table 1.  A description of the functions of icons used to build a Stella model.
[[Image:Table_11.1_S11.png|450px]]</center>


1. Open Stella, File, New and click on the MODEL tab.
2. Write a research paper on the ''Tribolium'' experiment. A full scientific paper in the Biological Sciences consists of the following sections: Abstract, Introduction, Methods, Results, Discussion, and Literature Cited. Follow the guidelines of your instructor regarding the sections to be included in your report.


2. Place a stock (square) and name it '''N beetles'''.
Please refer to the chapter [[BISC_111/113:Science_Writing_Guidelines | Science Writing Guidelines]] of the Wiki for a reminder of what should be covered in each of these sections. Procedures for constructing graphs and running statistical tests are available at [[BISC_111/113:Statistics_and_Graphing | Statistics and Graphing]].
 
3. Place a flow connecting to the stock and name it '''change in beetles'''.
 
4. Place a converter (circle) and name it '''initial beetles'''.
 
5. Place another and name it '''r'''.
 
6. Use connectors in the manner below.
 
<center>[[Image:Stella setup v2 S11.png|350px]]</center>
 
'''Entering Values'''<br>
<dl>7. Replace each “?” by double clicking on the icon and typing in the following values:<br>
<dd>Initial beetles = 20<br>
<dd>N = initial beetles<br>
<dd>r= 2<br>
<dd>Change in beetles = N * r
</dl><br>
 
'''Create a table and graph to visualize your simulated population.'''<br>
Double click on the graph icon and then double click on the y axis to select the parameter(s) you wish to graph over time. When you first build a model, it helps to select more than one variable so you can sort out the relationships you have built.<br><br>
Click '''RUN'''to run your simulation.<br><br>
 
b) Now try to model '''logistic''' growth. Remember the logistic equation is<br><br>
<center>'''N<sub>1</sub> = r N<sub>0</sub> (1 – (N<sub>0</sub> / K))'''.</center>
 
What two variables are being compared on the following graph? Can you create a similar graph?
 
<center>[[Image:Logistic Growth Curve Examples S11.png|450px]]</center>
 
 
c) Consider what other elements you might add to better understand your experiment and try to create a more complex working model. Reflect on the following questions: Was the carrying capacity constant in the beetle jars? What type of population growth was occurring in the jars? Do you have enough data to defend your opinion? Keep in mind that the generation time in <i>Tribolium</i> is about a month.
 
On the INTERFACE tab, it is possible to include a slider for something like the growth rate (r) or initial population. Open a new graph on that page with N on the y-axis and check the comparative allowable box. You can quickly see the effect on the population size as you manipulate and “stretch” each variable.
To add new dimensions to your model, consult the Stella tutorials at [[http://www.icsystems.com | www.icsystems.com]].
 
=='''Assignment'''==
1. Prepare for a workshop style presentation and discussion as described by your lab instructor. The oral presentations are designed to expand your knowledge of population growth and interactions and to reflect on our ''Tribolium'' beetle experiment. The oral presentations topics and format will be described by your lab instructor. Be sure to sign up before leaving lab today.


2. Hand in a research paper on the ''Tribolium'' experiment. The following sections should be included: Results, Discussion, Literature Cited.  Please refer to the Science Writing section of the Wiki.
The research paper is due on the last day of classes.

Revision as of 07:21, 7 July 2014

Objectives

  1. To finish the Tribolium experiment by conducting final counts and start processing data
  2. To explore simple models of population growth and interactions in Excel

Lab 11 Overview

I. Complete the Tribolium population growth experiment

II. Model changes in population size using Excel
a. Geometric Growth
b. Exponential Growth
c. Linear Growth
d. Logistic Growth

III. Assignment

Completing the Tribolium population growth experiment

Today you will complete the final counts of your Tribolium populations. Your samples have been placed in the freezer for at least 48 hours prior to the lab. You can isolate the beetles/pupae by sifting some of the culture through the screen over the brown paper on your bench. Try to keep all the flour away from the computers. As you isolate the beetles, put them in a labeled petri dish. There are tools available on your lab bench to help with the counting.

Enter your data on the class spreadsheet.

Refer to your lab instructor for information about the oral presentations next week. Sign up for a topic before leaving lab today.

Population Growth and Interactions: Background

Population Structure
A population is a group of individuals of the same species in a given area with the potential to interbreed. Each population has a structure that includes features such as density, spacing, and movement of individuals over time and space.

Spatial structure addresses the dispersal of individuals in space and can be classified as evenly spaced, clumped or totally random. Genetic structure of a population describes the distribution of genetic variation within that group. There is genetic variation among individuals within the population. This variation is the basis of the population’s ability to respond to environmental changes through adaptive evolution.

The study of population dynamics examines the ways that populations grow or shrink over time. Reproduction and immigration account for population increases, and death and emigration account for decreases. While some populations may reproduce continually, others experience discrete periods of reproductive growth. Because some populations (e.g. human) have no distinct reproductive season, the population grows more or less continuously.

Geometric Growth
Mathematical models offer a way to describe and predict population growth over time and under a variety of conditions. Generally, populations grow by multiplication, if all individuals have the potential to contribute equally to the population by reproducing. It follows then that the amount of growth that occurs is proportional to population size. As an example, consider the measurements of a population’s size below. How fast is this population growing?

         Year measured                   Population size     
        2006         100
        2007         160
        2008         256
        2009         410

To calculate the per capita growth rate (the average contribution each individual makes to the population’s growth) from 2006 to 2007, we simply compute 160/100 = 1.6. This population has grown by 60% during the year (a factor of 1.6). Doing this for all subsequent 1yr intervals (256/160 = 1.6, 410/256 = 1.6) we see that the population is growing at a constant rate of 1.6 from year to year. When calculated for discrete time intervals such as from year to year, this is called the geometric growth rate of the population, and is symbolized by λ (the Greek letter “lambda”):

λ = Nt / Nt-1

where Nt is population size at some time interval “t”, and
Nt-1 is population size at the previous time interval “t-1”.

With a little algebra, we can use this simple equation as a powerful tool to make predictions about the population's growth:

Nt = Nt-1 * λ


which is the same as:

Nt+1 = Nt * λ


If we followed a population’s growth from its initial size (N0) at “time zero” (t = 0), its size after one year (or any specified time unit) would be N1 = N0 * λ. At year two, N2 = N1 * λ, but because N1 = N0 * λ, N2 is also = N0 * λ * λ, or N0 * λ2.

To generalize this expression:

Nt = N0 * λt.

Exponential Growth
We can use this expression to predict the population size at any future time “t” from some initial size (N0), if the population growth rate (λ) is constant. In our example above where N0 = 100 individuals, after 15 years the population would be predicted to be quite large under a constant population growth rate of 1.6 (N15 = 100 * 1.615 , or > 115 * 103 individuals).

Calculations involving population growth can be more easily handled if we express the population growth rate as an exponential constant, r, rather than the geometric constant, λ. We can do this by substituting er, for λ in our computations. “e” is the base of Naperian, or natural, logarithms, and is equal to approximately 2.718. The equation for exponential population growth then, is
Nt = N0 * ert

Why use r instead of λ? The geometric constant depends on the interval of time specified; λ= 1.6 over 1 yr, in the previous example, but 2.56 over 2 yr. The exponential constant r is an instantaneous measure of relative population growth at every moment in time, and is hence more generally useful. Exponential growth is like a compound interest savings account, where the interest is continually added to the principal. Geometric growth is akin to simple interest, where the account balance is updated once a year. Exponential growth is especially applicable to continuously reproducing populations, such as the human population.

During exponential growth, the population grows by an amount dN, during a time interval dt (this is the population growth rate) and the amount of growth in this interval is proportional to the size of the population (Nt) by the constant r:

dN/dt = rNt


Where
Nt = population size (at time “t”), and
r = the instantaneous rate of population growth.

You can also see that r = (dN/dt)/Nt . And so during exponential growth, r is the per capita rate of increase of the population.

Exponential population growth displays a J-shaped curve of N over time. Compare exponential growth to a simple linear model:

Exponential growth: Nt = N0 * ert
Linear growth: Nt = N0 + b*t

Where:
N0 = the initial (starting) population size at time t = 0
t = time elapsed from time = 0 to time = t
b = the population linear growth rate, and is a constant that is not proportional to N; it is the slope of the N vs. t linear relationship. Here, dN/dt” = b. (You will see that this relationship is described by a linear regression of N on time.)

Linear Growth.
Linear models may be appropriate over short time intervals, but seldom describe long-term population growth because they fail to include an increasing number of reproductive individuals as the population grows. However, while exponential growth models are more realistic than the linear models, neither reflects the dynamics of most natural populations over the long term. There are several reasons for this, as we will see below. Nonetheless, “r” is a very useful parameter in modeling (describing & predicting) population growth as an integrator of life history traits (e.g., when & how much to reproduce) and growth potential.

Logistic Growth.
Exponential growth, if unchecked, could lead to unimaginable numbers of everything from bacteria to elephants. After all, the exponential rate of population increase is proportional to the population size; the bigger the population gets, the faster it grows! Of course, most natural populations never achieve their potential for unlimited size; Darwin was keenly aware of this fact. A third model, the logistic population growth model, tends to be more realistic because it takes into account “environmental resistance” (K) or carrying capacity. K is the maximum, or equilibrium, population size that can be sustained theoretically by the environment. When K is reached the population growth rate is zero due to a balance of births and deaths. K is influenced by resource availability, waste accumulation, and other density-dependent factors (see below).

In logistic population growth, dN/dt = r Nt *[(K- Nt)/K]

Here, K = the carrying capacity, and other terms are as defined above.

Note that the bracketed term, [(K- Nt)/K] acts as a “braking” factor to slow the rate of population growth as the population nears its carrying capacity. See that when N is very small, the entire expression collapses to unity (K/K = 1), and the population grows exponentially. However, as N increases, the bracketed term approaches zero, and thus dN/dt, the population growth rate, approaches zero. This braking effect results in an S-shaped population growth curve.

The logistic equation for predicting N at some time “t” looks forbidding, but is not too difficult. The terms in this equation are as defined above.

Nt = (N0K)/(N0+[K- N0]e-rt)


Population growth in nature
The models we have presented are more often representative of laboratory populations growing under controlled conditions, rather than the patterns seen in natural populations. In the logistic model, as long as the population size (N) is less than the carrying capacity (K) the population will increase, and the rate of increase slows as N approaches K. However, even this model is often too simple to capture the dynamics of natural populations. If you read any of the original articles by Park about Tribolium beetles, you see that the growth curves are complex and not usually predictable. It is important to understand that K in the logistic equation is fixed, but that in reality K will continually change as environmental characteristics (e.g., availability of food & space) change.

Models of natural populations must account for the complexity of multiple interacting environmental factors. For example, in many populations, there are distinct breeding seasons and periods of growth so it becomes important to measure the population at the same time each year to take into account when the majority of births and deaths occur. The resources supporting populations are dynamic quantities, as are habitat characteristics, interspecific competitors, predators, and pathogens. And now, natural populations are facing the challenges of rapid local and global climate change.

Population Regulation
Density-dependent factors such as predators, quality of cover, parasites, diseases, and amount of food determine K, and therefore, may regulate populations by maintaining or restoring them to some equilibrium size.

Density-independent factors, in particular, environmental factors such as temperature, precipitation, and disturbances (e.g., fire, floods, earthquakes, tsunamis) can also alter the rate of population growth. These factors, however, are density independent because they affect a certain proportion of the population independently of population size (and largely independent of individual fitness).

Density-dependence is difficult to demonstrate in nature, in part because of frequent changes in environmental conditions. As a result, some ecologists refute the concept of “equilibrium” entirely and are currently interested in models based on chaos theory. Chaotic systems behave in unpredictable ways, even though the factors influencing them may be quite deterministic. As the number of such interacting factors increases, the ultimate “trajectory” a system takes, such as how a population grows, depends strongly on the starting conditions, and can be highly unpredictable. Chaos typifies many such “complex systems”.

Modeling Population Growth using Excel

In Excel, you will produce figures that demonstrate:
a. geometric growth
b. exponential growth
c. linear growth
d. logistic growth

Figures should cover a 12-month time period with an estimated population size for each month. Don’t worry about creating a fancy graph -- just plot the data to make sure you have set up the model correctly.

a) Geometric Growth typifies a population that grows at a fixed proportion (λ) of population size over equal time intervals. Assume that this pattern of growth applies here. First, calculate λ from the first two time intervals at t = 0 and t = 1 month. Then, calculate Nt for the remaining months, and plot against time using a line scatter graph.

Geometric model: Nt = N0 * λt

         Time (t, months)                   Number of Individuals (Nt)     
    0     10 (= N0)
    1     45
    2     ...
    3     ...
    4, etc.     ...

b) During Exponential Growth, the rate of population growth depends on the population size; the larger the population, the faster it grows! This is similar to geometric growth, except that we apply an instantaneous measure of growth, r. In the following case, let’s assume that r = 1; this “intrinsic rate” of population growth seems small, but watch what happens in a very short amount of time.

Exponential model: Nt = N0ert
In Excel, the command for “e” is EXP. The right hand of the above expression would be calculated as N0*EXP(r*t)

         Time (t, months)                   Number of Individuals (Nt)     
    0     10 (= N0)
    1     10 * EXP(1*1) = 27
    2     ...
    3     ...
    4, etc.     ...

Plot the data using a scatter plot without lines. After you plot your data, click on the series of data points, go to Chart/Add Trendline, choose exponential for type, then in options choose “Display equation” on chart. The equation should exactly match your model of exponential population growth with time.

c) Linear population growth is characterized by a fixed amount of growth per time interval; a constant number of individuals accrues within a given time period. In the following case the population adds 20 beetles each month (b = 20) to an initial population of 10.

Linear model: Nt = N0 + b*t

         Time (t, months)                   Number of Individuals (Nt)     
    0     10 (= N0)
    1     10 + 20*1 = 30
    2     ...
    3     ...
    4, etc.     ...

Plot the data using a scatter plot without lines. After you plot your data, click on the series of data points, go to the "Chart/Add Trendline", choose "linear" for type, then in options choose “Display equation” on chart. You should see that the equation exactly matches your model of population growth with time.

Compare exponential and linear model outputs. Explain why the exponential model produces a J-shaped curve rather than a linear straight line. (Hint: Identify the impact of N on population growth and what happens as N increases).

d) Logistic Growth. Now, on your own, try to set up a third spreadsheet to model logistic growth.

Logistic model: Nt = (N0K)/(N0+[K- N0]e-rt)

Start at N0 = 10, and set r = 1; let’s set K = 10,000.

Your Excel formula for Nt would be: =(10*10000)/(10+((10000-10)*EXP(-1*t))).

Excel will not plot a logistic equation through the data points, so just link the points using a line scatter graph or smooth line plot to see the overall pattern of population change with time.

You should see an S-shaped curve. Can you explain why the population increases more rapidly at intermediate size than at relatively large or small sizes?

Assignment

1. Prepare for a workshop style presentation and discussion as described by your lab instructor. The oral presentations are designed to expand your knowledge of population growth and interactions and to reflect on our Tribolium beetle experiment. The oral presentations topics and format will be described by your lab instructor. Be sure to sign up before leaving lab today.


2. Write a research paper on the Tribolium experiment. A full scientific paper in the Biological Sciences consists of the following sections: Abstract, Introduction, Methods, Results, Discussion, and Literature Cited. Follow the guidelines of your instructor regarding the sections to be included in your report.

Please refer to the chapter Science Writing Guidelines of the Wiki for a reminder of what should be covered in each of these sections. Procedures for constructing graphs and running statistical tests are available at Statistics and Graphing.

The research paper is due on the last day of classes.