Spearman's Rank Correlation Coefficient in Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 27 ต.ค. 2024

ความคิดเห็น • 26

  • @greggelliott4570
    @greggelliott4570 9 ปีที่แล้ว +7

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

  • @alvinmaghirang8549
    @alvinmaghirang8549 5 ปีที่แล้ว +1

    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!

  • @johng5295
    @johng5295 4 ปีที่แล้ว

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

  • @laurag.barragan2846
    @laurag.barragan2846 6 ปีที่แล้ว +1

    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
      @agrianalyze 5 ปีที่แล้ว

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

  • @eyelsi6109
    @eyelsi6109 4 ปีที่แล้ว

    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!

  • @nanaosaki995
    @nanaosaki995 6 ปีที่แล้ว +3

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

    • @DrGrande
      @DrGrande  6 ปีที่แล้ว +2

      You are quite welcome!

    • @justin_cgamer3198
      @justin_cgamer3198 5 ปีที่แล้ว +1

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

    • @aviana-xc6km
      @aviana-xc6km 5 ปีที่แล้ว

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

    • @olliechaplin9178
      @olliechaplin9178 4 ปีที่แล้ว

      Ahah me too maths IA

    • @nanaosaki995
      @nanaosaki995 4 ปีที่แล้ว

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

  • @MoonLiteNite
    @MoonLiteNite 2 ปีที่แล้ว

    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

  • @stefaniesmith3307
    @stefaniesmith3307 9 ปีที่แล้ว

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

  • @georgecarter8104
    @georgecarter8104 6 ปีที่แล้ว +3

    Thank you. Very clear and helpful.

    • @DrGrande
      @DrGrande  6 ปีที่แล้ว

      You're welcome!

  • @pranaviramireddy7653
    @pranaviramireddy7653 7 ปีที่แล้ว

    thank you! this was very helpful for my thesis

    • @DrGrande
      @DrGrande  6 ปีที่แล้ว

      You're welcome - thanks for watching -

  • @xiaohe5397
    @xiaohe5397 7 ปีที่แล้ว

    Thanks but do we need to rank exam?

  • @juliafukuda8583
    @juliafukuda8583 6 ปีที่แล้ว +1

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

  • @georgem3197
    @georgem3197 4 ปีที่แล้ว

    Is the r value the same as rho?

  • @kennethvillamin5407
    @kennethvillamin5407 8 ปีที่แล้ว

    what if r>1?