Question

Two sets of observations are given in the following table.

No	Set A - distance (m)	Set B - temperature (C0)
1	125.55	5.2
2	125.54	6.3
3	125.57	8.8
4	125.59	10.0
5	125.58	12.9
6	125.56	16.6
7	125.55	22.2
8	125.62	28.8
9	125.53	20.2
10	125.51	15.5
11	125.53	12.4
12	125.52	9.5

Find the correlation coefficient between set A and set B.      
CORR( X,Y ) = ?   

Answer 1

Here ,We can find the solution with the help of MS -Excel.

Here we get the value i.e CORR(X,Y)= 0.33719 .