Calculator Tools

Percentile Calculator

Find any percentile from a data set or look up the percentile rank of a value. Five quantile methods including Excel INC, EXC, and NumPy defaults.

Quick presets

Data set79 chars

Separate values with commas, spaces, semicolons, or newlines. Decimals and negative numbers are supported. Up to 50,000 numbers.

Quantile method

Dataset overview

Count (n)

Min

Max

100

Mean

87.5

Sum

1750

Sorted values

62, 71, 75, 78, 81, 83, 85, 86, 88, 89, 90, 91, 92, 94, 95, 96, 97, 98, 99, 100

What do you want to compute?

Given a percentile (for example 90), find the data value at that rank.

Percentile (0 to 100)

Looking up the 90th percentile.

Result

98.1

The 90th percentile of the data set is 98.1.

Method

Linear (Excel INC, R type 7, NumPy default)

Step

Linear interpolation: position (n - 1) * p = 17.1.

Sorted indexes 17 and 18 (1-based 18 and 19) of n = 20.

Interpolate 98 and 99 with weight 0.1 to get 98.1.

Common percentiles

method = linear

63.71

1st percentile

70.55

5th percentile

P10

74.6

10th percentile

P20

80.4

20th percentile

P25 (Quartile)

82.5

25th percentile

P30

84.4

30th percentile

P40

87.2

40th percentile

P50 (Median)

89.5

50th percentile

P60

91.4

60th percentile

P70

94.3

70th percentile

P75 (Quartile)

95.25

75th percentile

P80

96.2

80th percentile

P90

98.1

90th percentile

P95

99.05

95th percentile

P99

99.81

99th percentile

Plain text summary

Percentile Calculator

Method: Linear (Excel INC, R type 7, NumPy default)
Count (n): 20
Min: 62
Max: 100
Mean: 87.5

Common percentiles
  P1 (1st percentile): 63.71
  P5 (5th percentile): 70.55
  P10 (10th percentile): 74.6
  P20 (20th percentile): 80.4
  P25 (25th percentile): 82.5
  P30 (30th percentile): 84.4
  P40 (40th percentile): 87.2
  P50 (50th percentile): 89.5
  P60 (60th percentile): 91.4
  P70 (70th percentile): 94.3
  P75 (75th percentile): 95.25
  P80 (80th percentile): 96.2
  P90 (90th percentile): 98.1
  P95 (95th percentile): 99.05
  P99 (99th percentile): 99.81

Value of percentile
  P90 = 98.1

Percentile rank of value
  Target: 88
  Inclusive rank (<=): 45%
  Strict rank (<): 40%
  Midpoint rank: 42.5%

How percentiles are computed

Value of a percentile

The numbers are sorted ascending. For the linear method, the position is calculated as (n - 1) * p where p is the percentile divided by 100. The result reads the values at the surrounding ranks and linearly interpolates between them. The exclusive method uses (n + 1) * p instead, which is what Excel PERCENTILE.EXC and R type 6 implement.

Percentile rank of a value

The inclusive rank is (count of values at or below the target) / n. The strict rank is (count of values strictly less than the target) / n. The midpoint rank counts ties at half-weight and is the version used in most US standardized testing contexts.

How to use

Paste or type your numbers into the data set field. Separate values with commas, spaces, semicolons, or newlines. Decimals and negative numbers are supported.
Pick a quantile method. Linear matches NumPy and modern Excel PERCENTILE.INC, Exclusive matches Excel PERCENTILE.EXC, and Lower, Higher, and Nearest each snap to actual sorted values.
Switch the mode: Value of a percentile asks for a number from 0 to 100 and returns the matching value; Percentile rank of a value asks for a target number and returns its rank inside the data.
Read the Result panel for the answer plus the step-by-step interpolation (sorted indexes consulted, weight, and the final arithmetic).
Skim the Common percentiles card for P1 through P99 at the chosen method, then click Copy summary to lift the full plain-text breakdown to the clipboard.

About this tool

Percentile Calculator answers two of the most common stats questions from one data set: what value sits at the Nth percentile, and what percentile rank does a given value have. Paste a list of numbers separated by commas, spaces, semicolons, or newlines (decimals and negatives are supported), pick a quantile method, and the tool sorts the data ascending and runs the math locally in your browser. Five quantile methods are built in so the result matches whatever stats software, exam board, or textbook you are checking against: Linear (R type 7, NumPy default, modern Excel PERCENTILE.INC) uses linear interpolation between sorted ranks; Exclusive (Excel PERCENTILE.EXC, R type 6) excludes the extreme tails and falls back to the linear result on tiny samples; Lower snaps to the lower of the two surrounding sorted values; Higher snaps to the upper sorted value; Nearest picks the nearer sorted value (ties resolve to the lower index, matching NumPy). The Common percentiles table shows P1, P5, P10, P20, P25, P30, P40, P50, P60, P70, P75, P80, P90, P95, and P99 at a glance, with the median and quartiles highlighted. The Percentile rank panel reports three definitions side by side: inclusive rank (count of values at or below the target), strict rank (count of values strictly less), and the midpoint rank that splits ties at half-weight (the version used in most US standardized testing contexts). Each result is accompanied by a step that explains the sorted ranks consulted, the interpolation weight, and the exact arithmetic, so students can copy the working into homework and engineers can sanity-check a p95 latency number against R, Python, or Excel. Useful for grading on a curve, comparing test scores against a cohort, working out service-level latency percentiles, percentile-based growth charts, salary band research, and any classroom statistics exercise. Everything runs locally in your browser; the numbers you enter are never uploaded.

Free to use. Works in your browser. No signup, no login.

Related tools

Percentile Calculator

How to use

About this tool

You may also like

Mean Median Mode Calculator

Standard Deviation Calculator

Z-Score Calculator

Box Plot Calculator

Weighted Average Calculator

Probability Calculator