Percentile Calculator: Find Percentiles & Percentile Rank

Enter details

Log in or create a free account to save your inputs and results, so you don't have to enter them again next time.🔒 No spam, ever. We never sell or share your details, and you can delete your history or account at any time. Privacy policy

Fill in the details and click Calculate to see your results.

Formula at a glance

Percentile Calculator: Inclusive position — rank = (n − 1)·p/100 + 1, interpolating between neighbours. Example: 90th percentile of 25 scores → 90th percentile: 97.2 — How the Percentile Calculator works: Inclusive position — rank = (n − 1)·p/100 + 1, interpolating between neighbours

Rate this calculator

Was it useful? A quick star rating helps others — and you can leave a comment too.

Rate it: ★ ★ ★ ★ ★

📘 About the Percentile Calculator & Percentile Rank

A percentile is the value below which a given percentage of the data falls: the 90th percentile is higher than 90% of values. Percentiles describe test scores, children’s growth charts, salaries and response times. The percentile rank of a value tells you what share of values are below it.

Paste your data and choose a percentile. The calculator gives the inclusive method used by Excel’s PERCENTILE.INC and Google Sheets, the exclusive and nearest-rank methods, the percentile rank of any value, and a table of the 10th to 99th percentiles.

🧮 Formula

Inclusive position

rank = (n − 1)·p/100 + 1, interpolating between neighbours

Percentile rank

PR = (values below + ½ × equal values) / n × 100

✏️ Worked examples

90th percentile of 25 scores

You enter
Data	43, 54, 56, 61, 62, 66, 68, 69, 69, 70, 71, 72, 77, 78, 79, 85, 87, 88, 89, 93, 95, 96, 98, 99, 99
Percentile to find	90 th

You get
90th percentile	97.2
Exclusive method (PERCENTILE.EXC)	98.4
Nearest-rank method	98 (the 23rd value)
Quartiles (inclusive)	Q1 68 · median 77 · Q3 89

97.2.

Rank of a score of 80

You enter
Data	43, 54, 56, 61, 62, 66, 68, 69, 69, 70, 71, 72, 77, 78, 79, 85, 87, 88, 89, 93, 95, 96, 98, 99, 99
Percentile to find	50 th
Percentile rank of a value (optional)	80

You get
50th percentile	77
Exclusive method (PERCENTILE.EXC)	77
Nearest-rank method	77 (the 13th value)
Percentile rank of 80	60th percentile (15 values below)
Quartiles (inclusive)	Q1 68 · median 77 · Q3 89

60th percentile (15 values below).

🧭 How to use this calculator

What you enter

DataSeparate numbers with commas, spaces or new lines.
Percentile to find (th)
Percentile rank of a value (optional)e.g. your score

What you get

90th percentile
Exclusive method (PERCENTILE.EXC)
Nearest-rank method
Quartiles (inclusive)

❓ Frequently asked questions

What is the difference between percentage and percentile?

A percentage is a score out of 100; a percentile compares you with others. 70% might be the 95th percentile on a hard test.

Why do methods give different answers?

With few data points, percentiles fall between values and conventions differ on how to interpolate. With large data sets they agree closely.

Is the 50th percentile the median?

Yes. The 25th and 75th percentiles are the first and third quartiles.

%ile Percentile Calculator & Percentile Rank