Question

Here is a bivariate data set. x y 56.5 70 63.2 34.5 75.3 20.2 69.4 22...

Here is a bivariate data set.

x y
56.5 70
63.2 34.5
75.3 20.2
69.4 22
33.7 141
44.5 112.3
52.2 81.6
58.6 58.2
58.2 57.6
66.9 40.6
68.8 37.5



Find the correlation coefficient and report it accurate to three decimal places.
r =

What proportion of the variation in y can be explained by the variation in the values of x? Report answer as a percentage accurate to one decimal place.
r² = %

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Here'the answer to the question. Please don't hesitate to give a "thumbs up" in case you're satisfied with the answer

We have the =CORREL formula in Excel to take out the r or the correlation

Rsquare/r^2 is basically the square of the correlation.

Values of correlation (r) and R-square(r^2) are in red.

Correlation -0.983 Use the formula -CORREL(L5:L15,M5:M15)) to get the answer This is just the square of correlation 70 34.5 20.2 56.5 63.2 75.3 69.4 33.7 44.5 52.2 58.6 58.2 66.9 68.8 96.7% 141 112.3 81.6 58.2 57.6 40.6 37.5

Add a comment
Know the answer?
Add Answer to:
Here is a bivariate data set. x y 56.5 70 63.2 34.5 75.3 20.2 69.4 22...
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