Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I am working on a systematic review and want to compare the correlation of different devices.
Both Pearson as Spearman correlations are reported in papers. Because they both represent a correlation, is it possible to put them all in one database and compare them? Or is this not possible.
$\begingroup$What do you mean by "putting them all in one database"? What do you want to compare? Is it theoretical differences or some kind of performance comparison?$\endgroup$
$\begingroup$I'm not sure what you're asking exactly, but if you wanted to do a meta-analysis, eg, you wouldn't use Pearson and Spearman interchangeably.$\endgroup$
$\begingroup$It's always useful to point out that the assumptions underlying these metrics differ. Pearson captures linear association while Spearman is a measure of monotonic (ordinal) association. Many other measures of nonlinear, pairwise association are out there including the MIC (mutual information criterion), distance correlations, Brownian correlation, reproducing kernel Hilbert spaces, etc.$\endgroup$
I suggest you read this thread, which sheds an interesting light on differences between both coefficients in rather simple datasets. I guess, that afterwards you will probably decide not to mix them:
Edit: Greenparker is right in his comment, that I should explain here. In the thread I linked, I give an example of a dataset in which Pearson and Spearman differ a lot, as much as one being positive an the other being negative. A shorter example for the purpose of this thread would be the following in R:
As you can see, for the same six simple data points, Spearman is almost zero and negative whilst Pearson is almost 1. I think this should be illustrative enough, not to mix them as "almost the same".
$\begingroup$While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. - From Review$\endgroup$
$\begingroup$@Greenparker You are right. I edited and added a short example that has the same essence as the much longer answer I gave in the other thread. I hope, that for the purpose of this thread, the shorter example is sufficient.$\endgroup$