Question

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.


$1.99
Sales0
Views34
Comments0
  • CreatedAugust 19, 2015
  • Files Included
Post your question
5000