Site icon UK Essayz

Scatterplot and Regression

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.Reviewthe instructional video on how to use regression in Microsoft®Excel®.Inputyour data into Microsoft®Excel®(data and years).Createa scatterplot.Inserta 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, watchHow to create scatterplot with trendline in Excel®.In the same Microsoft®Excel®worksheet,answerthe 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?