The table below gives the US population, in millions, for selected

years.

Year

US Population (in millions)

1960 180.671

1965 194.303

1970 205.052

1975 215.973

1980 227.726

1985 238.466

1990 249.948

1995 263.044

1998 270.561

2000 281.422

2003 294.043

1) Need a scatter plot of the data points, with x equal to the number of years after 1960.

2) Need a best-fit quadratic function that models the data, using the number of years after 1960 as the input x

The best-fit quadratic function is (attach an excel print out):

___________________________________________________________________________________

3) Use the model to estimate the population of US in 2000. Is the estimate close to the actual population?

According to the model, the estimate of US population in 2000 is:

____________________________________________________________________________________

4) Use the model to predict the US population in 2005.

According to the model , the US population in 2005 is:

According to other sites, the answers I have seem to be right. But I don’t know how to work it out on excel.

2) y=0.0146x^2+1.8413x+183.46

3)280.472 mil.

4)295.8835 mil.

 

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"