math question need assitance with NEED IT TODAY 5.6 please!

Question

1)     The table below gives the estimated world population (in billions) for various years. 

Year	1980	1990	1997	2000	2005	2011	Remember to treat the year of your first observation as x = 0.
Population	4400	5100	5852	6080	6450	7000

Linear Regression Equation: ____________________

Correlation Coefficient (r), rounded to three decimal places: _________

Type of Correlation: ______________________

       (positive, negative, none)

 Is the correlation strong? Explain                                                                                 

 Using the linear regression equation estimate the world population in the year 2015. 

Answer 1

You can use Excel to do regression very quickly.

In this case the regression equation is P = 84.91y + 4356 where P = population and y = year starting with 0 for 1980. The regression coefficient is .996 which is strong.

In 2015 (y=35), in 2015 (y = 35), the Population is predicted to be 7327.85.