SPEARMAN

Syntax:

SPEARMAN(array_1, array_2)

Returns the Spearman rank correlation coefficient for the two arrays.

The formula used is:

1 - ( 6·Σi=n di2 ÷ (n·(n2 - 1)) )

where di is each value and n is the number of values.

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