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

Question # 00801517 Posted By: Dennis80 Updated on: 04/08/2021 11:07 AM Due on: 04/20/2021
Subject Mathematics Topic General Mathematics Tutorials:
Question

(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

Click chat on right side to get answer.