In Module 4, you were introduced to the concept of exponential functions that can be used to model growth and decay. Recall what you learned in The Number e lecture. In this exercise, you will use a Microsoft Excel spreadsheet to calculate the exponential growth of a population of your choosing. (If you use the linked spreadsheet below, it is recommended that you consider relatively small populations and not those of entire nations.)
Microsoft Excel spreadsheet that you will use to perform the calculations for this
In the spreadsheet, perform the following operations:
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:
Use the exponential equation: Future value = Present value * exp(rt)
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.
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 Monday, July 20, 2015.
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 
Delivering a highquality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a moneyback guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarismdetection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more