Question: I determined the regression equation for the data table below is : y = -0.1126x + 239.47 Using this formula and excel, I estimated the
I determined the regression equation for the data table below is : y = -0.1126x + 239.47
Using this formula and excel, I estimated the expected birthrates for the following years: 1978, 2012, and 2050.
1978 = 16.74
2012=12.9188
2050= 8.64
1)Are my forecasts accurate?
2)The 1978 actual result was 15. How much was the residue for this year?
3) How much faith should I put into the 2012 and 2050 predictions?
The table below shows the number of live births per 1000 women aged 15-44 years in the United States, starting in 1965 (National Center for Health Statistics)
| Year | Birthrate |
| 1965 | 19.4 |
| 1970 | 18.4 |
| 1975 | 14.8 |
| 1980 | 15.9 |
| 1985 | 15.6 |
| 1990 | 16.4 |
| 1995 | 14.8 |
| 2000 | 14.4 |
| 2005 | 14.0 |
| 2010 | 13.0 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
