PercentileDisc

The PercentileDisc function returns the discrete k-th percentile value for a column or group.

Syntax

PercentileDisc(column, k)

Function arguments:

  • column (required) - The column of numbers to be searched.
  • k (required) - The percentile fraction between 0 and 1.

Example

PercentileDisc([Score], 0.7)
  • Calculates the discrete 70th percentile of scores.  If the column values are 2, 4, 6, 8, and 10, the result would be 8.

See Also

Was this page helpful?
Yes No