Difference between revisions of "Manuals/calci/RANK"

 
(12 intermediate revisions by 4 users not shown)
Line 3: Line 3:
 
*<math>r</math>  is the range of numbers .
 
*<math>r</math>  is the range of numbers .
 
*<math> o</math> indicates the number is ranked in ascending or descending order.
 
*<math> o</math> indicates the number is ranked in ascending or descending order.
 
  
 
==Description==
 
==Description==
 
*This function gives the rank of a given set of numbers.  
 
*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.  
 
*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.  
+
*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 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.  
+
*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.  
+
*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.  
 
*<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.
 
*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.
+
*This function will return the result as error when any one of the argument is non-numeric.
  
 +
==Examples==
  
==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"
 
{| class="wikitable"
 
|+Spreadsheet
 
|+Spreadsheet
Line 35: Line 23:
 
|-
 
|-
 
! 1
 
! 1
|20 || 7 || 5 || 17 || 32   
+
|20 || 7 || 5 || 17 || 32 || || ||    
 
|-
 
|-
 
! 2
 
! 2
| 10 || 4 || -1 || 0 || 15 || 24 || 45  
+
| 10 || 4 || -1 || 0 || 15 || 24 || 45 || 
 
|-
 
|-
 
!3
 
!3
 
| 4 || -1 || -47 || -23 || 0 || -18 || 1 || -35  
 
| 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 02: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.

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.

Examples

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
  1. =RANK(7,A1:E1,0) = 4
  2. =RANK(7,A1:E1,1) = 2
  3. =RANK(4,A2:G2,0) = 5
  4. =RANK(4,A2:G2,1) = 3
  5. =RANK(-1,A2:G2,0) = 7
  6. =RANK(0,A3:H3,0) = 3
  7. =RANK(0,A3:H3,1) = 6
  8. =RANK(-18,A3:H3,1) = 4

Related Videos

RANK

See Also

References