Online Calculators

# Percentile Calculator

Percentile Calculator
display every percentile

## 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

1. Arrange n number of data points in ascending order: x1, x2, x3, ... xn
2. Calculate the rank r for the percentile p you want to find: r = (p/100) * (n - 1) + 1
3. If r is an integer then the data value at location r, xr, is the percentile p: p = xr
4. If r is not an integer, p is interpolated using ri, the integer part of r, and rf, the fractional part of r:
p = xri + rf * (xri+1 - xri)

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 rf does not exist or rf = 0 and the equation reduces to

$p = x_{ri} = x_{r}$

Acceptable Data Formats
Type
Unit
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.

Cite this content, page or calculator as:

Furey, Edward "Percentile Calculator" at https://www.calculatorsoup.com/calculators/statistics/percentile-calculator.php from CalculatorSoup, https://www.calculatorsoup.com - Online Calculators

Last updated: September 19, 2023