Difference between revisions of "Percentile"
(jrfconvert import) |
|||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | {{HelpFiles}} | |
| − | | ||
| − | ====percentile==== | + | ==== percentile ==== |
| − | Calculate the 100-quantiles. | + | Calculate the 100-quantiles. |
| − | '''Syntax''' | + | '''Syntax''' |
| − | percentile(''dcsColumn, pct'') | + | percentile(''dcsColumn, pct'') |
| − | '''Arguments''' | + | '''Arguments''' |
| − | ''dcsColumn'': | + | ''dcsColumn'': is a numeric dcs column (column whose data type is Number) |
| − | ''pct'': an integer number. (0 < pct < 100) | + | ''pct'': an integer number. (0 < pct < 100) |
| − | '''Example''' | + | '''Example''' |
| − | percentile(C1, 25) where C2 == 1; | + | ''number n = percentile(C1, 25) where C2 == 1; '' |
| − | '' | + | ''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]] | ||
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
