Assignment 1: Exponential Growth
Assignment 1: Exponential Growth
In Module 4, you were introduced to the concept of exponential functions that can be used to model growth and decay. In this exercise, you will use a Microsoft Excel spreadsheet to calculate the exponential growth of a population of your choosing.
Click here to open the Microsoft Excel spreadsheet that you will use to perform the calculations for this assignment.
In the spreadsheet, perform the following operations:
 Input a population value into the box next to Initial Populationon the spreadsheet. This population should be anything such as the people, animals, microorganisms, or plants.
 Input a rate of growth for your population into the box next to Rate 1. Since we are interested in a positive annual percent growth rate per year, this number should be greater than zero percent. Be sure to input this number in the form of a decimal.
 Repeat the above procedure for Rate 2 and Rate 3. Make sure that the values you select differ by two percent. For example, the values 0.01, 0.03, and 0.05 would be good choices.
 Under the Time (years)column, input three different year values. Make sure that your values increase by a minimum of two years. For example, 3, 5, 7 years would be good choices.
 When you input all of your data, you’ll see that the spreadsheet has performed the calculations for the future size of each population, rate of growth, and time interval. Additionally, this information will be presented graphically in the chart.
Now that you’ve completed your analysis, it is now time to report the results and examine your findings.
In a Microsoft Word document, respond to the following:
 Calculate what the future size of the population will be, given a specific initial population, rate of growth, and time interval.
Use the exponential equation: Future value = Present value * exp(rt)
 exp is the base "e"
 r = annual rate of growth expressed as a percent
 t = years
Note: The spreadsheet performed these calculations for you, so you can check the answer you obtain with those in the spreadsheet. In order to perform this calculation, you’ll need to have access to a scientific calculator that will have an ex button in order to perform the exp(rt) calculation. There are a number of free scientific calculators available over the Internet. Additionally, all smartphones have calculator apps that have a scientific mode. Check with your instructor for a list of currently available free options if you do not own a scientific calculator.
 Repeat the calculation for at least two other values of t; make sure they are at least two years apart from one another. Use the same values you input into the spreadsheet and compare the answers you obtain to those that appear in the spreadsheet.
 Repeat the calculations using two more selections of population growth rate; ensure that each population growth rate is at least two percent different than the others. Use the same values you input into the spreadsheet and compare the answers you obtain to those that appear in the spreadsheet.
 Examine the graph that your spreadsheet produced based upon the calculations. Did this graph consist of straight lines or curved lines? Describe the shape of these lines for each growth rate. How did they differ? Why?
 Explain the implications of growth rate for your population. What do you think will happen over a long period of time if a given population of organisms is allowed to increase without limits? Are there environmental factors that keep populations from growing exponentially unchecked? What would be the impact on environmental resources?
 Explain the likelihood of your results. Would it be expected that the percent growth rate would stay constant over long periods? Is exponential growth an appropriate assumption for long periods? If not, what other changes in population size might be expected?
For this assignment, you will submit a spreadsheet and a report. The spreadsheet will be the Microsoft Excel file containing your analysis. Name your Microsoft Excel file as follows: LastnameFirstInitial_M5_A1.xls.
The report will be a Microsoft Word document in which you will address all of the questions in this assignment in the form of a narrative. Name your Microsoft Word document as follows: LastnameFirstInitial_M5_A1.docx.
Submit both documents to the M5: Assignment 1 Dropbox by Saturday, April 20, 2013.
Assignment 1 Grading Criteria 
Maximum Points

Select a population size (population could consist of people, animals, microorganisms, or plants). 
20

Select a positive annual percent growth rate per year, which should be greater than 0%. 
20

Calculate what the future size of the population will be, given the below assumptions. Use the exponential equation:

20

Repeat the calculation for SECOND value of t (make sure they are at least two years apart from one another). 
20

Repeat the calculation for THIRD value of t (make sure they are at least two years apart from one another). 
20

Graph the results for population growth by % growth rate, vs. time in years for all FIRST calculations of t. 
40

Graph the results for population growth by % growth rate, vs. time in years for all SECOND calculations of t. 
40

Graph the results for population growth by % growth rate, vs. time in years for all THIRD calculations of t. 
40

Explain the implications of this growth rate for the population’s resource use and the environment. 
40

Explain the likelihood of your above results. Would it be expected that the % growth rate would stay constant over long periods? 
40

Total: 
300

Answer rating (rated one time)
Assignment 1: Exponential Growth
body preview (3 words)
xxxxxxxxxx 1: xxxxxxxxxxx Growth
file1.doc preview (1094 words)
xxxxxxxxxxx xxxxxx xxx xxxx xx xxxxxxxxxxx xxxxxxxxxxxxxxxxxxx GROWTH � xxxx \* xxxxxxxxxxx xxxxxxxx
xxxxxxxxxxx xxxxxxx
Name:
Course:
College:
xxxxxxx
Date:
�
Initial xxxxxxxxxx x 50 Lion x
xxxxxx growth xxxx 1= 0.3 percent
Annual growth xxxx xxxxx percent
xxxxxx growth xxxx xxxxx xxxxxxxx
Future xxxxxxxxxx for rate x
xxxxx 3 years x xxx xxxx x
xxxxx x xxxxxx xxx Lion s
xxxxx seven xxxxx xxxx xxxx s
xxxxxx xxxxxxxxxx for xxxx 2
xxxxx 3 xxxxx x xxx Lion xx
after 5 xxxxxx 609 xxxx x
x xxxxxx xxxx Lion s
xxxxxx xxxxxxxxxx xxx rate 3
xxxxx x xxxxx = xxxx
xxxxx x years= xxxxx
7 xxxxxx 6714
xxxxxx
xxxxx model xxx specifically xxxxx to find out xxxxxxxxxxx xxxxxx xx Lion x xx a park. xxxx xxx model xx is apparent that xx xxx current xxxxxx xxxx
   more text follows   
Try it before you buy it 
A++ PERFECTLY DONE (MS EXCEL + WORD REPORT)
body preview (0 words)
file1.docx preview (663 words)
xxxxxxxxxxx Growth
xxxxxxx’x xxxx
xxxxxx
Instructor
xxxx
xxxxxxxxx xxxx xxx xxxxxx size xx xxx population will be, given a xxxxxxxx initial population, rate of xxxxxxx and xxxx interval.
xxxxx the xxxxxxxxxxx xxxxxxxx xxxxxxx if xxx initial xxxxxxxxxx is P, rate of growth xx r xxx xxxx xxxxxx is t xxxxx xxxx the xxxxxxxxxx xxxxx x years would be,
Population x P*
Lets us calculate xxx rate xx Here r x xxxxx xxxxxxx xxxxxxxxxx xx xxxxxx
So, xxxxxxxxxx after xx xxxxx x 10000* x xxxxxxxx
Repeat xxx xxxxxxxxxxx for xx least xxx other xxxxxx of xx make sure they xxx xx least xxx years apart from one xxxxxxxx xxx the same xxxxxx you input xxxx xxx spreadsheet and xxxxxxx xxx answers xxx obtain xx those xxxx appear xx xxx xxxxxxxxxxxx
xxxxx xxx xxxx formula xx above xx xxxxx
xxxxxxxxxx xxxxx 30 xxxxx = xxxxxx = xxxxxxxx
Population xxxxx xx xxxxx = 10000* x xxxxxxxxx
xxxx that the xxxxxxxxxxx xxx not consider any xxxxx decimal xxxxxx xxx except xxx xxxxxxx points the xxxxxx
   more text follows   
file2.xls preview (35 words)
xxxxxx
xxxxxxxxxxxxxxxxxxInitial Popluation  xxxxx  xxxx x  xxxx 
xxxx 2  0.08  
xxxx 3  0.01  
Time (years)  xxxxxx Population xxx xxxx 1  Future xxxxxxxxxx xxx Rate x  xxxxxx xxxxxxxxxx for Rate x 
10  16487  xxxxx  xxxxx 
xx  44816  110231  xxxxx 
xx  xxxxxx  xxxxxxx  18221 
Sheet1
xxxxxxx
xSheet3
xTry it before you buy it 
A++ PERFECTLY DONE (MS EXCEL + WORD REPORT)
body preview (0 words)
file1.docx preview (663 words)
Exponential Growth
xxxxxxx’x Name
xxxxxx
Instructor
xxxx
xxxxxxxxx what the xxxxxx xxxx xx xxx population will xxx given a xxxxxxxx xxxxxxx population, rate of growth, and xxxx interval.
xxxxx xxx exponential xxxxxxxx xxxxxxx xx the initial population xx P, xxxx of xxxxxx is x xxx time period is x xxxxx xxxx the population after t years xxxxx be,
Population = P*
Lets us xxxxxxxxx for xxxx xx xxxx r x 0.05, initial xxxxxxxxxx is 10000.
xxx xxxxxxxxxx xxxxx 10 years x 10000* x 16487.21
Repeat the calculation xxx at xxxxx two other values of t; xxxx xxxx xxxx are at xxxxx two xxxxx xxxxx from one another. Use the same values xxx input xxxx xxx spreadsheet xxx compare xxx answers you xxxxxx xx those that xxxxxx in the spreadsheet.
Using xxx same xxxxxxx xx xxxxx we xxxxx
xxxxxxxxxx after xx xxxxx x xxxxxx = 44816.89
xxxxxxxxxx after 60 xxxxx = xxxxxx = 200855.37
Note xxxx the xxxxxxxxxxx xxx xxx consider any extra xxxxxxx xxxxxx xxx except the xxxxxxx points the xxxxxx
   more text follows   
file2.xls preview (35 words)
xxxxxx
xxxxxxxxxxxxxxxxInitial xxxxxxxxxx  10000  xxxx x  0.05 
Rate x  xxxx  
xxxx 3  xxxx  
Time (years)  Future Population for xxxx 1  xxxxxx Population xxx Rate x  Future xxxxxxxxxx xxx Rate 3 
xx  16487  22255  11051 
30  44816  110231  xxxxx 
60  xxxxxx  xxxxxxx  18221 
Sheet1
Sheet2
xxxxxx
xTry it before you buy it 