Difference between revisions of "Percentile"

Latest revision as of 12:41, 20 December 2011

Calculate the 100-quantiles.

Syntax

percentile(dcsColumn, pct)

Arguments

dcsColumn: is a numeric dcs column (column whose data type is Number)

pct: an integer number. (0 < pct < 100)

Example

number n = percentile(C1, 25) where C2 == 1;

print(n); //return percentile value

Availability

Version 5.2

@@ Line 1: / Line 1: @@
-[[Category:Functions_Used_in_where_Expressions]]
+{{HelpFiles}}
-{{HelpFiles}}
+==== percentile ====
+Calculate the 100-quantiles.
-====percentile====
+'''Syntax'''
-Calculate the 100-quantiles.
+percentile(''dcsColumn, pct'')
-'''Syntax'''
+'''Arguments'''
-percentile(''dcsColumn, pct'')
+''dcsColumn'':&nbsp; is a numeric dcs column (column whose data type is Number)
-'''Arguments'''
+''pct'': an integer number. (0 &lt; pct &lt; 100)
-''dcsColumn'':  is a numeric dcs column (column whose data type is Number)
+'''Example'''
-''pct'': an integer number. (0 &lt; pct &lt; 100)
+''number n = percentile(C1, 25) where C2 == 1; ''
-'''Example'''
+''print(n); //return percentile value''
-number n = percentile(C1, 25) where C2 == 1;
+'''Availability'''
-'''Availability'''
+Version 5.2 __NOTOC__ <!-- imported from file: 762.htm-->
-Version 5.2
+[[Category:Functions_Used_in_where_Expressions]]
-__NOTOC__
-<!-- imported from file: 762.htm-->