PERCENTILE
Returns the k-th percentile of values in a range.
CompatibilityCompatibility / LegacyLegacy / Older Versions
What it does
Legacy percentile function (inclusive).
Syntax
PERCENTILE(array, k)
Arguments
array(range) — Data.k(number) — Percentile (0-1).
Examples
Legacy Percentile
90th percentile.
FORMULA
=PERCENTILE(A1:A10, 0.9)
RESULT
95
SAMPLE DATA
| A | |
|---|---|
| 1 | Data |
| 2 | 10 |
| 3 | 20 |
| 4 | ... |