Calculate the continuous k-th percentile value for a column or group.
Usage
PercentileCont(numbers, k)
numbers (required) The column of numbers to be searched.
k (required) Percentile fraction between 0 and 1.
NOTE: Interpolation is done between adjacent values if needed.
Example
PercentileCont([Score], 0.7)
- Calculates the 70th percentile of scores. If the column values are 2, 4, 6, 8, and 10, the result would be 7.6.