Question

Find the Pearson Correlation for the following data. X Y 1 3 1 2 2 4 2 5 3 5 3 6

Answer 1

Solution :

X	Y	XY	X^2	Y^2
1	3	3	1	9
1	2	2	1	4
2	4	8	4	16
2	5	10	4	25
3	5	15	9	25
3	6	18	9	36

n	6
sum(XY)	56.00
sum(X)	12.00
sum(Y)	25.00
sum(X^2)	28.00
sum(Y^2)	115.00
Numerator	36.00
Denominator	39.50
r	0.9115
r square	0.8308
Xbar(mean)	2.0000
Ybar(mean)	4.1667
SD(X)	0.8165
SD(Y)	1.3437
b	1.5000
a	1.1667

Pearson Correlation = r = 0.9115