← All Calculators

Percentile Calculator

Find the value at any percentile and view a full table of every 5th percentile.

Percentile formulas

Rankrank = (p / 100) × (n − 1), counting the sorted data from 0
Valuex⌊rank⌋ + (rank − ⌊rank⌋) × (x⌈rank⌉ − x⌊rank⌋)

Where Linear interpolation between neighbours — the method used by Excel PERCENTILE.INC.

Worked examples

  1. Test scores: 55, 62, 68, 70, 74, 79, 81, 85, 90, 96. Find the 90th percentile.

    1. rank = 0.90 × 9 = 8.1
    2. x8 = 90, x9 = 96
    3. 90 + 0.1 × (96 − 90) = 90.6

    Answer: 90th percentile = 90.6

Tips & common mistakes

  • "90th percentile" means 90% of values are at or below it — it is not a 90% score.