Spearman's Rank Correlation Coefficient in Excel

This video demonstrates how to use calculate Spearman’s Rank Correlation Coefficient (Spearman’s rho) in Excel. Spearman’s rho is used to evaluate the association between rank-ordered variables and is a non-parametric alternative to Pearson’s r.

[@greggelliott4570]

Appreciated hearing the difference in assumptions between the Pearson r and the Spearman's rho.

[@alvinmaghirang8549]

Though the audio of your video is very low, it is really easy to understand. This helped me a lot with my manuscript. Thank you!

[@MoonLiteNite]

My mind exploded....
I was watching a video on excel, then left it on auto play and not really paying attention, then out of no place, i hear dr grande's voice... haha i died

[@johng5295]

Thanks in a million. Awesome. Very well explained. Where have you been all these years.A+

[@georgecarter8104]

Thank you. Very clear and helpful.

[@DrGrande]

You're welcome!

[@pranaviramireddy7653]

thank you! this was very helpful for my thesis

[@DrGrande]

You're welcome - thanks for watching -

[@nanaosaki995]

Thank you so so much!! This really helped me with my math internal assessment.

[@DrGrande]

You are quite welcome!

[@justin_cgamer3198]

I’m using this for my Biology IA too! Thanks so much!

[@aviana-xc6km]

literally everybody watching this is doing so for their IAs... mine is for biology

[@olliechaplin9178]

Ahah me too maths IA

[@nanaosaki995]

@@olliechaplin9178 wow 2 years have passed and your comment just brought me back to this haha

[@stefaniesmith3307]

Is the process for calculating SRCC the same for an instance in which there are tied ranks once you have corrected for the ties?

[@laurag.barragan2846]

Your video is very clear, I appreciate it very much. Just a question Dr. Grande. I got my data from a survey in a likert scale. How can I use that into useful data here? I mean you show X and Y as a final test score and the GPA score, but I have answers with 1=never, 2=monthly, etc. I know that for Likert scale the mean is not representative as a central tendency measurement since there is not such as thing as monthly and a half, so I read I can use the median instead. Is the median the value of X and Y that I can use in this case to run the Spearman´s Rho? Thanks so much in advance for any kind of help you can give me.

[@agrianalyze]

You can check for biserial correlation if one variable is artificially dichotomous variable (X) and another is true continuous variable (Y)

[@eyelsi6109]

Hi, Dr. Todd!
I want to perform Concurrent Validity and Test-Retest Method.
May I use the same set of scores I used in Concurrent for the Test-Retest Method?
Thank you so much in advance!

[@xiaohe5397]

Thanks but do we need to rank exam?

[@kennethvillamin5407]

what if r>1?

[@juliafukuda8583]

What happened to the 6? Isn’t it 1-6*sumd^2(n^3-n)

[@christopherlawes6081]

It was in the numerator cell

[@georgem3197]

Is the r value the same as rho?

[@oopz7315]

Yes