Results 1 to 8 of 8

Math Help - Spearmans rank multiple ranks

  1. #1
    Newbie
    Joined
    Nov 2006
    Posts
    17

    Spearmans rank multiple ranks

    I have my data ready for ranking, my only quuestion is when it comes
    to ranking a number that has more than one what will i rank it.

    E.g I have one number 1 in my data so this gets ranked as one

    but i have 5 number 2's in my data so would this be ranked as 2.2
    since there is 5 of them and 2.2 would be the average (1/5=.2)

    or would it 2.5 for each of them
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Super Member
    earboth's Avatar
    Joined
    Jan 2006
    From
    Germany
    Posts
    5,807
    Thanks
    116
    Quote Originally Posted by dtwazere View Post
    I have my data ready for ranking, my only quuestion is when it comes
    to ranking a number that has more than one what will i rank it.
    ...
    Hello,

    you have:
    rank value
    1 → 1
    2 → 2
    3 → 2
    4 → 2
    5 → 2
    6 → 2
    7 → 3.6
    ... → ...
    then you calculate the rank as the average of all similar ranks. In this case all 2's will get the rank r=\frac{2+3+4+5+6}{5}=4

    Now you have:
    1 → 1
    4 → 2
    4 → 2
    4 → 2
    4 → 2
    4 → 2
    7 → 3.6
    ... → ...

    EB
    Last edited by earboth; November 24th 2006 at 10:37 AM.
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Newbie
    Joined
    Nov 2006
    Posts
    17
    Hi, thanks for the response, this has caused me more confusion, would it be possible for you to rank my data for me as i am really stuck at this point! I can do the rest of the equation myself.

    I would really appreciate this
    Attached Files Attached Files
    Follow Math Help Forum on Facebook and Google+

  4. #4
    Super Member
    earboth's Avatar
    Joined
    Jan 2006
    From
    Germany
    Posts
    5,807
    Thanks
    116
    Quote Originally Posted by dtwazere View Post
    Hi, thanks for the response, this has caused me more confusion, would it be possible for you to rank my data for me as i am really stuck at this point! I can do the rest of the equation myself.
    I would really appreciate this
    Hello,

    ...would it be possible for you to rank my data for me as i am really stuck at this point!
    of course.

    I've attached your modified file so you can see what I've done with your data:

    1. I copied the time data into the column t' in sorted order.
    2. In the column r' are listed all possible ranks in increasing order.
    3. In the column r'' are listed the ranks so that equal data get equal ranks. (Notice: In German the comma is the same as the decimal point in English)
    4. Now you have a one to one function between data and rank and you can accomplish your original list.

    Remark: Of course it looks a little bit screwy to have a rank 11.5. But that doesn't matter for your calculations.

    EB
    Attached Files Attached Files
    Follow Math Help Forum on Facebook and Google+

  5. #5
    Super Member
    earboth's Avatar
    Joined
    Jan 2006
    From
    Germany
    Posts
    5,807
    Thanks
    116
    Quote Originally Posted by dtwazere View Post
    Hi, thanks for the response, this has caused me more confusion, would it be possible for you to rank my data for me as i am really stuck at this point! I can do the rest of the equation myself.
    Hello,

    in the attachment you'll find the completed table.

    As you may know you can calculate the ranks by using "average(range with absolute adresses!)". For the one-to-one function you can use a command something like "vertical reference" (I'm sorry I only know the commands in German which are not very helpful for you, I belöieve)

    EB
    Attached Files Attached Files
    Follow Math Help Forum on Facebook and Google+

  6. #6
    Newbie
    Joined
    Nov 2006
    Posts
    17
    Thank you all for your help. I will now do my spearmans ranking.



    You guys are cool

    Would it be possible for you to check my spearmans rank if i upload it as an attachment to see if i got it correct?

    If it is not too much trouble.

    Thanks, Daniel
    Last edited by dtwazere; November 25th 2006 at 02:47 AM.
    Follow Math Help Forum on Facebook and Google+

  7. #7
    Super Member
    earboth's Avatar
    Joined
    Jan 2006
    From
    Germany
    Posts
    5,807
    Thanks
    116
    Quote Originally Posted by dtwazere View Post
    Thank you all for your help. I will now do my spearmans ranking.
    You guys are cool
    Would it be possible for you to check my spearmans rank if i upload it as an attachment to see if i got it correct?
    If it is not too much trouble.
    Thanks, Daniel
    Hello, Daniel,

    obviously you used r_S=1-\frac{6\cdot \sum\left(D^2\right)}{n(n^2-1)} . So everything is fine and correct.
    Congratulations!

    By the way: If I were you I would write somewhere on the spread-sheet which formula you have used. Otherwise you'll not understand your own homework two weeks later.

    EB
    Follow Math Help Forum on Facebook and Google+

  8. #8
    Newbie
    Joined
    Nov 2006
    Posts
    17
    thanks a lot for all your help, i will attempt to do this for my other set of data. If i get confused ill post it here.

    Thanks again!
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Spearmans Rank Help
    Posted in the Statistics Forum
    Replies: 3
    Last Post: March 18th 2011, 08:00 AM
  2. Rank, and Row Multiple Examples
    Posted in the Advanced Algebra Forum
    Replies: 3
    Last Post: February 20th 2011, 11:23 AM
  3. spearmans rank
    Posted in the Statistics Forum
    Replies: 1
    Last Post: April 2nd 2008, 05:30 AM
  4. Spearmans Rank
    Posted in the Statistics Forum
    Replies: 1
    Last Post: April 1st 2008, 12:12 PM
  5. Spearmans Rank question
    Posted in the Advanced Statistics Forum
    Replies: 4
    Last Post: June 17th 2007, 10:34 AM

Search Tags


/mathhelpforum @mathhelpforum