Question
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
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 (attachan excelprint out):
___________________________________________________________________________________
3) Use the model to estimate the population of US in 2000. Is the estimate close to the actual population?
Accordingto themodel, the estimate of US population in 2000 is:
____________________________________________________________________________________
4) Use the model to predict the USpopulation in2005.
Accordingto themodel , 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started