Question

Based on the data shown below, calculate the correlation coefficient (to three decimal places) x y...

Based on the data shown below, calculate the correlation coefficient (to three decimal places)

x y
5 13.95
6 15.44
7 17.93
8 17.12
9 16.91
10 18.7
11 20.09
12 18.68
13 21.27
14 20.26
15 21.35
16 20.74
17 23.23
18 23.62
19 20.71
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Clipboard Font Alignment Number Cells Editing D2 f CORREL(A2:A16,B2:B16) correlation coefficient 5 13.95 15.44 0.906618591 Steps to calculate Correlation Coefficient Step 1: Type your data into two columns in Excel. For example, type your xdata into column A and your y data into column E 7 17.93 8 17.12 9 16.91 Step 2 Select any empty cell Step 3: Click the function button on the ribbon Step 4: Type correlation into the Search for a function box Step 5: Click Go. CORREL will be highlighted. Step 6: Click OK. Step 7: Type the location of your data into the Array 1 and Array 2 boxes. For this example, type A2 A16 into the Array 1 box and then type B2 B16 into the Array 2 box. Step 8: Click OK. The result will appear in the cell you selected in Step 2. For this particular data set, the correlation coefficient(r) is 0.9066 18.7 11 20.09 12 18.68 10 13 21.27 14 15 21.35 16 20.74 17 23.23 18 23.62 19 20.71 20.26 12 13 14 15 16 17 18

Correlation Coefficient for the above data is 0.90661 which is rounded to 0.907(for 3 decimal places).

Note: I hope this would help you, but if you still have any doubt or need clarification, let me know via comments.

Add a comment
Know the answer?
Add Answer to:
Based on the data shown below, calculate the correlation coefficient (to three decimal places) x y...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT