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, 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. To draw an exponential curve for each series, do the following:
   1. Right click on the middle point for one of the series.
   2. Click on add trendline.
   3. Under Trendline Options, select Exponential.
   4. Click Close
   5. Repeat these steps for the other series.

Unit 5: Module 5 - M5 Assignment 1Assignment 1: LASA 2: Exponential GrowthInModule 4, you were introduced to the concept of exponential functions that can be used to modelgrowth and decay. Recall what you learned inThe Number electure. In this exercise, you will use aMicrosoft Excel spreadsheet to calculate the exponential growth of a population of your choosing. (If youuse the linked spreadsheet below, it is recommended that you consider relatively small populations andnot those of entire nations.)Clickhereto open the Microsoft Excel spreadsheet that you will use to perform the calculations for thisassignment.In the spreadsheet, perform the following operations:1.Input a population value into the box next toInitial Populationon the spreadsheet. Thispopulation should be anything such as the people, animals, microorganisms, or plants.2.Input a rate of growth for your population into the box next toRate 1. Since we are interested in apositive annual percent growth rate per year, this number should be greater than zero percent. Besure to input this number in the form of a decimal.3.Repeat the above procedure forRate 2andRate 3. Make sure that the values you select differby two percent. For example, the values 0.01, 0.03, and 0.05 would be good choices.4.Under theTime (years)column, input three different year values. Make sure that your valuesincrease by a minimum of ten years. For example, 10, 20, 30 years would be good choices. If youwant 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, you’ll see that the spreadsheet has performed the calculationsfor the future size of each population, rate of growth, and time interval. Additionally, thisinformation will be presented graphically in the chart. To draw an exponential curve for eachseries, do the following:a.Right click on the middle point for one of the series.b.Click on addtrendline.c.Under Trendline Options, selectExponential.d.Click Closee.Repeat these steps for the other series.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 ofgrowth, and time interval.

 

• 1492953765-M51.xls
• 1492953768-M51.docx

ComputerScienceExpert

(11)

Status NEW Posted 23 Apr 2017 01:04 PM My Price 8.00

-----------

Attachments

file 1492953773-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer