SPEARMAN

Syntax:

SPEARMAN( array_1, array_2 )

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.

  1. Weisstein, Eric W. "Spearman Rank Correlation Coefficient."
    From MathWorld--A Wolfram Web Resource. https://mathworld.wolfram.com/SpearmanRankCorrelationCoefficient.html