Statistical
Calculate Percentile
Calculate the value at a specific percentile in a dataset. The 90th percentile means 90% of values fall below this point. Essential for performance benchmarks and data analysis.
Excel Formula
=PERCENTILE(A2:A100, 0.9)Step-by-Step Explanation
1
PERCENTILE returns the value at a given percentile
2
A2:A100 is the data range
3
0.9 means the 90th percentile
4
Use 0.5 for the 50th percentile (same as median)
5
Use 0.25 and 0.75 for quartiles
Example
| Test Scores (A) | Percentile | Value |
|---|---|---|
| 72, 85, 90, 65, 95, 78, 88, 92, 70, 82 | 25th | 72 |
| 50th (Median) | 83.5 | |
| 75th | 90 | |
| 90th | 92.6 |
Result: =PERCENTILE(A2:A11, 0.9) → 92.6
Common Variations
Percentile rank
=PERCENTRANK(A2:A100, B2)What percentile is a specific value?
Quartile
=QUARTILE(A2:A100, 3)1=Q1, 2=Median, 3=Q3
PERCENTILE.EXC
=PERCENTILE.EXC(A2:A100, 0.9)Exclusive method (excludes 0 and 1)
Need a Custom Version?
Use our AI generator to create a formula tailored to your specific data and requirements.
Try It with AI →