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)^2 (yi - y)^2 (xi - x)(yi - y) 13 90 18 181 17 216 22 157 37 276 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 (c) Find t0.025 for a two-tailed test for zero correlation at ? = 0.05. (Round your answer to 3 decimal places.) t0.025 (d-1) Calculate the t test statistic. (Round your answer to 3 decimal places.) tcalc (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

          (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)^2 (yi - y)^2 (xi - x)(yi - y)
13 90
18 181
17 216
22 157
37 276
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

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

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

(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

Show more…

(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)^2 (yi - y)^2 (xi - x)(yi - y)
13 90
18 181
17 216
22 157
37 276
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

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

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

(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

Added by Johnny D.

Elementary Statistics a Step by Step Approach

Allan G. Bluman 9th Edition

Thanks for your feedback!

(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)^2 (yi - y)^2 (xi - x)(yi - y) 13 90 18 181 17 216 22 157 37 276 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 (c) Find t0.025 for a two-tailed test for zero correlation at ̑ = 0.05. (Round your answer to 3 decimal places.) t0.025 (d-1) Calculate the t test statistic. (Round your answer to 3 decimal places.) tcalc (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

Play audio

Feedback

Powered by NumerAI

David Nguyen and 91 other subject Intro Stats / AP Statistics educators are ready to help you.

Ask a new question

Labs

Want to see this concept in action?

NEW

Explore this concept interactively to see how it behaves as you change inputs.

View Labs

Key Concepts

Recommended Videos

Recommended Textbooks

Transcript

00:01 Hi, i'm david and i'm here to help you and send your question.

00:03 In the question here, i want to discuss about the correction coefficient r.

00:07 Here we're given the portion of your question.

00:10 So let me go back to your question and check up the portion of your question.

00:14 And i put the table on the top here.

00:17 So in it to find the r, first of all, we need to fill up the table.

00:22 Now we will need to find the x bar first.

00:25 So we have the 13 plus 18 plus 17 plus 17 plus 20.

00:30 Plus 37 we divide by five of them will equal to the 21 .4 similarly the white part will be 90 plus 181 plus 216 plus 157 plus 276 the 255 equal to the 184 now the next one we need to find the xi minus xpar square so we have the 13 minus minus 21 .4 square can equal to the 70 point 56, 18 minus 21 .4 square equal to the 11 point 56 and 17 minus 21 .4 square equal to the 19 .36 22 minus 21 .4 square equal to the 19 .36.

01:23 22 minus 21 .4 square equal to the 1 36 37 minus 21 .4 square equal to the 243 .36.

01:38 If we end up everything we get equal to plus 19 .36 plus 11 .56 plus 70 .56 plus 70 .56.

01:49 Get equal to the 3455 .2.

01:53 Then y minus y bar square square, we have the 90 minus 184 square, equal to the 886, 181 minus 184 square, equal to 9, to 16 minus 184 square, equal to 102, and 156 minus 184 square, 784 ,000, 2 ,000 ,000 ,000 ,000, 76 minus 184 square a 464 if we end up everything 1 .24 plus 9 plus 886 equal to the 1917 and we will multiply them up so therefore we will have on the top we will have the 13 minus 214 4 times with the 90 minus 184 this one will equal to the 789 .6 the next one will be 18 minus 21 .4 times the 181 minus the 184 equal to the 10 .2 17 minus 21 .4 times the 216 minus 184 equal to the minus 140 .8.

03:34 And the next one will be 22 minus 21 .4 times the 157 minus 184 equal to the minus 16 .2.

03:53 The last one 37 minus 21 .4 times with the 276 minus 184...

Ace is your personal tutor. It breaks down any question with clear steps so you can learn.

Start Using Ace

Continue solving this problem

Create a free account to:

View full step-by-step solution
Ask follow-up questions with Ace AI
Save progress and study later