PercentileCont
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.