Exponential Growth

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

Don't use plagiarized sources. Get Your Custom Essay on

Exponential Growth | Academic Papers Help

This is a Snippet Preview Access a Complete Custom Written Paper Done by Our Expert Writers

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 ten years. For example, 10, 20, 30 years would be good choices. If you want to see a more dramatic change, select a longer time frame such as 10, 50, and 100 years.

5.When you input all of your data, youll see that the spreadsheet has performed the calculations for the future size of each population, rate of growth, and time interval. AIDitionally, this information will be presented graphically in the chart. To draw an exponential curve for each series, do the following: a.Right click on the miIDle point for one of the series.

b.Click on aID trendline.

c.Under Trendline Options, select Exponential.

d.Click Close

e.Repeat these steps for the other series.

Now that youve 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, youll 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. AIDitionally, 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.

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

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

4.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?

5.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?

6.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 aIDress 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, February 1, 2014.

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 populations 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

ORDER THIS ESSAY HERE NOW AND GET A DISCOUNT !!!

Why Work with Us

Top Quality and Well-Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Money-Back-Guarantee

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.

Admissions

Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Reviews

Editing Support

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Reviews

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.