Years since 1800 Population (in billions) 1804 1 1850 1.2 1930 2 1960 3 1974 4 1987 5 1999 6 2011 7
|
year |
Years since 1800 |
Population (in billions) |
|
1804 |
|
1 |
|
1850 |
|
1.2 |
|
1930 |
|
2 |
|
1960 |
|
3 |
|
1974 |
|
4 |
|
1987 |
|
5 |
|
1999 |
|
6 |
|
2011 |
|
7 |
2.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?
A.Linear decay
B.Linear growth
C.Exponential decay
D.Exponential growth
3.On your scatter chart, insert a linear trendline. Make sure you display the equation and r2 value on the chart. Fill in the blanks to write the equation for the world population, P, as a
P(t) = __________ t+________
Fill in the blanks and explain the meaning of the slope and y-intercept:
The slope of ________ means that: Every _______ the _________ increase by ________ The y-intercept of ________ means that: In the year ______ the ______ was ______
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
