Two questions in one tool: the percentile rank of a value, and the value sitting at a given percentile — with quartiles, the five-number summary, three calculation methods, and every step shown.
10 values · min 64 · max 99
A score whose percentile you want
A percentile marks the position of a value inside a distribution. The kth percentile is the point below which about k% of the data falls. It answers a different question depending on which way you read it — and the calculator above handles both directions.
Whichever direction you need, the work starts the same way — sort the data — then splits into the rank or the value path.
Percentiles are all about position, so every method begins with the values lined up smallest to largest.
For a rank, count the values below your target. For a value, compute the rank position from p.
Rank: (below + 0.5·equal) ÷ n × 100. Value: read (or interpolate) the value at the computed rank.
For the value at a percentile, note whether you used linear interpolation, nearest rank, or the exclusive method — they can disagree.
The biggest source of confusion is that calculators disagree. Here is the 50th percentile of the same six-value set, worked three accepted ways — watch the answer move.
The same data, the same percentile — three accepted answers. Always state which method you used.
Percentiles turn a raw number into a position, which is exactly what you need to compare across different scales and groups.
Quartiles, quintiles, and deciles are just percentiles at fixed, evenly-spaced points. They divide a sorted distribution into equal groups.
| Name | Divides into | Cut points | Used for |
|---|---|---|---|
| Quartiles | 4 parts | 25th, 50th, 75th | Q1, median, Q3 — the basis of box plots and the IQR. |
| Quintiles | 5 parts | 20th, 40th, 60th, 80th | Common in income and wealth distribution studies. |
| Deciles | 10 parts | 10th, 20th, … 90th | Each decile is a tenth of the population. |
| Percentiles | 100 parts | 1st … 99th | The finest standard split — one point per percent. |
They share a root word and a percent sign, but they answer opposite questions. Mixing them is the most common percentile mistake.
A handful of facts that keep percentile work honest.
Paste a data set and read off the quartiles, deciles, and key percentiles at a glance — the whole distribution in one table.
10 values · linear interpolation method

The mean is the average of a set of numbers: add them all up and divide by how many there are. This guide shows the formula, a worked example, and how the mean differs from the median and mode.

Use STDEV.S or STDEV.P in Excel, choose the right one for your data, and check the result against a worked example.

A friendly, beginner-focused guide to understanding and calculating range in statistics. Learn what range means, how to compute it, real-life applications, and common mistakes to avoid.