Skip to content
Free math tool

Percentile calculator

Paste a list of numbers to find the value at any percentile, such as the 90th, and see where a single value ranks. Teachers, analysts and students use it for scores, response times and survey data.

  • Runs in your browser
  • Free, no account needed
  • Copy or download the result
Private: runs on this device

Input

29 characters

Result

90th percentile: 45.5
Method: Linear interpolation (R-7, Excel PERCENTILE.INC)
Position 9.1 of 10, between 45 and 50
Count: 10, minimum 12, maximum 50

Percentile rank of 30:
Below it: 5 of 10 (50%)
At or below it: 6 of 10 (60%)
Midpoint rank, (below + half of equal) / count: 55%

Example

Input
12 15 18 22 25 30 35 41 45 50
Result
90th percentile: 45.5
Method: Linear interpolation (R-7, Excel PERCENTILE.INC)
Position 9.1 of 10, between 45 and 50
Count: 10, minimum 12, maximum 50

Percentile rank of 30:
Below it: 5 of 10 (50%)
At or below it: 6 of 10 (60%)
Midpoint rank, (below + half of equal) / count: 55%

How to use the percentile calculator

  1. Type or paste numbers in the box, separated by spaces, new lines or ", ".
  2. Set Percentile (0 to 100) and choose a Method.
  3. Optionally type a value in Find the percentile rank of (optional), then press Run.
  4. Press Copy result or Download to keep the results.

How it works

Linear interpolation matches Excel PERCENTILE.INC and R type 7: the position is (n - 1) x p / 100 + 1 in the sorted list, with interpolation between neighbors.

Nearest rank picks the value at rank ceiling(p / 100 x n). The exclusive method matches Excel PERCENTILE.EXC, which uses position (n + 1) x p / 100 and rejects percentiles too close to 0 or 100 for the data size.

Percentile rank shows the share of values below, at or below, and a midpoint rank that counts half of the equal values.

Up to 10,000 numbers are allowed. Thousands separators such as 1,000 are rejected so they are not split into two numbers.

Everything runs in your browser. Your input is not uploaded or stored.

Questions and answers

Why do different tools give different percentiles?

There are several accepted definitions. Excel PERCENTILE.INC, PERCENTILE.EXC and nearest rank can give different answers for small data sets, so pick the one your class or software uses.

What is the difference between a percentile and a percentile rank?

A percentile is a value from the data, such as the score at the 90th percentile. A percentile rank is the share of the data at or below a given value.

Why does the exclusive method give an error?

PERCENTILE.EXC only works between 100 / (n + 1) and 100n / (n + 1). With 4 values that is 20 to 80.

Math

Median calculator

Find the middle value after sorting. An even-sized list uses the mean of its two middle values. Separate numbers with commas, spaces or new lines. Nonzero inputs must have a magnitude from 1e-100 to 1e100.

Open toolMath

Z-score calculator

Turn a value, mean and standard deviation into a z-score and normal percentile, or convert between z-scores and percentiles.

Open toolMath

Number range summarizer

Summarize a numeric list with its minimum, maximum, range, sum, mean and median. Separate numbers with commas, spaces or new lines. Nonzero inputs must have a magnitude from 1e-100 to 1e100.

Open toolMath

Standard deviation calculator

Measure how widely numbers vary around their mean. Use sample for a subset of a larger group, or population for the complete group. Nonzero inputs must have a magnitude from 1e-100 to 1e100. Results show up to 12 significant digits.

Open tool
All 220 SnowRock tools