Compute the sample covariance for the above data. Does this mean there is a posi
ID: 3158291 • Letter: C
Question
Compute the sample covariance for the above data.
Does this mean there is a positive or negative relationship between x and y?
Explanation / Answer
Using Excel we have
The covariance is computted as =COVARIANCE.S(A2:A9,B2:B9)
The covariance is -27.607
Standard deviation of x [=STDEV.S(B2:B9)] is 8.031
Standard deviation of y [=STDEV.S(A2:A9)] is 13.866
The correlation coefficient is [=CORREL(A2:A9,B2:B9)] is -0.248
There is a weak relationship
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.