Syntax:
Returns the Spearman rank correlation coefficient[1] for the two arrays.
Formula:
rs = 1 − ( 6⋅i ∑1n di2 ∕ (n⋅(n2−1)) )
where n is the number of values and di is the difference between the i‑th rank values.
You can use the output from the RANK() function as input for this function.