MM207 Correlation and Linear Regression Analysis: Examining Relationships in Real-World Data
Analyzes correlation and regression in applied settings.
Hannah Perez
Contributor
4.8
43
3 days ago
Preview (2 of 5)
Sign in to access the full document!
MM207 Unit 8 Chapter 9 Project
ROBYN GALINDO
1
MM207 Correlation and Linear Regression Analysis: Examining
Relationships in Real-World Data
Total points are 40. Points are included with each problem.
Included with each section or problem are reference examples and end of section
exercises that can be used as a guide. Be sure to show your work in case partial
credit is awarded. To receive full credit, work must be shown if applicable.
See the instructions at the end of the project for copying a graph from Excel into a
Word document. The technology manual that was packaged with your book has an
Excel section that can help with the graphing.
Section 9.1 : Correlation
1. Construct a scatter plot using excel for the given data. Determine whether
there is a positive linear correlation, negative linear correlation, or no linear
correlation. Complete the table and find the correlation coefficient r.
(References: example 1 - 4 pages 498 - 500; end of section exercises 15
- 22 pages 508 - 509)
The data below are the number of absences and the final grades of 9
randomly selected students from a statistics class.
Absences, x 4 7 10 8 13 6 19 12 9
Final grade, y 99 87 81 83 72 93 56 77 83
a: Scatter plot (3.5 points)
0
20
40
60
80
100
120
0 5 10 15 20
Absences
Final Grade
b: Type of correlation (positive linear correlation, negative linear
correlation, or no linear correlation) (2.5 points)
Negative linear correlation
ROBYN GALINDO
1
MM207 Correlation and Linear Regression Analysis: Examining
Relationships in Real-World Data
Total points are 40. Points are included with each problem.
Included with each section or problem are reference examples and end of section
exercises that can be used as a guide. Be sure to show your work in case partial
credit is awarded. To receive full credit, work must be shown if applicable.
See the instructions at the end of the project for copying a graph from Excel into a
Word document. The technology manual that was packaged with your book has an
Excel section that can help with the graphing.
Section 9.1 : Correlation
1. Construct a scatter plot using excel for the given data. Determine whether
there is a positive linear correlation, negative linear correlation, or no linear
correlation. Complete the table and find the correlation coefficient r.
(References: example 1 - 4 pages 498 - 500; end of section exercises 15
- 22 pages 508 - 509)
The data below are the number of absences and the final grades of 9
randomly selected students from a statistics class.
Absences, x 4 7 10 8 13 6 19 12 9
Final grade, y 99 87 81 83 72 93 56 77 83
a: Scatter plot (3.5 points)
0
20
40
60
80
100
120
0 5 10 15 20
Absences
Final Grade
b: Type of correlation (positive linear correlation, negative linear
correlation, or no linear correlation) (2.5 points)
Negative linear correlation
Preview Mode
Sign in to access the full document!
100%
Study Now!
XY-Copilot AI
Unlimited Access
Secure Payment
Instant Access
24/7 Support
Document Chat
Document Details
University
Kaplan University School of Business and Management
Subject
Statistics