I am applying Spearman correlation test on two different variables. I'm getting results of p-value and rho as follows:
Case p-value rho 1 0.0004077509 0.6129457645 2 0.0059893012 0.4978762712 3 0.0091239476 -0.1592959273 4 0.1368309165 0.7281007785 5 2.22722438947104E-08 0.7456261445
I have confusion about interpreting these results. Is it correct to say that, in the first case, there is a statistically significant and strong correlation between the two sets since the p-value < 0.05 and rho is high? It's confusing how I can relate the p-value and rho when interpreting the relation?
My understanding so far is that when the p-value < 0.05 and rho is higher (i.e., > 0.6) that means the correlation between the two variables is strong and positive. If my understanding is true, what about other cases such as the third case? I couldn't really find a proper interpretation for such a case. Can you please clarify that to me? BTW, I provided the 5 cases that confused me.