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)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n} is the number to be ranked.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle r} is the range of numbers .
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle o} 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle RANK(n,r,o), n} is the number to be get ranked, is the range of the cells to find the ranking the number and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle o} indicates the number is ranked in ascending or descending order.
- If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle o} is zero, then the list of the numbers getting in descending order.
- If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle o} is 1, then the list of the numbers getting in ascending order.
- When we are not mentioning the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle o} value, then it will give the set of numbers in descending order.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle RANK} 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 range of the cells to find the ranking the number and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle o}
indicates the number is ranked in ascending or descending order.
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 |