Percentile calculator
The pth percentile is the value below which p% of the data falls. The tool interpolates linearly between the two nearest values.
Loading the tool…
Processing and privacy: The result is calculated inside your browser and your data is not sent to any server.
How to use it
- Enter data (separate numbers with commas, spaces or new lines), percentile and method.
- The result appears straight away and updates as you edit.
- Copy the result, or copy a link that keeps the same values to share it.
How it is calculated
After sorting: the inclusive method uses position 1 + (n - 1) × p, the exclusive method (n + 1) × p, then interpolates between the two values around that position.
Example
Inputs: Percentile = 40 %, Method = Inclusive (PERCENTILE.INC). Result: Value at percentile 40: 29; Position in sorted data: 2.6; Count: 5.
15, 20, 35, 40, 50
15, 20, 35, 40, 50
Limits and caveats
- Software packages define percentiles differently, so small data sets may give slightly different answers elsewhere.
- The exclusive method cannot reach percentiles very close to 0 or 100.
Questions about this tool
Which method should I choose?
Inclusive is the default in Excel (PERCENTILE and PERCENTILE.INC) and many other programs. Exclusive matches PERCENTILE.EXC and appears in some statistics textbooks.
Is the 50th percentile the median?
Yes, the 50th percentile equals the median under both methods.
How is a percentile different from a percentile rank?
A percentile gives the value at a chosen share; a percentile rank gives the share for a chosen value. They are inverse operations.