Difference between revisions of "Manuals/calci/RANK"

Latest revision as of 02:17, 13 March 2017

RANK(n,r,o)

$n$ is the number to be ranked.
$r$ is the range of numbers .
$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 , 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

=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

References

Ranking

List of Main Z Functions

Z3 home

@@ Line 3: / Line 3: @@
 *<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.
+*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.
+*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.
 *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==
-. Number={20,7,5,17,32}
-RANK(7,C1:C5,0)=4
-RANK(7,C1:C5,1)=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
-. 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
@@ Line 35: / Line 23: @@
 |-
 ! 1
-|20 || 7 || 5 || 17 || 32
+|20 || 7 || 5 || 17 || 32 || || ||
 |-
 ! 2
-| 10 || 4 || -1 || 0 || 15 || 24 || 45
+| 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 ]]