Percentile

From Catglobe Wiki
Revision as of 10:09, 7 March 2011 by 127.0.0.1 (talk | contribs) (jrfconvert import)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search



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

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

Availability

Version 5.2