PERCENTILE
Returns the k-th percentile of values in a range, where k is between 0 and 1 inclusive.
| Category | Statistical |
| Syntax | PERCENTILE(array, k) |
Parameters
| Parameter | Required | Description |
|---|---|---|
array | Required | The range or array of data values. |
k | Required | The percentile value between 0 and 1 inclusive (e.g., 0.9 for the 90th percentile). |
Example
PERCENTILE(A1:A10)
Auto-generated from the EngCanvas function registry.