Boneyard Tools

Percentile Calculator

Paste a set of numbers and this tool answers two questions at once: what value sits at a percentile you choose, and what percentile rank a specific value holds. Percentiles use linear interpolation by default, matching Excel PERCENTILE.INC and the NumPy default, with a nearest rank option if you prefer no interpolation. It sorts your data for you and works fully in the browser.

How to calculate a percentile

  1. Type or paste your numbers into the Data set box, separated by commas, spaces or new lines.
  2. Set the Percentile field from 0 to 100 to read the value at that rank.
  3. Enter a number in Value to rank to see where it falls in the data.
  4. Pick a Method: Linear (Excel INC) for interpolation or Nearest rank for no blending.
  5. Read the value at your percentile, the rank of your value and the count, then Copy result.

Examples

Median and rank in 1 to 10

1, 2, 3, 4, 5, 6, 7, 8, 9, 10; percentile 50; value 7
Value at 50th = 5.5, rank of 7 = 70%, n = 10

90th percentile, linear vs nearest

1, 2, 3, 4, 5, 6, 7, 8, 9, 10; percentile 90
Linear = 9.1, Nearest rank = 9

Percentile rank of a test score

55, 60, 70, 80, 85, 90, 95, 100; value 85
Rank of 85 = 62.5%

Frequently asked questions

What is a percentile?

A percentile is the value below which a given share of the data falls. The 90th percentile is the value that 90 percent of the data sits at or below, which makes percentiles handy for spotting the top or bottom slice of a group.

What is a percentile rank?

The percentile rank of a value is the percentage of the data that is at or below it, using the cumulative definition. In this tool, rank equals 100 times the count of values less than or equal to your number, divided by the total count.

Which percentile method does this use?

By default it uses linear interpolation between the two closest ranks, matching Excel PERCENTILE.INC and NumPy's default. The target position is (n minus 1) times p over 100, and the result blends the two straddling values.

How does the nearest rank method differ?

Nearest rank skips interpolation and returns an actual value from your data. It rounds the same target position to the closest whole index, so on 1 to 10 the 90th percentile returns 9 instead of the interpolated 9.1.

Is the 50th percentile the same as the median?

With the linear method, yes. The 50th percentile lands exactly on the middle of the sorted data, which for an even count is the average of the two central values, such as 5.5 for the numbers 1 to 10.

Do I need to sort my data first?

No. The calculator sorts a copy of your numbers before computing anything, so the order you paste them in does not change the result.

How should I separate the numbers?

Use commas, spaces, tabs or new lines in any mix. Pasting a column straight from a spreadsheet works, and empty gaps are ignored. Any token that is not a finite number stops the calculation with a message naming it.

Can percentile ranks reach 0 or 100?

Yes. A value at or above your maximum scores 100 percent because every number is at or below it, and a value below the minimum scores 0 percent. Duplicates count toward the at or below tally.

Is my data kept private?

Yes. All parsing and math run locally in your browser, so the numbers you paste are never sent to a server.

Learn more

  • Percentile methods explained

    Linear interpolation versus nearest rank, why tools disagree on the same data, and how to read percentile rank the cumulative way.

Related tools