Syntax:
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.