Type the following table, which has historical world population data, into sheet 2 in rows 1 and 2. Year 1000 1650 1800 1850 1900 1920 1930 World population, 200 545 924 1171 1635 1834 2170 in millions 10. Graph the above population data using the same steps as in Exercise 1. Be sure to insert a row to show \"years since 1000\". Add an exponential trendline, being sure to include the equation and R2 value in the graph. 11. In row 4 calculate the values for population predicted for each of the years by your exponential model (as you did in step 7 of exercise 1). You will need to convert Excel's function to find the (1+r) or use If Excel's exp\" function for the value of \"e", the base of your exponential model. The complete exponent n A\" must be included in 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 l4. What does your model predict for the world population in 2008? 14. In a complete sentence. explain whether you believe this is realistic, and why. Merge cells together and explain in a complete sentence in row 6. 15. Now let's use goal seek to calculate what year the population was 1 billion (1000 million). 16. Drag the formula from row 4 into cell J4. 17. Highlight cell J4 and click on data, what if analysis then goal seek. 18. You want Excel to fill in the value in cell J2 so that the formula in J4 results in 1000. So in the popup box tell it to \"set cell J4 to value 1000 by changing cell J2.\" 19. According to your calculations, when was the world population 1 billion? Fill in cell J1 also. 20. Looking at the actual population values in the table, how accurate do you think your calculation is? Merge cells together and explain in a complete sentence in row 8