Percentile Calculator

Basic Calculator

Calculators

Statistics

Enter Data Set

Find Percentile:

display every percentile

Answer:

Get a Widget for this Calculator

Calculator Use

Enter a data set and our percentile calculator finds the percentile you need. We use the same formula as the PERCENTILE() function in Excel, Google Sheets and Apple Numbers.

The percentile calculator can create a table listing each 5th percentile, also showing quartiles and deciles. Click the check box before you click the Calculate button.

Enter data separated by commas or spaces. Or copy and paste lines of data from spreadsheets or text documents. See all allowable formats in the table below.

How to Calculate Percentile

Arrange n number of data points in ascending order: x₁, x₂, x₃, ... x_n
Calculate the rank r for the percentile p you want to find: r = (p/100) * (n - 1) + 1
If r is an integer then the data value at location r, x_r, is the percentile p: p = x_r
If r is not an integer, p is interpolated using ri, the integer part of r, and rf, the fractional part of r:
p = x_ri + r_f * (x_ri+1 - x_ri)

As a single equation for either case you can say

\[ p = x_{ri} + r_{f} * (x_{ri+1} - x_{ri}) \]

since if ri = r and is an integer then r_f does not exist or r_f = 0 and the equation reduces to

\[ p = x_{ri} = x_{r} \]

Acceptable Data Formats

Type
Unit

Your Format Input
Options

Actual Input Processed

Column (New Lines)

42
54
65
47
59
40
53

42, 54, 65, 47, 59, 40, 53

Comma Separated (CSV)

42,
54,
65,
47,
59,
40,
53,

or

42, 54, 65, 47, 59, 40, 53

42, 54, 65, 47, 59, 40, 53

Spaces

42 54
65 47
59 40
53

or

42 54 65 47 59 40 53

42, 54, 65, 47, 59, 40, 53

Mixed Delimiters

42
54 65,,, 47,,59,
40 53

42, 54, 65, 47, 59, 40, 53

References

Wikipedia contributors. "Percentile." Wikipedia, The Free Encyclopedia. Last visited 13 April, 2020.

NIST/SEMATECH e-Handbook of Statistical Methods. "Section 7.2.6.2. Percentiles." Last visited 13 April, 2020.