Scatterplot and Regression, Signature Assignment help
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.
Your assignment will be graded with the Week 2 Signature Assignment Grading Guide.
Week 2: Grading Guide for Signature Assingment: Scatterplot and Regression
Content (70%) |
Points Earned: |
All key elements of the assignment are covered in a substantive way. Major points are stated clearly and are supported by specific details, examples, or analysis. Scatterplot and trendline are present on graphic. |
Comments: |
Mechanics (30%) |
Points Earned: |
The paper, including tables and graphs, is consistent with APA formatting guidelines and meets course-level requirements. Intellectual property is recognized with in-text citations and a reference page. Rules of spelling, grammar usage, and punctuation are followed. Sentences are complete, clear, concise, and varied. |
Comments: |