Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

# for john mureith only

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?

**Save** and **upload** your Excel® file, including the graphic and your answer to each question.