Percentile: Difference between revisions

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