Percentile Calculator

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.

Enter your data (separated by commas, spaces, or new lines):

Enter specific percentile to calculate (optional):

Generate table showing each 5th percentile, plus quartiles and deciles

Percentile	Value	Description

Acceptable Data Formats

Comma Separated: 42, 54, 65, 47, 59, 40, 53
Spaces: 42 54 65 47 59 40 53
New Lines: Enter each value on a new line
Mixed Delimiters: We’ll automatically detect and parse your data

Acceptable Data Formats

Type	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.