Percentile Rank Calculator screenshot

Percentile Rank Calculator

Where one value stands in a column, by the midrank convention, with the counts below and equal shown.

Privacy First
0 Runs
Updated 2026-11-21
Runs in your browser
No sign-up, no upload

What the percentile rank calculator does

It answers the question the percentile page does not: a value goes in and its rank comes out. The rank is the midrank convention, (below + 0.5 × equal) ÷ n × 100, which treats the values tied with yours as half below and half above.

In the eight values two, four, four, four, five, five, seven, nine, the value 5 has four values below it and two equal to it, so its rank is (4 + 1) ÷ 8 × 100 = 62.5 %. The counts are printed beside the percentage, because a rank is only meaningful next to the data it came from.

The nearest-rank reading and the at-or-below reading give other answers for a tied value, so the page names the convention it uses rather than leaving it to guesswork. A value that does not appear in the column is read normally: its rank is the share strictly below it.

The page reads one value per line, up to 20 000 values. It refuses an empty column, a value that is not a number, and a token in the column that is not a number, naming the line in each case. A single value is accepted: its own rank is 50 % under the midrank rule.

Figures print to up to four decimal places with trailing zeros trimmed.

How to use it

Paste the column into the text box, one value per line, and type the value whose rank you want into Value whose rank you want.

Press Run. The result prints the value, the count, the counts below and equal, and the percentile rank.

Worked example

Input with the value 5 and the default column:

2
4
4
4
5
5
7
9

Output:

Values below:       4
Values equal:       2
Percentile rank:    62.5 %
Definition:         the midrank convention — (below + 0.5 × equal) ÷ n × 100

Why it runs in your browser

The comparison and the division run in this tab. Your column is never uploaded.

The page answers the inverse of the percentile question: a value goes in, its rank comes out. In the eight values two, four, four, four, five, five, seven, nine, the value 5 has four values below it and two equal to it, so its percentile rank is 62.5 %.

The rank uses the midrank convention — (below + 0.5 × equal) ÷ n × 100 — which counts a tie as half below and half above. The counts are printed beside the percentage so the convention is visible in the answer.

A value that does not appear in the column is read normally: its rank is the share of values strictly below it, with no ties to split.

Value at a percentile versus rank of a value

These are opposite directions. The percentile-calculator page takes a percentile and returns the value at it; this page takes a value and returns its percentile rank. A reader who wants the value at the 75th percentile wants that page, and a reader who wants where 87 stands among the scores wants this one.

The two pages agree on the underlying order statistics, so running one and then the other on the same column returns you to the value you started from when the value is one of the observations.

Three definitions, and the one used here

The nearest-rank reading gives the share of values at or below the target. The strict reading gives the share below it. The midrank reading gives below plus half of the ties, and it is the one this page prints because it is the only one of the three that treats a tie symmetrically.

For a value with no ties, the strict and midrank readings give the same number. They differ only when the column repeats the value, which is exactly when the choice matters — and the counts of below and equal are printed so a reader who needs another convention can compute it.

How to use Percentile Rank Calculator

Paste the column into the text box, one value per line.

Type the value you are asking about into Value whose rank you want.

Press Run. The result prints that value, the count, the values below and equal, and the percentile rank.

What to Expect

Best for

  • Finding where one score stands in a class or a batch
  • Reporting a rank for a value that appears more than once
  • Checking a rank against the counts that produced it

Not ideal for

  • Finding the value at a given percentile, which is the percentile-calculator page
  • A weighted rank, where some observations count more than others
  • A rank among a population you did not paste

What this tool keeps

  • The column as pasted
  • The target value you typed

What may need cleanup

  • A target value with a unit attached, which has to be a bare number
  • Comma-separated input, which has to become one value per line

Common errors

  • Expecting the nearest-rank answer for a tied value
  • Confusing the rank of a value with the value at a percentile

Example use cases

  • Ranking a test score within a class
  • Placing one measurement in a batch of repeats
  • Explaining ties in a percentile calculation

Sample input

The column 2, 4, 4, 4, 5, 5, 7, 9 and the target value 5.

Sample output

Four values below, two equal, and a percentile rank of 62.5 % under the midrank convention.

Who this is for

  • Teachers and students reading a score in context
  • Analysts reporting a rank without a distribution assumption

Frequently asked questions

Why is a tie counted as half?

The midrank convention splits a tie evenly: a value tied with two others is treated as half below and half above. That is the only one of the common conventions that does not favour either end of the tie.

Why is the rank 62.5 % and not 75 %?

Four of the eight values are strictly below 5 and two are equal to it. The strict reading would give 50 % and the at-or-below reading 75 %; the midrank reading gives (4 + 1) ÷ 8 = 62.5 %.

Can I use a value that is not in the column?

Yes. Its rank is the share of values strictly below it, printed with zero equal. That is the ordinary interpolation between two observations.

Does this replace the percentile calculator?

No. That page goes from a percentile to a value, and this one goes from a value to its rank. They are the two directions of the same ordering.

Developer program

Build custom tools for your store

Join the SDK program to create useful ecommerce utilities for your store.