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 2, you will work with the data you collected to analyze the data to draw conclusions.
Review the instructional video on how to use regression in Microsoft® Excel®.
Input your data into Microsoft® Excel® (data and years).
Create a scatterplot.
Insert a linear trendline. 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. If you need help creating your visual, watch How to create scatterplot with trendline in Excel®.
In the same Microsoft® Excel® worksheet, answer the following questions. Each question should be 90 to 175 words.
- Does the line fit the data? How can you tell?
- What does the slope of the line mean in your real-life data? How can you interpret the slope of your line?
- What does the y-intercept mean in your real-life data? How can you interpret the y-intercept?
