Difference between revisions of "Manuals/calci/RANKS"
Jump to navigation
Jump to search
(Created page with "==ranka") |
|||
| Line 1: | Line 1: | ||
| − | == | + | <div style="font-size:30px">'''RANKS(r,n,o)'''</div><br/> |
| + | *<math>r</math> is the set of numbers. | ||
| + | *<math>n</math> is the number to get ranked. | ||
| + | *<math>o</math> 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), <math>r</math> is the range of the cells to find the ranking the number and o indicates the number is ranked in ascending or descending order. | ||
| + | *<math>n</math> 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== | ||
| + | #RANKS([32,67,12,10,23],3,0) | ||
| + | {| class="wikitable" | ||
| + | |- | ||
| + | |10 || 1 || 0 | ||
| + | |- | ||
| + | |12 || 1 || 1 | ||
| + | |- | ||
| + | |23 || 1 || 2 | ||
| + | |- | ||
| + | |32 || 1 || 3 | ||
| + | |- | ||
| + | |67 || 1 ||4 | ||
| + | |} | ||
Revision as of 14:15, 6 December 2016
RANKS(r,n,o)
- is the set of numbers.
- is the number to get ranked.
- is the number to start.
is the set of numbers.
is the number to get ranked.
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), is the range of the cells to find the ranking the number and o indicates the number is ranked in ascending or descending order.
- 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
- RANKS([32,67,12,10,23],3,0)
| 10 | 1 | 0 |
| 12 | 1 | 1 |
| 23 | 1 | 2 |
| 32 | 1 | 3 |
| 67 | 1 | 4 |