What Does Spearmans Rank Tell Us. Mar 29 2021 One solution would be to use Spearmans rank order correlation. Now tell me which is larger yellow or red.
If the data is already ranked you can calculate Spearmans rank by using CORREL or SCORREL. Column in the Ranks table of the Pain_Score for each drug treatment group can be used to compare the effect of the different drug treatmentsWhether these drug treatment groups have different pain scores can be assessed using the Test Statistics table which presents the result of the Kruskal-Wallis H test. Correlation including Spearmans rank correlation is calculated based on pairs of data values.
It does not tell us which treatments differ or what is contributing to the differences.
It is an acceptable method if data are available only in ordinal form or number of paired variable is more than 5 and not greater than 30 with minimum or a few ties in ranks. You will get the same result. For such information we need to run ANOVAs with post hoc tests. If I code yellow 1 and red 2 R would consider red larger than yellow.
