Go to the websitehttps://www.worldometers.info/world-population/(opens in new window) and use the data in the Summary Table to fill in the missing values in the chart below.

To write an exponential model by hand without Excel we need to know two things: the yearly growth or THE WORLD'S POPULATION, CONCENTRATED 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 If the world's 4.9 billion people lived in one city. how large population. Note that this is the growth rate r, and you will need to convert it from a percentage to a decimal would that cay be if it ware as done as.. before you use it in your model. Since the population in the year 1800 was just under 1 billion, use 1 as your starting population (in billions) in 1800. A by-hand exponential model for the world population would be P(!) = where t is years PARIS SAN FRANCISCO since 1800 and P is the population in billions. NEW YORK LONDON SINGAPORE HOUSTON PERYear 1850 1960 1974 Years Since 1800 50 160 174 Population in billions 1 2 5 QUESTION 2 5 points Save Answer Open an Excel file and construct a scatter chart using the data gathered in the previous question. You will use the bottom two rows to make your chart. From looking at the pattern of the data points, which type of model do you think will work best? O Exponential growth O Exponential decay O Linear decay O Linear growthQUESTION 7 Now lets compare the two exponential models that we have. 2009 The by-hand model predicts a population of billion in the year Human 2000 (when t = 200). Footprint 50 The Excel model predicts a population of billion in the year 2000. Round your answers to two decimal places.Look up the actual world population in 2000. Which model was more accurate, the one we wrote by hand or the one from Excel?: O Model written by hand O Model from Excel QUESTION 9 8 points The World Population Clock indicates that the growth rate is declining. It estimates that in 2030 the population will be about 8.5 billion and the growth rate will be about 0.879% per year. Write a new exponential model for P(t), the population t years after 2030. Q = (1+ QUESTION 10 5 points Many scientists believe that the earth can support a maximum human population of about 10 billion people WORLD POTENTIAL LAND USE CAPABILITIES indefinitely without running out of resources. According to your model, in what year will we reach that population? Hint: remember your model's starting year is 2030, so once you solve for t you need to take into account that you didn't start at year 0.QUESTION 5 Now let's maI-ce an exponential model in Excel. Return to your scatter chart and insert an exponential trendline. Record the equation here. Round everything to four decimal places. 'f = Re 3': or in [1 form that's 0 = t it QUESTION 5 1Which of Excel'e models is a better t for the data eel'? Linear Exponential