(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)
a) an Excel scatter plot.
(b) an Excel worksheet to calculate SSxx , SSyy, and SSxy.