Question: Assignment Content This essay should be 500 word minimum and you must cite your source; this challenge will count more points that usual. Note that

 Assignment Content This essay should be 500 word minimum and you

Assignment Content This essay should be 500 word minimum and you must cite your source; this challenge will count more points that usual. Note that I want you to use the regression feature on MS excel {or equivalent that I MUST be able to view) and attach your excel file to your essays post. When finished wait and reply to a classmate comparing and contrasting their results with your own. This link may be helpful: Mg trend lines in excel Using the Internet, find population statistics for your state for the beginning of every decade from 1950 to 2010. Then use the regression feature on Excel (trend lines} Find a linear regression model for the population, a quadratic regression model, and an exponential regression model. You have to state the equation in the essay. Then use each ofthose models to calculate the current population of your state. Once you do that go and actually look up the population currently. Which of the models gave the best estimate? Based on the graphs we studied in this chapter, explain why the best model did so based on what the graph ofthat type of function tends to look like

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!