Used this method to calculate spearman rank correlation step by step, create an example

Another option is simply to use the full version of Spearman's formula (actually a slightly modified Pearson's r), which will deal with tied ranks: R(x;) - R(x)) .(R(y;) - R(y) Sxy i=1 P = SSy (R(X) - R(X))) . ( R(X) - R()) Full Spearman's r formula (Clef, 2013. p. 4) Where: . R(x) and R(y) are the ranks, . R(x)bar and R(y)bar are the mean ranks