The PercentileCont function calculates the continuous k-th percentile value for a column or group.


Syntax

PercentileCont(column, k)

Function arguments:

  • column (required) - The column of numbers to search.
  • k (required) - Percentile fraction between 0 and 1.

Interpolation is done between adjacent values if needed.


Example

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

Related Functions


Was this page helpful?
Yes No