Corr





This function calculates the coefficient of correlation of a set of number pairs. It uses the following formula: Covar_Pop(Y, X)/(Stddev_Pop(Y) * Stddev_Pop(X)). The pairs where Y or X is NULL are discarded.

Syntax:

Corr(Y, X)

Parameters:

  • Y. Type: Number.
  • X. Type: Number.

Example:

X

Y

1

7

2

1

3

2

4

5

5

7

6

34

7

32

8

43

9

87

SELECT Corr(X, Y) FROM Table

Result:

0.860296149


Comments
0
Add comment