# Percentile 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_{1}, x_{2}, x_{3}, ... 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*= 0 and the equation reduces to

_{f}

Unit

Options

54

65

47

59

40

53

54,

65,

47,

59,

40,

53,

or

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

65 47

59 40

53

or

42 54 65 47 59 40 53

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.