Question 261442: Question:
Construct a scatter plot using excel for the given data. Determine whether there is a positive linear correlation, negative linear correlation, or no linear correlation. Complete the table and find the correlation coefficient r.
x 3 5 2 8 2 4 4 5 6 3
y 65 80 60 88 66 78 85 90 90 71
Answer: 10 (340)-(42)(773)/square root 10(208)-42*42 square root 10(60,875)-773*773=-290.6/square root 3.16 square root 1.12=-1.585
This is what I have come up with
For the type of correlation is: negative linear correlation
Answer by stanbon(75887)   (Show Source):
You can put this solution on YOUR website! Construct a scatter plot using excel for the given data. Determine whether there is a positive linear correlation, negative linear correlation, or no linear correlation. Complete the table and find the correlation coefficient r.
x 3 5 2 8 2 4 4 5 6 3
y 65 80 60 88 66 78 85 90 90 71
Answer: 10 (340)-(42)(773)/square root 10(208)-42*42 square root 10(60,875)-773*773=-290.6/square root 3.16 square root 1.12=-1.585
This is what I have come up with
For the type of correlation is: negative linear correlation
--------------------------------------------------------------
I used a Linear Regression program on a TI calculator and got the following:
y = 5.044x + 56.11
r = 0.8465...
Correlation: positive linear correlation because 5.044 is positive.
====================================================================
Cheers,
Stan H.
|
|
|
