My question is as simple as it may be difficult: is there any other nonparametric test besides Spearman's rho to compute the correlation strength between a predictor and an outcome variable of which the first is almost certain to have a skewed distribution?

The reason why I'm asking is that in MySQL, the computer database language that I'm tied to, it is very difficult, if at all possible, to rank my values because of many duplicate values. And to rank 'em manually is not doable either, because there will be between two and six thousand entries.

So I'm actually looking for a nonparametric correlation strength test with an easier ranking method, assuming that ranking is a key principle of all of them.

The reason why I'm asking is that in MySQL, the computer database language that I'm tied to, it is very difficult, if at all possible, to rank my values because of many duplicate values. And to rank 'em manually is not doable either, because there will be between two and six thousand entries.

So I'm actually looking for a nonparametric correlation strength test with an easier ranking method, assuming that ranking is a key principle of all of them.

Last edited: