AIWalay Tools

Percentile Calculator

Find any percentile of a data set or the percentile rank of a value. Uses Excel-compatible linear interpolation with quartiles shown alongside.

About the Percentile Calculator

This percentile calculator works in both directions: give it a percentile (say the 90th) and it returns the value at that position in your data, or give it a value and it returns that value's percentile rank — the share of the data at or below it. Q1, the median and Q3 are always shown for context.

Percentile values use linear interpolation between the closest ranks, the same method as Excel's PERCENTILE.INC and most statistics packages: the target position is (n − 1) × p, and when it lands between two sorted values the result is interpolated proportionally. Percentile rank uses the mean-rank definition — (values below + half of the values equal) ÷ n × 100 — which handles ties gracefully.

Percentiles are how test scores, growth charts, salaries and latency metrics are reported, because they describe position without assuming any particular distribution. Your data never leaves the browser.

How to Use the Percentile Calculator

  1. 1Paste your data values, separated by commas, spaces or new lines.
  2. 2Choose whether you want a percentile value or a percentile rank.
  3. 3Enter the target percentile (0–100) or the value to rank.
  4. 4Read the result along with Q1, median and Q3 for context.

Frequently Asked Questions

How do you calculate a percentile? A worked example

For the sorted data 55, 62, 68, 71, 74, 80, 85, 91 (n = 8), the 90th percentile position is (8 − 1) × 0.90 = 6.3. That is 30% of the way between the 7th value (85) and the 8th (91): 85 + 0.3 × 6 = 86.8. The calculator applies exactly this interpolation.

What is a percentile rank and how is it different?

A percentile rank goes the other way: it tells you where a specific value stands. In the data above, the value 74 has 4 values below it and 1 equal, so its rank is (4 + 0.5)/8 × 100 = 56.25% — it sits just above the middle. Percentile finds a value from a position; rank finds a position from a value.

Why does my result differ slightly from another calculator?

There are several accepted percentile definitions (exclusive vs inclusive, nearest-rank vs interpolated). This tool uses the inclusive linear-interpolation method (Excel's PERCENTILE.INC, R type 7), the most common default. Differences between methods shrink as the data set grows.

What does the 50th percentile mean?

It is the median — half the data lies at or below it. Similarly the 25th percentile is Q1 and the 75th is Q3, which this calculator always displays so you can see your target percentile in context.

Can I use this for test scores or salaries?

Yes — paste the full set of scores or salaries and either look up a percentile (e.g. the 90th-percentile salary) or enter one person's number to find their standing. For example, scoring at the 84th percentile means you did as well as or better than 84% of test takers.

Related Tools