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.)
“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