Part-Time Weekly Earnings ($) By College Students (A) Make An Excel Scatter Plot. What Does It Suggest ...

(a) Make a   scatter plot of the data. What does it suggest about the correlation between   X and Y? (b) Use Excel, MegaStat, or MINITAB to calculate the correlation   coefficient. (c) Use Excel or Appendix D to find t.05 for a two-tailed test.   (d) Calculate the t test statistic. (e) Calculate the critical value of rα.   (f) Can you reject ρ = 0? Number of Orders and Shipping Cost ($) ShipCost   Orders (X) Ship Cost (Y) 1,068 4,489 1,026 5,611 767 3,290 885 4,113 1,156   4,883 1,146 5,425 892 4,414 938 5,506 769 3,346 677 3,673 1,174 6,542 1,009   5,088    

     Part-Time   Weekly Earnings ($) by College Students (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.05 for   a two-tailed test for zero correlation. (d) Calculate the t test statistic.   Can you reject ? = 0? (e) Use Excel’s function =TDIST(t,deg_freedom,tails) to   calculate the two-tail p-value. Hours Worked X......10, 15, 20, 20, 35 Weekly   Pay Y.........93, 171, 204, 156, 261