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 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
Get step-by-step solutions from verified subject matter experts
