Syntax
PERCENTILE.INC(array, k)
| Parameter | Description |
|---|---|
| array | Parameter of the PERCENTILE.INC function. |
| k | Parameter of the PERCENTILE.INC function. |
Examples
Top 10% revenue threshold
Formula
=PERCENTILE.INC(C2:C200, 0.9)
Returns the revenue value at the 90th percentile. Deals above this amount are in the top 10%.
P95 latency
Formula
=PERCENTILE.INC(E2:E10000, 0.95)
Returns the 95th percentile latency — a standard SRE metric. 95% of requests are faster than this value.
Quartile boundaries
Formula
=PERCENTILE.INC(B2:B100, 0.75)
Returns the 75th percentile (Q3), same as QUARTILE.INC(B2:B100, 3).
Common Errors
#NUM!
Returned when k < 0 or k > 1, or the data array contains no numeric values.
#VALUE!
Occurs if k is non-numeric.
Tips
Identical to PERCENTILE
PERCENTILE.INC and PERCENTILE produce exactly the same results. The .INC suffix clarifies that k=0 (min) and k=1 (max) are both valid.
Compare with PERCENTILE.EXC
PERCENTILE.EXC uses exclusive interpolation where k must be between 1/(n+1) and n/(n+1). Use .INC unless you specifically need the exclusive method for statistical rigor.
Build percentile bands
Calculate P25, P50, P75 to create quartile-based performance bands. This is more robust than using fixed thresholds when data ranges change.
Try PERCENTILE.INC in Viztab
Import your data and use PERCENTILE.INC with 370+ other formulas. No signup required.
Open Viztab