FLXCode Percentile Calculator

FLXCode apps

Appearance

Percentile Calculator

Paste your numbers, then find the value at any percentile or the percentile of any value. The method is stated.

Paste a column or row from Excel, Google Sheets or a CSV file, or type numbers separated by spaces, commas or new lines. A header word is ignored.

Example Percentile

74.5 Value at the 75th percentile

Read 12 numbers.

Results
Percentile (p)75%
Methodinclusive (Excel PERCENTILE.INC)
Rank in the sorted list9.25
Count (n)12
Smallest41
Largest92
In Excel or Sheets=PERCENTILE.INC(A1:A12, 0.75)

The steps, with your numbers

Sorted: 41, 47, 52, …, 85, 92

Rank = p × (n − 1) + 1 = 0.75 × 11 + 1 = 9.25

Value = x9 + 0.25 × (x10 − x9) = 73 + 0.25 × (79 − 73) = 74.5

No ads. No account. Nothing you type or record is uploaded. We count page events with a daily code. Check it.

Problem or idea? Email us

Quick start

  1. Paste the numbers. They are sorted for you.
  2. Value at a percentile: type the percentile, such as 90, and pick a method.
  3. Percentile of a value: type the value and read its rank.

The three methods

MethodRank in the sorted listExcel1 to 10: 25th50th90th
Inclusivep × (n − 1) + 1PERCENTILE.INC3.255.59.1
Exclusivep × (n + 1)PERCENTILE.EXC2.755.59.9
Nearest rank⌈p × n⌉none359

When the rank is not a whole number, the value is interpolated between the two numbers on either side. For the 90th percentile of 1 to 10 the inclusive rank is 9.1, one tenth of the way from 9 to 10, so the answer is 9.1.

Worked examples

The list is 41, 47, 52, 55, 58, 61, 64, 70, 73, 79, 85, 92, twelve exam scores.

QuestionAnswer
75th percentile, inclusive74.5
Percentile rank of 6454.17% (6 below, 1 equal)
Percentile rank of 9091.67% (11 below)
Percentile rank of 70 in 70, 70, 80, 9025%

For the exact cut-offs of a quarter at a time, the quartile calculator adds the interquartile range and a box plot. If your data are close to normal, you can get a percentile from a z-score with the z-score calculator.

Numbers this uses

Every constant the tool uses is listed here with its source. Where a number varies, you can edit it in the tool.

  • Percentile rank is (L + 0.5 × S) / n × 100. L is the count below, S the count equal. The percent below and at or below are shown too.
  • Default method is inclusive. Matches PERCENTILE.INC in Excel and PERCENTILE in Google Sheets.
  • Limit is 100,000 numbers. For speed in the browser.

Common mistakes

  • Mixing up percentile and percent. A score of 80% can be at the 40th percentile.
  • Typing 0.9 for the 90th percentile in the tool. The tool takes 0 to 100. Spreadsheet formulas take 0 to 1.
  • Comparing percentiles from different methods.

Nothing you type or paste is uploaded. We count events without cookies (details).

FAQ

What is a percentile?

The pth percentile is a value with p% of the data at or below it. The 50th percentile is the median. If a child is at the 75th percentile for height, 75% of children of that age are shorter or equal.

How do I find the value at a percentile?

Pick Value at a percentile, paste the numbers, type the percentile and choose a method. The 75th percentile of 41, 47, 52, 55, 58, 61, 64, 70, 73, 79, 85, 92 is 74.5 by the inclusive method. The steps show the rank and the interpolation.

Why do different calculators give different percentiles?

There is no single definition. Excel PERCENTILE.INC counts the first and last values as the 0th and 100th percentile, PERCENTILE.EXC leaves room beyond them, and nearest rank always picks a value from the list. For 1 to 10 the 90th percentile is 9.1, 9.9 or 9 depending on the method.

What is a percentile rank?

It runs the other way: given a value, what percent of the data is below it. The value 64 in the example list has 6 values below it out of 12, so its percentile rank is 54.17%. The tool counts half of the values that tie with it.

What happens with tied values?

Ties count half. In 70, 70, 80, 90 the value 70 has none below it and two equal, so the rank is (0 + 0.5 × 2) / 4 = 25%. The table also shows the percent strictly below and the percent at or below, so you can pick the definition your course uses.

Why does the exclusive method say my percentile is out of range?

The exclusive method puts the first value above 0 and the last below 100. With n values it only works from 1 / (n + 1) to n / (n + 1). For 10 values that is 9.09% to 90.91%. Use the inclusive method, or add more data.

How do I do this in Excel or Google Sheets?

=PERCENTILE.INC(A1:A10, 0.9) and =PERCENTILE.EXC(A1:A10, 0.9) for the value, and =PERCENTRANK.INC(A1:A10, x) for the rank as a fraction. Remember the percentile is a fraction in the formula, 0.9 and not 90. The tool shows the matching formula.

Is the data I paste kept?

No. It stays in your browser and is not stored or sent. We only count which method and mode you used.

More from FLXCode

Share Percentile Calculator