Difference between revisions of "Manuals/calci/RANK"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font face="Arial, sans-serif"><font size="2">'''RANK'''</font></font><font face="Arial, sans-serif"><font size="2">(</...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''RANK(n,r,o)'''</div><br/> |
| + | *<math>n</math> is the number to be ranked. | ||
| + | *<math>r</math> is the range of numbers . | ||
| + | *<math> o</math> indicates the number is ranked in ascending or descending order. | ||
| + | |||
| − | < | + | ==Description== |
| + | *This function gives the rank of a given set of numbers. | ||
| + | *It is based on the value of a number, relative to the other numbers in the list. | ||
| + | *In <math> RANK(n,r,o), n</math> is the number to be get ranked, <math>r</math> is the range of the cells to find the ranking the number and <math>o</math> indicates the number is ranked in ascending or descending order. | ||
| + | *If <math>o</math> is zero, then the list of the numbers getting in descending order. | ||
| + | *If <math>o</math> is 1, then the list of the numbers getting in ascending order. | ||
| + | *When we are not mentioning the <math>o</math> value, then it will give the set of numbers in descending order. | ||
| + | *<math>RANK</math> 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 nonnumeric. | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | ==Examples== | |
| − | + | 1. Number={20,7,5,17,32} | |
| − | + | RANK(7,C1:C5,0)=4 | |
| − | + | RANK(7,C1:C5,1)=2 | |
| − | + | 2. Number={10,4,-1,0,15,24,45} | |
| − | + | RANK(4,G1:G7,0)=5 | |
| − | + | RANK(4,G1:G7,1)=3 | |
| − | + | RANK(-1,G1:G7,0)=7 | |
| − | + | 3. Number={4,-1,-47,-23,0,-18,1,-35} | |
| − | + | RANK(0,H1:H8,0)=3 | |
| − | + | RANK(0,H1:H8,1)=6 | |
| − | + | RANK(-18,H1:H8,1)=4 | |
| − | + | {| class="wikitable" | |
| − | + | |+Spreadsheet | |
| − | + | |- | |
| − | - | + | ! !! A !! B !! C !!D !! E !! F !! G !! H |
| − | + | |- | |
| − | + | ! 1 | |
| − | + | |20 || 7 || 5 || 17 || 32 | |
| − | ---- | + | |- |
| − | + | ! 2 | |
| − | + | | 10 || 4 || -1 || 0 || 15 || 24 || 45 | |
| − | + | |- | |
| − | + | !3 | |
| − | + | | 4 || -1 || -47 || -23 || 0 || -18 || 1 || -35 | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | class=" | ||
| − | | | ||
| − | |- | ||
| − | |||
| − | | | ||
| − | |||
| − | |||
| − | |||
| − | | | ||
| − | | | ||
| − | | | ||
| − | | | ||
| − | | | ||
| − | | | ||
| − | | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |- | ||
| − | |||
| − | | | ||
| − | | | ||
| − | | | ||
| − | |||
| − | |- | ||
| − | | | ||
| − | |||
| − | | | ||
| − | | | ||
| − | | | ||
| − | |- | ||
| − | |||
| − | | | ||
| − | | | ||
| − | | | ||
| − | |||
| − | |- | ||
| − | |||
| − | |||
| − | | | ||
| − | |||
| − | |||
| − | |- | ||
| − | |||
| − | | | ||
| − | |||
| − | |||
| − | |||
| − | |- | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| − | |||
| − | |||
| − | |||
Revision as of 04:15, 15 January 2014
RANK(n,r,o)
- is the number to be ranked.
- is the range of numbers .
- indicates the number is ranked in ascending or descending order.
is the number to be ranked.
is the range of numbers .
indicates the number is ranked in ascending or descending order.
Description
- This function gives the rank of a given set of numbers.
- It is based on the value of a number, relative to the other numbers in the list.
- In is the number to be get ranked, is the range of the cells to find the ranking the number and indicates the number is ranked in ascending or descending order.
- If is zero, then the list of the numbers getting in descending order.
- If is 1, then the list of the numbers getting in ascending order.
- When we are not mentioning the value, then it will give the set of numbers in descending order.
- 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 nonnumeric.
is the number to be get ranked, 
gives the spare numbers that having the same rank.
Examples
1. Number={20,7,5,17,32} RANK(7,C1:C5,0)=4 RANK(7,C1:C5,1)=2 2. Number={10,4,-1,0,15,24,45} RANK(4,G1:G7,0)=5 RANK(4,G1:G7,1)=3 RANK(-1,G1:G7,0)=7 3. Number={4,-1,-47,-23,0,-18,1,-35} RANK(0,H1:H8,0)=3 RANK(0,H1:H8,1)=6 RANK(-18,H1:H8,1)=4
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | 20 | 7 | 5 | 17 | 32 | |||
| 2 | 10 | 4 | -1 | 0 | 15 | 24 | 45 | |
| 3 | 4 | -1 | -47 | -23 | 0 | -18 | 1 | -35 |