In: Statistics and Probability
Based on your scatter diagram, is there a relationship between
the variables? If yes, describe the relationship.
-Does it appear to be positive or negative? Strong or weak or
moderate?
-What would your guess of r, the correlation coefficient, be?
We will describe the relationship from scatter diagram and its direction.
For example:
1. Bring data in to excel sheet
2.Select both x and y variable and insert scatter plot chart. Select any data point in the excel and add trend line.
Does it appear to be positive or negative? Strong or weak or moderate?
It appears to be a positive and it looks like Strong positive
What would your guess of r, the correlation coefficient, be?
we can use "=CORREL(Array 1, Array 2) " formula in excel to find the r value
correlation coefficeint r = 0.70. as we mentioned the strength from 0.70 to 1.00 is strong positive correlation