Lately, someone who really understood and was able to explain Spearmans Correlation in Excel... PERFECT ! Thank you very much 🙂
@mifeijoo4 ай бұрын
After many teacher finally found you. Thank you
@jhh21363 жыл бұрын
You are my lifesaver! Way better than my professor's explanation!
@alebigoni5 жыл бұрын
Thank you, Karina! This was incredibly helpful and really well explained!
@gustaviookwir74755 жыл бұрын
simple and very clear explanations. Thank you
@ebtesamahmed91135 жыл бұрын
Thank you so much, easy and clear.
@ellenscholten68064 жыл бұрын
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?
@karinaadcock4 жыл бұрын
Try selecting three cells first. Then typing the formula. Then press Ctrl + Shift + Enter instead of enter.
@ellenscholten68064 жыл бұрын
@@karinaadcock It worked! Thank you very much!
@himanshusaxena3874 жыл бұрын
@@karinaadcock Hello, I tried but this doesn't work for my excel (2010 version). What can I do now?
@ahhuna4 жыл бұрын
helped a lot, thank you so much
@abilitylemur1125 жыл бұрын
Thank you very much! Lifesaver!
@JasonYJS_xoxo7 ай бұрын
Even if the values are randomly arranged, does this still work?
@jezreeldiaz40984 жыл бұрын
Mam how do you make the dots go nearer on the line? Thank you.
@bojiegrezula92135 жыл бұрын
How about the tied ranks maam?
@karinaadcock5 жыл бұрын
The =RANK() =RANK.EQ() and =RANK.AVG() formulas will do different things with tied values. Google them to find out which one you want.