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

In this video I show you how to calculate the spearman's rank correlation in excel and how to calculate it when you have blank cells.
Free excel add-in for SCORREL formula: www.real-statistics.com/free-d...
---------------------------------------------------------------------------------
#Excel #exceltutorial #excelformulas
SUBSCRIBE: goo.gl/c46YPs
Microsoft Office 365, 2016, Office Insider, Version 1901
---------------------------------------------------------------------------------
RECENT VIDEOS:
- Geography data types and filled maps in excel • Geography data types a...
- How to make a lookup for pictures in excel • How to make a lookup f...
- How to make dynamic charts in excel • How to make dynamic ch...

[@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

[@ebtesamahmed9113]

Thank you so much, easy and clear.

[@abilitylemur112]

Thank you very much! Lifesaver!

[@ahhuna]

helped a lot, thank you so much

[@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.

[@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?

[@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.