Loading…
Loading…
PERCENTILE returns the k-th percentile (k between 0 and 1).
=PERCENTILE(array, k)
| Argument | Required? | What it is |
|---|---|---|
| array | Required | The range or array to work on. |
| k | Required | The percentile as a decimal between 0 and 1, such as 0.9 for the 90th percentile. |
Type the formula yourself and get it graded instantly, no Excel needed.