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
(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.)
![](/static/compass_v2/shared-icons/check-mark.png)
“Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts for you. To get the remaining sub-part solved please repost the complete question and mention the sub-parts to be solved.”
Given:
n = 5
Formula Used:
Step by step
Solved in 6 steps with 4 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![Elementary Statistics: Picturing the World (7th E…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
![Introduction to the Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)