Show me how to post my homework

Just do my homework!

  • HTML tags will be transformed to conform to HTML standards.
  • Add rel="nofollow" to external links
Question
Submitted by Thman2c on Sat, 2013-04-27 20:28
due on Sat, 2013-04-27 20:22
answered 1 time(s)
Hand shake with Mahound: In progress
Hand shake with teddysule: In progress
Thman2c is willing to pay $15.00
Thman2c bought 175 out of 179 answered question(s)

Exponential Growth

Hello,  I have attached a assignment that was not completed.. Please look at the word document and the spreadsheet which was not completed.  I need this completed in a rush before midnight if possible.

 

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:

  1. Input a population value into the box next to Initial Population on the spreadsheet. This population should be anything such as the people, animals, microorganisms, or plants.
  2. 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.
  3. 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.
  4. 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.
  5. 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:

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

  1. 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.
  1. 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.
  1. 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?
  2. 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?
  3. 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:

  • Future value = Present value *exp(rt)
  • Where exp is the base “e” of exponential,
  • r = annual rate of growth, expressed as a percent
  • t = years
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
Submitted by Mahound on Sat, 2013-04-27 22:06
teacher rated 105 times
4.885715
purchased 7 times
price: $10.00

Exponential Growth-Sold before

body preview (0 words)

file1.docx preview (490 words)

xxxxxxxxxxx Growth

The xxxxxxxxxx of xxx United xxxxxx xx 311 Million according xx statistics. Three possible values xxx xxx growth xxxx xxx xxx 3% and 5%

xx xxxxxxxxx the Future value we use the xxxxxxxxx

r is the rate xx growth and t is the number of xxxxxx

xxxxxxxxxxxx initial xxxxxxxxxxx x xxx t with 311, xxx and 3 xxxxxxxxxxxx

Million

For xxx

Million

xxx xxx

xxxxxxx

xxx future xxxxxxxxxx xxx xxx xxx x xxxxxx from the figures xxxxxxxxxx xx xxx xxxxxxxxxxx xx x xxxxxxxx this xx because the spreadsheet does not round the xxxxxx but xxxxxxx takes the whole number xxx xxxxxxxxxx the xxxxxxxx xxxxx the xxx xxxxxxxxx The xxxxxx population xxxx xxx xx the xxxx xx xxx xxxxxxxxxxx xxx xx my calculations because xxx number is rounded xxxxx

For r=3%

Million

xxx t=5

Million

For xxx

xxxxxxx

For xxxx

xxxxxxx

For t=5

Million

For xxx

xxxxxxx

The xxxxxx xx xx xxxxxxxxxxxx xxx the xxxxxxxxxxx xxx xxx xxxx if we xxxxxx xxx xxxxxxxx xxx only xxxx xxx xxxxx xxxxxx of xxx

- - - more text follows - - -

file2.xlsx preview (32 words)

Sheet1

xxxxxxxxxxxxxxx
xxxxxxx Popluation 311xxxx 1 xxxx
xxxx x0.03
xxxx xxxxx
xxxx (years) Future Population for xxxx 1Future xxxxxxxxxx for xxxx xxxxxxx xxxxxxxxxx xxx xxxx 3
3 320340361
5xxx361xxx
xxxx383 441

Sheet2

xxxxxx


Buy this answer

Try it before you buy it
Check plagiarism for $2.00