Question Description
EXCEL..
QUESTION 1
Discuss GDP. What is it? What does it mean for a country? Why do different countries have a different GDP?
QUESTION 2
Which country did you choose?
QUESTION 3
Draw a scatter diagram of the data with years 1991 through 2010 as the
independent variable and GDP per Capita (US$) as the dependent
variable using Excel or a graphing calculator. Attach the file here.
QUESTION 4
Determine the linear function of best fit. Graph the linear function of
best fit on the scatter diagram. Attach the file here that shows your linear
function of best fit displayed on the scatter diagram.
Attach File
QUESTION 5
Using Excel or a graphing calculator, determine the quadratic function of
best fit. Graph the quadratic function of best fit on the scatter diagram.
Attach the file here.
Attach File
QUESTION 6
Using Excel or a graphing calculator, determine the exponential function
of best fit. Graph the exponential function of best fit on the scatter
diagram. Attach the file here.
Attach File
QUESTION 7
Is the linear model the best fit? Why or why not?
Is the quadratic model the best fit? Why or why not?
Is the exponential model the best fit? Why or why not?
Analyze and discuss which function (linear, quadratic, or exponential) best fits your data. Give details for each
model:
QUESTION 8
Discuss what your results mean for the future of the country you chose?
EXCEL..QUESTION 1Discuss GDP. What is it? What does it mean for a country? Why do different countries have a different GDP?QUESTION 2Which country did you choose?QUESTION 3Draw a scatter diagram of the data with years 1991 through 2010 as theindependent variable and GDP per Capita (US$) as the dependentvariable using Excel or a graphing calculator. Attach the file here.QUESTION 4Determine the linear function of best fit. Graph the linear function ofbest fit on the scatter diagram. Attach the file here that shows your linearfunction of best fit displayed on the scatter diagram.Attach FileQUESTION 5Using Excel or a graphing calculator, determine the quadratic function ofbest fit. Graph the quadratic function of best fit on the scatter diagram.Attach the file here.Attach FileQUESTION 6Using Excel or a graphing calculator, determine the exponential functionof best fit. Graph the exponential function of best fit on the scatterdiagram. Attach the file here.Attach FileQUESTION 7Is the linear model the best fit? Why or why not?Is the quadratic model the best fit? Why or why not?Is the exponential model the best fit? Why or why not?Analyze and discuss which function (linear, quadratic, or exponential) best fits your data. Give details for eachmodel:QUESTION 8Discuss what your results mean for the future of the country you chose?
