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
Hello,
of course....would it be possible for you to rank my data for me as i am really stuck at this point!
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
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
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