Type the following table, which has historical world populationdata, into sheet 2 in rows 1 and 2.
Year 1000 1650 1800 1850 1900 1920 1930 World population, inmillions 200 545 924 1171 1635 1834 2170 10.
Graph the above population data using the same steps as inExercise 1. Add an exponential trendline, being sure to include theequation and R2 value in the chart. 11. In row 3 calculate thevalues for population predicted for each of the years by yourexponential model (as you did in step 9 of exercise 1). You willneed to use Excel’s “exp†function for the value of “eâ€, the baseof your exponential model. The complete exponent must be includedin parentheses as the input for the exp function. Note: Do not use“^†in the exp function. 12. In cell I1 enter the value 2008. 13.Drag your formula to cell I3. What does your model predict for theworld population in 2008? 14. In a complete sentence, explainwhether you believe this is realistic, and why. 15. Now let's usegoal seek to calculate what year the population was 1 billion (1000million). 16. Drag the formula from row 3 into cell J3. 17.Highlight cell J3 and click on tools then goal seek. 18. You wantExcel to fill in the value in cell J1 so that the formula in J3results in 1000. So in the pop-up box tell it to “set cell J3 tovalue 1000 by changing cell J1.†19. According to yourcalculations, when was the world population 1 billion? 20. Lookingat the actual population values in the table, how accurate do youthink your calculation is?
