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">(</...") |
|||
| (13 intermediate revisions by 4 users not shown) | |||
| 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)</math>, <math>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 non-numeric. | ||
| − | + | ==Examples== | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | RANK | + | {| 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 | ||
| + | |} | ||
| + | #=RANK(7,A1:E1,0) = 4 | ||
| + | #=RANK(7,A1:E1,1) = 2 | ||
| + | #=RANK(4,A2:G2,0) = 5 | ||
| + | #=RANK(4,A2:G2,1) = 3 | ||
| + | #=RANK(-1,A2:G2,0) = 7 | ||
| + | #=RANK(0,A3:H3,0) = 3 | ||
| + | #=RANK(0,A3:H3,1) = 6 | ||
| + | #=RANK(-18,A3:H3,1) = 4 | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|Pu32MJHL2nw|280|center|RANK}} | ||
| − | + | ==See Also== | |
| − | |||
| − | |||
| − | + | *[[Manuals/calci/RANKANDPERCENTILE| RANKANDPERCENTILE]] | |
| − | + | ==References== | |
| − | + | *[http://en.wikipedia.org/wiki/Ranking Ranking] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | *[[Z_API_Functions | List of Main Z Functions]] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | *[[ Z3 | Z3 home ]] | |
| − | |||
Latest revision as of 01:17, 13 March 2017
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 non-numeric.
, 
gives the spare numbers that having the same rank.Examples
| 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 |
- =RANK(7,A1:E1,0) = 4
- =RANK(7,A1:E1,1) = 2
- =RANK(4,A2:G2,0) = 5
- =RANK(4,A2:G2,1) = 3
- =RANK(-1,A2:G2,0) = 7
- =RANK(0,A3:H3,0) = 3
- =RANK(0,A3:H3,1) = 6
- =RANK(-18,A3:H3,1) = 4
Related Videos
See Also
References