Difference between revisions of "Percentile"
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | {{HelpFiles}} | |
| − | + | ||
| + | ==== percentile ==== | ||
| + | |||
| + | 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 __NOTOC__ <!-- imported from file: 762.htm--> | |
| − | + | [[Category:Functions_Used_in_where_Expressions]] | |
| − | |||
| − | |||
Latest revision as of 11:41, 20 December 2011
percentile
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
