Manuals/calci/RANK - Revision history

Jayaram at 07:17, 13 March 2017

2017-03-13T07:17:56Z

Jayaram at 11:30, 9 March 2017

2017-03-09T11:30:06Z

Swapna at 20:42, 25 June 2015

2015-06-25T20:42:00Z

Devika: /* References */

2015-05-11T15:56:20Z

References

Devika: /* References */

2015-05-11T15:56:02Z

References

Devika: /* References */

2015-05-11T15:55:25Z

References

Devika: /* References */

2015-05-11T15:55:08Z

References

Devika: /* See Also */

2015-05-11T15:52:46Z

Abin: /* Description */

2014-01-30T05:12:26Z

Description

Abin at 05:12, 30 January 2014

2014-01-30T05:12:09Z

← Older revision		Revision as of 07:17, 13 March 2017
Line 53:		Line 53:


−	[[Z_API_Functions \| List of Main Z Functions]]	+	*[[Z_API_Functions \| List of Main Z Functions]]

−	[[ Z3 \| Z3 home ]]	+	*[[ Z3 \| Z3 home ]]

← Older revision		Revision as of 11:30, 9 March 2017
Line 51:		Line 51:

	*[http://en.wikipedia.org/wiki/Ranking Ranking]		*[http://en.wikipedia.org/wiki/Ranking Ranking]
		+
		+
		+	[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	[[ Z3 \| Z3 home ]]

@@ Line 39: / Line 39: @@
 #=RANK(0,A3:H3,1) = 6
 #=RANK(-18,A3:H3,1) = 4
 ==See Also==

@@ Line 45: / Line 45: @@
 ==References==
-*[ http://en.wikipedia.org/wiki/Ranking Ranking]
 *[http://en.wikipedia.org/wiki/Ranking Ranking]

← Older revision		Revision as of 15:56, 11 May 2015
Line 46:		Line 46:
	==References==		==References==
	*[ http://en.wikipedia.org/wiki/Ranking Ranking]		*[ http://en.wikipedia.org/wiki/Ranking Ranking]
		+	*[http://en.wikipedia.org/wiki/Ranking Ranking]

← Older revision		Revision as of 15:55, 11 May 2015
Line 45:		Line 45:

	==References==		==References==
−	*[ http://en.wikipedia.org/wiki/Ranking Ranking]	+	*[ http://en.wikipedia.org/wiki/Ranking Ranking]

← Older revision		Revision as of 15:52, 11 May 2015
Line 42:		Line 42:
	==See Also==		==See Also==

		+	*[[Manuals/calci/RANKANDPERCENTILE\| RANKANDPERCENTILE]]

	==References==		==References==

@@ Line 14: / Line 14: @@
 *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==

@@ 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.
@@ Line 33: / Line 32: @@
 | 4 || -1 || -47 || -23 || 0 || -18 || 1 || -35
 |}
-#RANK(7,A1:E1,0) = 4
+#=RANK(7,A1:E1,0) = 4
-#RANK(7,A1:E1,1) = 2
+#=RANK(7,A1:E1,1) = 2
-#RANK(4,A2:G2,0) = 5
+#=RANK(4,A2:G2,0) = 5
-#RANK(4,A2:G2,1) = 3
+#=RANK(4,A2:G2,1) = 3
-#RANK(-1,A2:G2,0) = 7
+#=RANK(-1,A2:G2,0) = 7
-#RANK(0,A3:H3,0) = 3
+#=RANK(0,A3:H3,0) = 3
-#RANK(0,A3:H3,1) = 6
+#=RANK(0,A3:H3,1) = 6
-#RANK(-18,A3:H3,1) = 4
+#=RANK(-18,A3:H3,1) = 4
 ==See Also==