Calculates the value at a specified percentile in a range. The percentile (k) should be between 0 and 1, where 0 represents the minimum and 1 represents the maximum.
Parameter List
Syntax
PERCENTILE(range, percentile)
range
The data to consider. For example: A1:A100.
percentile
The position of the data we want in the range. 0 is min, 1 is max, 0.5 is the median.
Examples
PERCENTILE(A1:A5, 0.5) returns 30, the 50th percentile of the range A1:A5.
PERCENTILE(A1:A5, 0.25) returns 20, the 25th percentile of the range A1:A5.
PERCENTILE(A1:A5, 0.99) returns 49.6, the 99th percentile of the range A1:A5.