Task:
(a) Make an Excel scatter plot. What does it suggest about the population correlation between X and Y?
(b) Make an Excel worksheet to calculate SSxx , SSyy, and SSxy.
Use these sums to calculate the sample correlation coefficient.
(Use table below to solve regression)
Part-Time Weekly Earnings ($) by College Students
Hours Worked (X) Weekly Pay (Y)
10 93
15 171
20 204
20 156
35 261