Part-Time Weekly Earnings ($) By College Students (a) Make An Excel Scatter Plot. What Does It Suggest … – Instant Assignment Help | assignmentsonline.org
Mathematics – Instant Assignment Help | assignmentsonline.org
(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
Assignmentsonline.org is here to take care of your concerns. We assure you that you will be getting 100% results right according to the promises we make. Our resources and our process are adequate promises to make sure that we will provide you with the best essays, assignments, and thesis/ dissertation. Place your order now and get a special lifeline including assignments. Essays and thesis/ dissertation.