How to calculate Spearman's correlation in excel with missing values

[@BjornLaskowski]

Lately, someone who really understood and was able to explain Spearmans Correlation in Excel... PERFECT ! Thank you very much 🙂

[@mifeijoo]

After many teacher finally found you. Thank you

[@jhh2136]

You are my lifesaver! Way better than my professor's explanation!

[@alebigoni]

Thank you, Karina! This was incredibly helpful and really well explained!

[@gustaviookwir7475]

simple and very clear explanations. Thank you

[@ellenscholten6806]

Thank you Karina! I only have one question about the SCORREL-function. When I tried this function, my output showed only the 'rho', not the t-stat and p-value. Do you know how I make Excel show these other values?

[@karinaadcock]

Try selecting three cells first. Then typing the formula. Then press Ctrl + Shift + Enter instead of enter.

[@ellenscholten6806]

@@karinaadcock It worked! Thank you very much!

[@himanshusaxena387]

@@karinaadcock Hello, I tried but this doesn't work for my excel (2010 version). What can I do now?

[@abilitylemur112]

Thank you very much! Lifesaver!

[@ahhuna]

helped a lot, thank you so much

[@ebtesamahmed9113]

Thank you so much, easy and clear.

[@JasonYJS_xoxo]

Even if the values are randomly arranged, does this still work?

[@jezreeldiaz4098]

Mam how do you make the dots go nearer on the line? Thank you.

[@bojiegrezula9213]

How about the tied ranks maam?

[@karinaadcock]

The =RANK() =RANK.EQ() and =RANK.AVG() formulas will do different things with tied values. Google them to find out which one you want.