Percentile Calculator

Paste a list of numbers to find any percentile, such as the 25th, 50th (median) or 90th percentile, or switch modes to find the percentile rank of a particular score: the percentage of values it beats. Choose the calculation method (the inclusive method used by Excel's PERCENTILE.INC and most software, the exclusive method, or nearest rank), and see the quartiles, interquartile range, a table of common percentiles, a box plot and the working.

  • 100% free
  • No sign-up
  • Private & local
  • Works on mobile

Common percentiles

Box plot

Sorted data

Private by design: every calculation runs locally in your browser. Nothing you type is sent to a server or stored by us.

What Is a Percentile?

A percentile tells you the value below which a given percentage of the data falls. The 90th percentile is the value that 90% of the data is at or below. If your exam score is at the 90th percentile, you scored higher than about 90% of the people who took it. The 50th percentile is the median, the middle value, and the 25th and 75th percentiles are the lower and upper quartiles (Q1 and Q3).

Don't confuse percentiles with percentages. A score of 70% on a test could be at the 95th percentile if the test was hard and most people scored lower, or at the 30th percentile if it was easy.

How to Calculate a Percentile

  1. Sort the data from smallest to largest.
  2. Find the position for percentile p. With the inclusive method: position = (n − 1) × p/100 + 1.
  3. If the position is a whole number, the percentile is the value at that position.
  4. If not, interpolate between the two neighbouring values.

Example: for the 15 scores in the calculator, the 90th percentile position is (15 − 1) × 0.9 + 1 = 13.6. The 13th value is 90 and the 14th is 92, so the 90th percentile = 90 + 0.6 × (92 − 90) = 91.2.

Which Method Should I Use?

MethodPositionUsed by
Inclusive (linear)(n − 1)p + 1Excel PERCENTILE.INC and PERCENTILE, Google Sheets, NumPy and pandas defaults, R type 7
Exclusive(n + 1)pExcel PERCENTILE.EXC, Minitab, SPSS, many statistics textbooks
Nearest rank⌈p × n⌉Simple textbook definition. Always returns an actual data value.

There's no single "correct" definition of a percentile, and for large data sets the methods give almost identical answers. For small data sets they can differ noticeably, so if you need to match a textbook, teacher or software package, choose the same method. The exclusive method can't calculate very low or very high percentiles for small data sets, which is why the table shows a dash in those cases.

Percentile Rank

The percentile rank of a value answers the reverse question: what percentage of the data is below this value? The calculator uses the standard formula, which counts values equal to your score as half below:

PR = (number below + ½ × number equal) ÷ total × 100

For a score of 84 in the example data, 9 values are below it and 1 is equal, so PR = (9 + 0.5) ÷ 15 × 100 = 63.3%. The calculator also shows the simpler "strictly below" and "at or below" percentages.

Where Percentiles Are Used

  • Exams: SAT, ACT, GRE and many national exams report percentile ranks alongside scores.
  • Child growth charts: a baby at the 60th percentile for weight is heavier than 60% of babies of the same age and sex.
  • Salaries: pay surveys often quote the 25th, 50th and 75th percentiles.
  • Web performance: response times are measured at the 95th or 99th percentile (p95, p99) to capture the slowest experiences.

Percentiles and Outliers

Quartiles are also used to spot unusual values. A common rule marks a value as an outlier if it's more than 1.5 × IQR below Q1 or above Q3. For the example data, Q1 = 71, Q3 = 86.5 and IQR = 15.5, so values below 47.75 or above 109.75 would be outliers. None of the scores are, which the box plot confirms. Unlike the mean and standard deviation, percentiles and quartiles aren't pulled around by extreme values, which makes them a robust way to describe skewed data such as incomes, house prices and response times.

Frequently Asked Questions

Is the 50th percentile the same as the median?

Yes. The 50th percentile is the median, the middle value of the sorted data.

What does the 90th percentile mean?

90% of the values are at or below it, and only 10% are higher.

Why do different calculators give different answers?

They use different methods. Choose the method that matches your software or textbook.

What is the interquartile range (IQR)?

Q3 − Q1, the spread of the middle 50% of the data. It isn't affected by extreme outliers.

How should I enter the data?

Separate numbers with commas, spaces or new lines. You can paste a column straight from a spreadsheet.