PERCENTILE function
The PERCENTILE function is one of the statistical functions. It is used to analyze the range of data and return the k-th percentile.
Syntax
PERCENTILE(array, k)
The PERCENTILE function has the following arguments:
| Argument | Description |
|---|---|
| array | The selected range of cells for which you want to calculate the k-th percentile. |
| k | The percentile value, a numeric value greater than or equal to 0 but less than or equal to 1. |
Notes
How to apply the PERCENTILE function.
Examples
The figure below displays the result returned by the PERCENTILE function.
