CORREL : General Usage
1
data_1
data_2
2
2
4
3
5
3
4
7
6
5
1
1
6
8
5
7
8
9
Correlation Coefficient
Formula
10
0.7927032095
=CORREL(A2:A6,B2:B6)
11
-1
=CORREL({2,0}, {-1,6})
12