1. World Population Growth(9 points)
Year Population
1927 2
1960 3
1974 4
1987 5
1999 6
2012 7
- a) Use Excel to make a scatterplot of the following data showing the world’s population growthin billions.
- Then find the best-fit regression line and the best-fit exponential function and add these to your chart.
- b) Use Excel to find the correlation coefficients for the two models (linear and exponential). Does either model fit the data to an acceptable level? Which one do you think is better?
- c) Use your answer(s) to a) and b) to predict the world’s population size in 2040.





