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) calc 1,048 1,071 025 778 886 1,169 1,160 teale 851 944 744 659 3,553 6,632 5,095 Click here for the Excel Data File (a) Use Excel, MegaStat, or MINITAB to calculate the correlation coefficient. 1,185 1,033 4,463 5,612 (c) Calculate the test statistic. 3,386 4,276 4,786 5,437 4,469 (b) Use Excel or Appendix D to find t,825 for a two-tailed test at a = .05. 5,566 3,304

Holt Mcdougal Larson Pre-algebra: Student Edition 2012
1st Edition
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
ChapterCSR: Contents Of Student Resources
Section: Chapter Questions
Problem 7.29EP
icon
Related questions
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)
Orders (X)
1,048
Ship Cost (Y)
1,871
778
886
calc
1,169
1,160
851
025
944
744
659
5,566
3,304
3,553
6,632
5,095
Click here for the Excel Data File
(a) Use Excel, MegaStat, or MINITAB to calculate the correlation coefficient.
calc
1,185
1,033
(b) Use Excel or Appendix D to find t.825 for a two-tailed test at a = .05.
(c) Calculate the test statistic.
4,463
5,612
3,386
4,276
4,786
5,437
4,469
O No
O Yes
(d) Should we reject the null hypothesis of zero correlation?
Transcribed Image Text: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) 1,048 Ship Cost (Y) 1,871 778 886 calc 1,169 1,160 851 025 944 744 659 5,566 3,304 3,553 6,632 5,095 Click here for the Excel Data File (a) Use Excel, MegaStat, or MINITAB to calculate the correlation coefficient. calc 1,185 1,033 (b) Use Excel or Appendix D to find t.825 for a two-tailed test at a = .05. (c) Calculate the test statistic. 4,463 5,612 3,386 4,276 4,786 5,437 4,469 O No O Yes (d) Should we reject the null hypothesis of zero correlation?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Algebra: Structure And Method, Book 1
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell