PartTime 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 twotailed 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
PartTime 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 twotailed 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 twotail pvalue. Hours Worked X......10, 15, 20, 20, 35 Weekly Pay Y.........93, 171, 204, 156, 261

Rating:
5/