APA format is required. References should be listed immediately after the question that is being answered. Each question lists a minimum number of unique scholarly references; the textbook is considered one unique….
Compare and contrast the polynomial regression with the linear regression from Week 2. What is the best model for your data so far?
****PLEASE DO NOT PLAGIARIZE
****FOLLOW INSTRUCTIONS CAREFULLY
The purpose of the Signature Assignment is to have you work with real-life data to answer a real-life question using the tools, technology, and skills of MTH/219. In Week 3, you will determine the type of polynomial your data is best represented. You will use that polynomial to make a prediction about your data.
Review the instructional video on how to use regression in Microsoft® Excel® (if you have forgotten from Week 2).
Input your data into Microsoft® Excel® (data and years).
Create a scatterplot.
Insert a polynomial trendline with degree of 4. Make sure to show the equation and the R-square value. Also make sure you label each axis and give a title to your graph. Then repeat this process for a 5th degree polynomial.
Answer the following questions in the same Microsoft® Excel® worksheet. Each question should be 175 to 260 words.
- Which of the polynomials fit the data better? How can you tell?
- Compare and contrast the polynomial regression with the linear regression from Week 2. What is the best model for your data so far?
- What happens to your polynomial models over time? In other words, what do you expect to happen to the value if you measure it 50 years from now?
Save your Microsoft® Excel® file, including the graphic and your commentary.
Your assignment will be graded with the Week 3 Signature Assignment Grading Guide.
Click the Assignment Files tab to submit your assignment.