Returns the correlation coefficient between the values in column Value a and in column Value b.
Syntax
CORR(ValueColumn a, ValueColumn b)
Input
ValueColumn a | is a value column |
Domain type: | any Value domain |
ValueColumn b | is another value column |
Domain type: | any Value domain |
Output
CORR returns: | a real value |
Domain: | system domain Value |
Notes:
Tips:
Usable in
TabCalc, TabCalc pocket line calculator
Examples
TabCalc example:
OutCol = CORR(InColA,InColB)
InColA |
InColB |
OutCol |
3 |
9 |
0.919 |
2 |
7 |
0.919 |
? |
6 |
0.919 |
0 |
5 |
0.919 |
4 |
12 |
0.919 |
5 |
15 |
0.919 |
6 |
17 |
0.919 |
7 |
0 |
0.919 |
8 |
? |
0.919 |
TabCalc pocket line calculator example:
? CORR(InColA,InColB) |
returns 0.919 |
See also:
CNT | |||
AVG | |||
STD | Column Statistics | ||
STDEV | COVAR |