1. Go to the websitehttps://www.worldometers.info/world-population/and use the data in theSummary Table(you must scroll down the pagepastWorld Milestones)to fill in the missing values in the chart below. (8 points)

Year

Years Since 1800

Population (in Billions)

1804

4

1Billion

1850

50

1.2Billion

1930

130

2Billion

1960

160

3Billion

1974

174

4Billion

1987

187

5Billion

1999

199

6Billion

2011

211

7Billion

1. To write exponential model by hand without Excel we need to know two things:the yearly growth or decay rate and the starting value.

Look on the given website under the "Growth Rate"heading to find the current growth rate of the world's population. Notethat this is the growth rate r,and you will need to convert it from a percentage to a decimal before you use it in your model.Sincethe population in the year 1800 was just under 1 billion, use 1as your starting population (in billions)in 1800.

Write the exponential modelP, wheretis years since 1800andPis the population in billions,using the growth rate and startingpopulation. (8 points)

Answer:

1. Returnto your scatterplot in Excel.Insert anexponential trendlineand record itbelow, roundthe growthfactorto four decimal places and the initial value to two decimal places. (8 points)

I need help understanding the formula and how to put it in excel