Percentile Calculator

Your values

Find

Separate numbers with spaces, commas, semicolons or line breaks, or paste a spreadsheet column. Use a decimal comma only when values are separated by spaces, semicolons or line breaks. Up to 10,000 numbers.

From 0 to 100, for example 90 for the 90th percentile.

Method

Interpolates at position (n − 1)p + 1. Also used by Google Sheets, NumPy's default and R type 7.

Result

90th percentile

Same percentile by method

Excel PERCENTILE.INC
87.6
Excel PERCENTILE.EXC
91.5
Nearest rank
88

Common percentiles (Excel PERCENTILE.INC)

P10P25P50P75P90
61.36773.581.7587.6
Data with the percentile marked90th percentile: 87.6

Sorted data (n = 12)

55, 61, 64, 68, 70, 72, 75, 78, 81, 84, 88, 93

Step by step

  1. Find the position h, then interpolate between the values on either side of it.
    h=(n−1)⋅p+1h=(n-1)\cdot p+1
    =(12−1)⋅0.9+1=10.9=(12-1)\cdot0.9+1=10.9
    P90=x10+0.9 (x11−x10)P_{90}=x_{10}+0.9\,(x_{11}-x_{10})
    =84+0.9×(88−84)=87.6=84+0.9\times(88-84)=87.6

About this tool

A percentile tells you where a value stands within a group: the 90th percentile is the value that 90% of the data lies at or below. Percentiles are used for exam results, growth charts, salaries, response times and many other rankings, and the quartiles are simply the 25th, 50th and 75th percentiles.

This calculator finds percentiles of your own data, the percentile rank of a single score, and percentiles of a normal distribution from its mean and standard deviation. For the normal case it uses the same method as the z-score calculator, and the normal distribution calculator handles areas between two values.

How it works

Choose one of three modes. Value at a percentile finds the number below which a given share of your data lies, for example the 90th percentile of test scores. Percentile rank works the other way: enter a value and see what share of the data set lies below it. Mean and SD uses the normal distribution instead of raw data, which is how percentiles for heights, IQ scores or standardized tests are usually reported.

For raw data, pick the method that matches your software or course. Excel PERCENTILE.INC (also Google Sheets and NumPy's default) and PERCENTILE.EXC interpolate between neighbouring values, while the nearest-rank method always returns one of the data values. The results list the answer under every method so you can see whether the choice matters.

h=(n−1) p+1,Pp=x⌊h⌋+(h−⌊h⌋) (x⌊h⌋+1−x⌊h⌋)h=(n-1)\,p+1,\qquad P_p=x_{\lfloor h\rfloor}+(h-\lfloor h\rfloor)\,(x_{\lfloor h\rfloor+1}-x_{\lfloor h\rfloor})

Example

Twelve students scored 55, 61, 64, 68, 70, 72, 75, 78, 81, 84, 88 and 93. With Excel PERCENTILE.INC the 90th percentile is at position h=11×0.9+1=10.9h = 11 \times 0.9 + 1 = 10.9, between the 10th and 11th scores, so P90=84+0.9×(88−84)=87.6P_{90} = 84 + 0.9 \times (88 - 84) = 87.6. PERCENTILE.EXC gives 91.5 and the nearest-rank method 88.

A score of 75 has 6 scores below it and 1 equal to it, so its percentile rank is (6+0.5×1)/12×100≈54.17(6 + 0.5 \times 1)/12 \times 100 \approx 54.17. On a normal scale with mean 100 and standard deviation 15, a value of 130 has z=2z = 2 and sits at about the 97.72nd percentile.

Assumptions and limits

Percentile definitions differ between textbooks and software, especially for small data sets, so match the method to the one you are asked to use. PERCENTILE.EXC is defined only between 1/(n + 1) and n/(n + 1); outside that range the calculator asks for a different percentile, as Excel would return an error.

The mean-and-SD mode assumes a normal distribution. Real data are often skewed or bounded, and then percentiles from a normal curve can be far from the true ones, especially in the tails. Percentile ranks here use the common mid-rank definition; Excel's PERCENTRANK.INC is shown for comparison without its default truncation to three digits.

Frequently asked questions

What is the difference between a percentile and a percentage?

A percentage is a share of a total, such as 80% of the questions answered correctly. A percentile is a position within a group: scoring at the 80th percentile means doing as well as or better than about 80% of the people in the group, whatever your raw score was.

How do I calculate a percentile by hand?

Sort the data and find the position h=(n−1)p+1h = (n - 1)p + 1, where p is the percentile as a decimal. If h is a whole number, the percentile is the value at that position; otherwise interpolate between the two values around it. This is the PERCENTILE.INC method.

Why do PERCENTILE.INC and PERCENTILE.EXC give different answers?

They place the percentile at different positions in the sorted list: INC uses h=(n−1)p+1h = (n - 1)p + 1 and includes the minimum and maximum as the 0th and 100th percentiles, while EXC uses h=(n+1)ph = (n + 1)p and treats the data as a sample from a wider population. The gap shrinks as the data set grows.

How do I find a percentile from the mean and standard deviation?

Convert the value to a z-score with z=(x−μ)/σz = (x - \mu)/\sigma and read the area to its left under the standard normal curve. For example, z=1z = 1 is about the 84th percentile. Choose the Mean and SD mode to do both steps.

What does a percentile rank of 50 mean?

Half of the group is below the value, counting ties as half below and half above, so the value is at the median. A percentile rank describes position only; it does not say how far apart the values are.

Link with your values

Add these parameters to this page’s address to open it with the values filled in, for example to share a calculation or to link to it from an AI assistant. The result is calculated in the browser: the page HTML shows an example for the default values, and the tool sets the data-url-params attribute once the link’s values are applied.

ParameterValueIf omitted
modeFindone of: value, rank, normaldefault value
valuesData setvalues separated by commas: 2,4,4,6; used with mode = value, rankrequired
percentilePercentilenumber; allowed 0–100; used with mode = value, normalrequired
methodMethodone of: inc, exc, nearest; used with mode = valuedefault inc
xValue (x)number; used with mode = rankrequired
meanMean (μ)number; used with mode = normalrequired
sdStandard deviation (σ)number; allowed > 0; used with mode = normalrequired
scoreValue (x)number; used with mode = normalrequired

Examples

  • ?values=55,61,64,68,70,72,75,78,81,84,88,93&percentile=25&method=exc
  • ?values=12,15,15,18,21,24,30&x=18
  • ?mean=500&sd=100&score=650

Write decimals with a point. Encode a space as %20, + as %2B, # as %23 and & as %26.

Result elements: [data-result-block="percentile_calculator"]