Assignment
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.
In the same Microsoft Excel worksheet, answer the following questions. Each question should be 90 to 175 words.
1. Does the line fit the data? How can you tell?
2. What does the slope of the line mean in your real-life data? How can you interpret the slope of your line?
3. What does the y-intercept mean in your real-life data? How can you interpret the y-intercept?