Manuals/calci/RANKS

RANKS(r,n,o)

• $r$ is the set of numbers.
• $n$ is the number to get ranked.
• $o$ is the number to start.

Description

• This function gives the ranks of a each number in given set of numbers.
• It is based on the value of a number, relative to the other numbers in the list.
• In RANK(r,n,o), $r$ is the range of the cells to find the ranking the number and o indicates the number is ranked in ascending or descending order.
• $n$ is the number to be get ranked.
• If o is zero, then the list of the numbers getting in descending order.
• If o is 1, then the list of the numbers getting in ascending order.
• When we are not mentioning the o value, then it will give the set of numbers in descending order.
• RANKS gives the spare numbers that having the same rank.
• The occurrence of the spare number affects the ranks of the next numbers.
• This function will return the result as error when any one of the argument is non-numeric.

Examples

1. 1.RANKS([32,67,12,10,23],3,0)

10	1	0
12	1	1
23	1	2
32	1	3
67	1	4

1. 2.RANKS([100,32.2,54.01,210.3,32,45,54.01,76,10.002],4,5)

10.002	1	5
32	1	6
32.2	1	7
45	1	8
54.01	2	9.5
76	1	11
100	1	12
210.3	1	13

See Also

• RANK
• RANKANDPERCENTILE
• PERCENTRANK

References

Rank