Order Size and Shipping Cost (n = 12)

(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.025 for a two-tailed test at α =.05.
(d) Calculate the t test statistic.
(e) Can you reject ρ = 0?

Orders (X) Ship Cost (Y) 1,068 1,026 767 885 1,156 1,146 892 938 769 4,489 5,611 3,290 4,113 4,883 5.425 4,414 5,506 3,346 3,673 6,542 5,088 1,174 1,009