College Students Weekly Earnings in Dollars (n = 5)

(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. Check your work by using Excel's function = CORREL (array1,array2).
(c) Use Appendix D to find t.025 for a two-tailed test for zero correlation at α =.05.
(d) Calculate the t test statistic. Can you reject ρ = 0?
(e) Use Excel's function = T.DIST.2T (t,deg_freedom) to calculate the two-tail p-value.

Transcribed Image Text:

Hours Worked (X) Weekly Pay (Y) 10 15 20 20 35 93 204 156 261