TableOfReal: To Correlation (rank)

A command that creates a (Spearman rank-order) Correlation object from every selected TableOfReal object. The correlations are calculated between columns.

Algorithm

The Spearman rank-order correlation coefficient rij between the elements of columns i and j is calculated as the linear correlation of the ranks:

rij = Σk (Rki - Rmeani) (Rkj - Rmeanj) / (√ (Σk(Rki - Rmeani)2) √ (Σk(Rkj - Rmeanj)2)),

where Rmn is the rank of element m in column n, and Rmeann is the mean of the ranks in column n.


© djmw, January 5, 2002