ponderloop.com

Percentile and Quartile Calculator

Separate numbers with commas, spaces, tabs or new lines, or paste a column from a spreadsheet. 1,234 reads as one thousand two hundred thirty-four; write 1, 234 for two numbers.

Linear (inclusive): the p-th percentile sits at position (n − 1) × p counting from 0 in the sorted list, and a fractional position is interpolated between its two neighbours. This is Excel’s PERCENTILE.INC and QUARTILE.INC and NumPy’s default.

12 numbers, linear method

Median 23, quartiles 17.75 and 29.5, IQR 11.75

Five-number summary: 12, 17.75, 23, 29.5, 78.

Count
12
Minimum
12
First quartile (Q1)
17.75
Median (Q2)
23
Third quartile (Q3)
29.5
Maximum
78
Interquartile range (IQR)
11.75
Lower fence (Q1 − 1.5 × IQR)
0.125
Upper fence (Q3 + 1.5 × IQR)
47.125
Outliers
78
90th percentile
34.6
Percentile rank of 26
62.5%
  • Outliers: 1 value above the upper fence.
  • The 90th percentile sits at position 10.9 of 12 in the sorted list (1 + (n − 1) × k ÷ 100), 0.9 of the way from 31 to 35: 31 + 0.9 × (35 − 31) = 34.6.
  • Of 12 values, 7 are below 26 and 1 equals it, so its percentile rank is (7 + ½ × 1) ÷ 12 × 100 = 62.5%.

Box plot

Box plot of the valuesBox plot of 12 values from 12 to 78: the box runs from Q1 17.75 to Q3 29.5 with the median at 23; the whiskers reach 12 and 35; 1 outlier (78), beyond the fences 0.125 and 47.125.203040506070
Box plot: the box spans Q1 to Q3, the line inside is the median, whiskers reach the lowest and highest values within 1.5 × IQR of the box, and dots are outliers.

The same numbers by each method

The median is the same everywhere; the quartiles, fences, outliers and percentiles can differ.

Quartiles, fences and outliers of your numbers by the three methods
MeasureLinearExclusiveMedian of halves
Median (Q2)232323
First quartile (Q1)17.7517.2517.5
Third quartile (Q3)29.530.530
Interquartile range (IQR)11.7513.2512.5
Lower fence0.125−2.625−1.25
Upper fence47.12550.37548.75
Outliers787878
90th percentile34.665.1Not defined