(a) Calculate SSxx, SSyy, and SSxy. (Leave no cells blank - be certain to enter "0" wherever req

First, we need to calculate SSxx, SSyy, and SSxy. These are the sum of squares for x, y, and the

Question

(a) Calculate SSxx, SSyy, and SSxy. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 2 decimal places.) Click here for the Excel Data File College Student Weekly Earnings in Dollars (n = 5) Hours Worked (X) Weekly Pay (Y) (xi - x?) (yi - y?) (xi - x?)(yi - y?) 9 103 96.04 6400 784 15 174 14.44 81 34.2 19 209 0.04 676 5.2 16 152 7.84 961 86.8 35 277 262.44 8836 1522.8 18.8 183 380.8 16954 2433 x? y? SSXX SSYY SSXY (b) Calculate the sample correlation coefficient. Check your work by using Excel's function =CORREL(array1,array2). (Round your answer to 4 decimal places.) r 0.9575 (c) Find t0.025 for a two-tailed test for zero correlation at ? = 0.05. (Round your answer to 3 decimal places.) t0.025 3.182 (d-1) Calculate the t test statistic. (Round your answer to 3 decimal places.) tcalc 5.750 (d-2) Should we reject the null hypothesis of zero correlation? No Yes (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.) p-value 0.0716

          (a) Calculate SSxx, SSyy, and SSxy. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 2 decimal places.)

Click here for the Excel Data File

College Student Weekly Earnings in Dollars (n = 5)
Hours Worked (X) Weekly Pay (Y) (xi - x?) (yi - y?) (xi - x?)(yi - y?)
9 103 96.04 6400 784
15 174 14.44 81 34.2
19 209 0.04 676 5.2
16 152 7.84 961 86.8
35 277 262.44 8836 1522.8

18.8 183 380.8 16954 2433
x? y? SSXX SSYY SSXY

(b) Calculate the sample correlation coefficient. Check your work by using Excel's function =CORREL(array1,array2). (Round your answer to 4 decimal places.)
r 0.9575

(c) Find t0.025 for a two-tailed test for zero correlation at ? = 0.05. (Round your answer to 3 decimal places.)
t0.025  3.182

(d-1) Calculate the t test statistic. (Round your answer to 3 decimal places.)
tcalc 5.750

(d-2) Should we reject the null hypothesis of zero correlation?
No
Yes

(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.)
p-value 0.0716

(a) Calculate SSxx, SSyy, and SSxy. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 2 decimal places.)

Click here for the Excel Data File

College Student Weekly Earnings in Dollars (n = 5)
Hours Worked (X) Weekly Pay (Y) (xi - x?) (yi - y?) (xi - x?)(yi - y?)
9 103 96.04 6400 784
15 174 14.44 81 34.2
19 209 0.04 676 5.2
16 152 7.84 961 86.8
35 277 262.44 8836 1522.8

18.8 183 380.8 16954 2433
x? y? SSXX SSYY SSXY

(b) Calculate the sample correlation coefficient. Check your work by using Excel's function =CORREL(array1,array2). (Round your answer to 4 decimal places.)
r 0.9575

(c) Find t0.025 for a two-tailed test for zero correlation at ? = 0.05. (Round your answer to 3 decimal places.)
t0.025 3.182

(d-1) Calculate the t test statistic. (Round your answer to 3 decimal places.)
tcalc 5.750

(d-2) Should we reject the null hypothesis of zero correlation?
No
Yes

(e) Use Excel's function =T.DIST.2T(t,degfreedom) to calculate the two-tail p-value. (Round your answer to 4 decimal places.)
p-value 0.0716

Added by Nathaniel B.

Question

Please give Ace some feedback