SPEARMAN

Syntax:

SPEARMAN(array_1, array_2)

Returns the Spearman rank correlation coefficient for the two arrays.

Formula:

rs = 1 − ( 6⋅i=n di2 ÷ (n⋅(n2−1)) )

where n is the number of values and xi is the i-th value.

You can use the output from the RANK function as input for this function.