Solved by verified expert:Please this is a very important paper and if you cannot do it than do not do not waste the time.This is how the paper should answered I copied a portion of the LASA assignment and I have inserted, in the highlighted color, a breakdown of some of the steps in this assignment. I hope this will help clarify what you need to do for this assignment.SEE THESE EXAMPLES TO UNDERSTAND THE REQURIMENTCalculate 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 percentt = yearsFor example: Bald Eagle is my choice and its population is about 70,000Choose a positive annual percent growth rate. Example: 1%I am going to calculate the future size of the population for 10 years. (t=10)Future Value = 70,000 x e(.01×10)= 70,000 x e(.1)= 70,000 x 1.105171= 77,361.97Repeat 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.When t = 20 Future Value = 70,000 x e(.01×20)70,000 x 1.221402= 85,498.14When t=30 Future Value = 70,000 x e(.01×30)70,000 x 1.349859= 94,490.13Repeat 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.You will use the other two growth rates that you used in the spreadsheet and the same values for t that you used in the calculations in Questions #2 to perform these calculations. That means you will have a total of 6 more calculations, three for each growth rate. You should have a total of 9 calculations in your report.You supposed to choose a specific group of people, animal, or organism and research to find its population. You were supposed to choose growth rates that were at least two percent apart. There should be only one scatterplot and not three for the assignment.
lasa_2.docx
a.xls
Unformatted Attachment Preview
LASA 2: Exponential Growth
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.)
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, 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:
a.
b.
c.
d.
e.
Right click on the middle point for one of the series.
Click on add trendline.
Under Trendline Options, select Exponential.
Click Close
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 of growth, and time interval.
Use the exponential equation: Future value = Present value * exp(rt)
o
o
o
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.
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.
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.
Assignment 1 Grading Criteria
Select a population size (population could consist of
people, animals, microorganisms, or plants).
Select a positive annual percent growth rate per year,
which should be greater than 0%.
Maximum
Points
20
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
Repeat the calculation for SECOND value of t (make sure
they are at least two years apart from one another).
Repeat the calculation for THIRD value of t (make sure
they are at least two years apart from one another).
Graph the results for population growth by % growth
rate, vs. time in years for all FIRST calculations of t.
Graph the results for population growth by % growth
rate, vs. time in years for all SECOND calculations of t.
Graph the results for population growth by % growth
rate, vs. time in years for all THIRD calculations of t.
Explain the implications of this growth rate for the
population’s resource use and the environment.
Explain the likelihood of your above results.
Would it be expected that the % growth rate would stay
constant over long periods?
20
20
20
40
40
40
40
40
Initial Popluation
0
Rate 1
Rate 2
Rate 3
Time (years)
0
0
0
Future Population for Rate 1
0
0
0
Future Population for Rate 2
0
0
0
1
0.9
0.8
0.7
0.6
0.5
0.4
0.3
0.2
0.1
0
0
0
0
0
Future Population for Rate 3
0
0
0
0
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
1
…
Purchase answer to see full
attachment
