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
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
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?](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fff6f9a4d-2084-42ea-abf6-3325fa2ca826%2F4dcf4ffc-4fcc-4652-ba9a-bad6d3b899e6%2Fe1xa53w_processed.png&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Holt Mcdougal Larson Pre-algebra: Student Edition…](https://www.bartleby.com/isbn_cover_images/9780547587776/9780547587776_smallCoverImage.jpg)
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
![Algebra: Structure And Method, Book 1](https://www.bartleby.com/isbn_cover_images/9780395977224/9780395977224_smallCoverImage.gif)
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
![Holt Mcdougal Larson Pre-algebra: Student Edition…](https://www.bartleby.com/isbn_cover_images/9780547587776/9780547587776_smallCoverImage.jpg)
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
![Algebra: Structure And Method, Book 1](https://www.bartleby.com/isbn_cover_images/9780395977224/9780395977224_smallCoverImage.gif)
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