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 Cost (n 12) Ship Cost (Y) 4,489 5,611 3,290 4,113 4,883 5,425 4,414 5,506 3,346 3,673 6,542 5,088 Orders (X) 1,068 1,026 767 885 1,156 1,146 892 938 769 677 1,174 1,009 Click here for the Excel Data File (a) Use Excel, MegaStat, or MINITAB to calculate the correlation coefficient. calc (b)Use Excel or Appendix D to find t 025 for a two-tailed test at a-.Ub to25 t (c) Calculate the t test statistic. tcalc (d) Should we reject the null hypothesis of zero correlation? Yes

Answer 1

S.No (x-x) (у-у) (x-x)(y-y) 1,068.00 4,489.00 5,611.00 3,290.00 4,113.00 4,883.00 5,425.00 4,414.00 5,506.00 3,346.00 3,673.00 6,542.00 5,088.00 56380 4698.3333 11899.1736 4500.1736 36832.0069 5463.6736 38841.8403 35000.1736 4477.8403 437.5069 36068.3403 79477.0069 46260.8403 2508.3403 301766.9167 1 2 1,026.00 767.00 885.00 1,156.00 1,146.00 892.00 938.00 769.00 677.00 1,174.00 1,009.00 11507 958.9167 22834.7778 61224.7222 270282.6389 43265.8889 36394.7222 135947.2222 19026.6389 16893.6944 256830.6389 289058.5556 396541.9722 19515.8056 10929176.6667 1488360.3333 43820.4444 832960.4444 1983402.7778 342615.1111 34101.7778 528044.4444 80845.4444 652325.4444 1828805.4444 1051308.4444 3399106.7778 151840.1111 4 10 12 Total Mean SSY null hypothesis Alternate Hypothesis for 0.05 level,two tailed test and n-1-10 degree of freedom, critical t- Decision rule: 2.2281 reject Ho if absolute value of test statistic lt>2.228 correlation coefficient rS(Vs "Sy - 0.820 test statistic: 4.523

1)rcalc =0.820

2) t =2.228

c)

tcalc =4.530 ( please try 4.523 id this comes wrong)

d)

Yes

a)