calculate ranks of series
Posted: Sun Jul 31, 2011 10:37 am
hello!
is there a possibility to calculate the ranks of the items of a series automatically?
for instance, if i have the series:
rs1
+4
+2
-3
-1
+6
-8
and would like to rank the series items' absolute values...
abs(rs1)
+4
+2
+3
+1
+6
+8
according to their size...
rank(abs(rs1))
4
2
3
1
5
6
...how could i possibly do this? thank you for any ideas!
is there a possibility to calculate the ranks of the items of a series automatically?
for instance, if i have the series:
rs1
+4
+2
-3
-1
+6
-8
and would like to rank the series items' absolute values...
abs(rs1)
+4
+2
+3
+1
+6
+8
according to their size...
rank(abs(rs1))
4
2
3
1
5
6
...how could i possibly do this? thank you for any ideas!