Manuals/calci/PERCENTRANK - Revision history

Devika at 21:56, 8 August 2018

2018-08-08T21:56:18Z

2018-06-08T19:05:55Z

2017-03-13T06:40:06Z

2017-03-09T11:28:08Z

2015-10-06T09:00:30Z

Examples

2015-10-06T08:57:33Z

Examples

2015-06-20T01:42:30Z

2014-01-22T08:51:05Z

Examples

2014-01-07T08:59:19Z

2014-01-07T08:58:21Z

Examples

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''PERCENTRANK (Array,Number,Significance) '''</div><br/>
 *<math>Array</math>  is the set of data and  <math> Number</math> is  the value to find the rank.
 ==Description==

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''PERCENTRANK(ar,x) '''</div><br/>
+<div style="font-size:30px">'''PERCENTRANK (Array,Number,Significance) '''</div><br/>
-*<math>ar</math>  is the array  data and  <math> x </math> is  the value
+*<math>Array</math>  is the set of data and  <math> Number</math> is  the value to find the rank.
 ==Description==
@@ Line 12: / Line 12: @@
 <math>S</math> = Number of same rank,
 <math>N</math> = Total numbers.
-*In <math>PERCENTRANK(ar,x)</math>, <math>ar</math> is the array  of numeric values and <math>x</math> is the value to find the rank.
+*In <math>PERCENTRANK (Array,Number,Significance)</math>, <math>Array</math> is the array  of numeric values and <math>Number</math> is the value to find the rank.
 *This function gives the result as error when array is empty .

← Older revision		Revision as of 06:40, 13 March 2017
Line 54:		Line 54:


−	[[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:28, 9 March 2017
Line 51:		Line 51:
	==References==		==References==
	[http://en.wikipedia.org/wiki/Percentile_rank Percentile Rank ]		[http://en.wikipedia.org/wiki/Percentile_rank Percentile Rank ]
		+
		+
		+
		+	[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	[[ Z3 \| Z3 home ]]

@@ Line 36: / Line 36: @@
 | 7 || 6 || 2 || 5 || 9 ||1
 |}
-  =PERCENTRANK(A1:F6,3) = 0.267
+  =PERCENTRANK(A1:F1,3) = 0.267
 ==Related Videos==

@@ Line 20: / Line 20: @@
 |+Spreadsheet
 |-
-! !! A !! B !! C !! D
+! !! A !! B !! C !! D !! E
 |-
 ! 1
 | 3 || 4 || 1 || 2 ||1
 |}
-  =PERCENTRANK(A1:A5,2) = 0.5
+  =PERCENTRANK(A1:E1,2) = 0.5
 .
@@ Line 36: / Line 36: @@
 | 7 || 6 || 2 || 5 || 9 ||1
 |}
-  =PERCENTRANK(B1:B6,3) = 0.267
+  =PERCENTRANK(A1:F6,3) = 0.267
 ==Related Videos==

@@ Line 37: / Line 37: @@
 |}
   =PERCENTRANK(B1:B6,3) = 0.267
 ==See Also==

@@ Line 22: / Line 22: @@
-PERCENTRANK(A1:A5,2)=0.5
+PERCENTRANK(A1:A5,2) = 0.5
 #7
@@ Line 29: / Line 29: @@
-PERCENTRANK(B1:B6,3)=0.267
+PERCENTRANK(B1:B6,3) = 0.267
 ==See Also==