Question

You go out and collect data from 6 people and question them as to how honest they are and how satisfied they are with their friendships. These are the data that you find:

Subject #	Honesty	Satisfaction
1	5	9
2	3	2
3	7	10
4	2	6
5	4	4
6	6	7

(a) Compute the correlation coefficient ‘r’ describing the relationship between honesty and friendship.(5---pts)

Answer 1

We can directly calculate correlation coefficient by using Excel.

Step 1)  Enter data in Excel.

Step 2 )  Then use =CORREL command and select two separate column data  >> ok

Therefore, correlation coefficient = r= 0.710

=0.710