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.

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!