question archive Review the instructional video on how to use regression in Microsoft® Excel® (if you have forgotten from Week 2)
Review the instructional video on how to use regression in Microsoft® Excel® (if you have forgotten from Week 2)
Subject:MathPrice: Bought3
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 scatter plot.
Insert a polynomial trendline with degree of 2. 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 linear trendline in a new Microsoft® Excel® worksheet.
Answer the following questions in 175 to 260 words in the same Microsoft® Excel® worksheet as the graph:
1)Which of the trendlines fits the data better? How can you tell?
2)Compare and contrast the shape of the linear regression trendline with the shape of the quadratic.
3)Which do you think will eventually grow faster? Thinking about the type of data you have, do you think your data will grow quickly over time?
- Which (lines or quadratics) has a minimum or maximum value? Thinking about the type of data you have, do you think your data has a minimum or maximum?
Save your Microsoft® Excel® file, including the graphic and your commentary. Make sure you do not delete your files, as you will need them in subsequent weeks. Your assignment will be graded with the Week 3 Grading Guide.
