# Thread:

1. ## 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

2. Originally Posted by dtwazere
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

3. 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
• Book2.xls (18.5 KB, 44 views)

4. Originally Posted by dtwazere
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
• Book2_exmpl1.xls (69.5 KB, 45 views)

5. Originally Posted by dtwazere
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
• Book2_compl.xls (79.5 KB, 51 views)

6. 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
Attached Files
• 1303d1164451142-spearmans-rank-multiple-ranks-book2_compl.xls (26.0 KB, 40 views)

7. Originally Posted by dtwazere
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

8. 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!
{"extraction_info": {"found_math": true, "script_math_tex": 0, "script_math_asciimath": 0, "math_annotations": 0, "math_alttext": 0, "mathml": 0, "mathjax_tag": 0, "mathjax_inline_tex": 0, "mathjax_display_tex": 0, "mathjax_asciimath": 0, "img_math": 0, "codecogs_latex": 2, "wp_latex": 0, "mimetex.cgi": 0, "/images/math/codecogs": 0, "mathtex.cgi": 0}, "config": {"markdown_headings": true, "markdown_code": true, "boilerplate_config": {"ratio_threshold": 0.18, "absolute_threshold": 10, "end_threshold": 15, "enable": true}, "remove_buttons": true, "remove_image_figures": true, "remove_link_clusters": true, "table_config": {"min_rows": 2, "min_cols": 3, "format": "github"}, "remove_chinese": true, "remove_edit_buttons": true, "extract_latex": true}, "english_confidence": 0.9394014477729797, "perplexity_flag": "middle"}