Question: Using the data given in the table below, answer the following questions. (Round your final answers to 3 decimal places.) Order Size and Shipping

Using the data given in the table below, answer the following questions. (Round your final answers to 3 decimal places.) Order Size and Shipping Cost (n = 12) 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 Click here for the Excel Data File (a) Use Excel to calculate the correlation coefficient.. calc (b) Use Excel or Appendix D to find t.025 for a two-tailed test at a = .05. 1.025 (c) Calculate the ttest statistic. calc (d) Should we reject the null hypothesis of zero correlation? O No Yes
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
