PercentileCont

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.

See Also

Was this article helpful?

Anything else?

Our customer support team is here to help.

Contact Us