College Students' Part-Time Weekly Earnings (n = 5) Hours Worked (X) Weekly Pay (Y) 9 103 15 174 19 209 16 152 35 277 a) Calculate SSxx, SSyy, and SSxy. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 2 decimal places.) (b) Calculate the sample correlation coefficient. Check your work by using Excel's function =CORREL(array1, array2). (Round your answer to 4 decimal places.) (c) Find t.025 for a two-tailed test for zero correlation at α=0.05α=0.05 . (Round your answer to 3 decimal places.)
College Students' Part-Time Weekly Earnings (n = 5) Hours Worked (X) Weekly Pay (Y) 9 103 15 174 19 209 16 152 35 277 a) Calculate SSxx, SSyy, and SSxy. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 2 decimal places.) (b) Calculate the sample correlation coefficient. Check your work by using Excel's function =CORREL(array1, array2). (Round your answer to 4 decimal places.) (c) Find t.025 for a two-tailed test for zero correlation at α=0.05α=0.05 . (Round your answer to 3 decimal places.)
Calculus For The Life Sciences
2nd Edition
ISBN:9780321964038
Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Chapter7: Integration
Section7.CR: Chapter 7 Review
Problem 88CR
Related questions
Question
| College Students' Part-Time Weekly Earnings (n = 5) | ||
| Hours Worked (X) | Weekly Pay (Y) | |
| 9 | 103 | |
| 15 | 174 | |
| 19 | 209 | |
| 16 | 152 | |
| 35 | 277 |
|
a) Calculate SSxx, SSyy, and SSxy. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 2 decimal places.)
(b) Calculate the sample
(c) Find t.025 for a two-tailed test for
(d-1) Calculate the t test statistic. (Round your answer to 3 decimal places.)
(d-2) Should we reject the null hypothesis of zero correlation?
(e) Use Excel's function =T.DIST.2T(t,deg_freedom) to calculate the two-tail p-value. (Round your answer to 4 decimal places.)
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 6 steps with 4 images
Recommended textbooks for you
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:
9781305071742
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL