PERCENTILE Function Generator
PERCENTILE returns the Kth percentile of a data range. Common in performance (p95 latency), analytics (top 10%), and grading.
Syntax
=PERCENTILE.INC(range, k)Try it — generate a PERCENTILE formula
Examples
p95 latency
=PERCENTILE.INC(A2:A10000, 0.95)95% of values are at or below this.
Top 10% threshold
=PERCENTILE.INC(A:A, 0.9)Value at the 90th percentile — everything above is top 10%.
Quartiles
=PERCENTILE.INC(A:A, 0.25)Q1 = 25th percentile. Similarly 0.5 is median, 0.75 is Q3.
Tips
- ✓k must be between 0 and 1.
- ✓PERCENTILE.EXC excludes 0 and 100 (more strict). PERCENTILE.INC includes them.
- ✓For performance monitoring p50/p90/p95/p99 are most useful.
Related Formulas
MEDIAN
MEDIAN returns the middle value when a range is sorted. More robust than AVERAGE...
RANK
RANK returns the position of a value within a range when sorted. Use RANK.EQ for...
STDEV
STDEV calculates the standard deviation of a data set — how spread out values ar...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free