Percentile Calculator for Salary Benchmarking
Percentile Calculator
Ready to find out your percentile? Just enter your data, and our percentile calculator will do the work for you. We use the same formula you’ll find in Excel, Google Sheets, and Apple Numbers.
Want a detailed breakdown? Our calculator can create a table showing each 5th percentile, as well as quartiles and deciles. Just tick the checkbox before hitting the Calculate button to see this feature.
You can input your data separated by commas or spaces, or copy and paste from spreadsheets or text documents. Check out the table below for all the formats you can use
Percentile Calculator
How to Calculate Percentile
Sort your data: Arrange your data points in ascending order: x1, x2, x3, … xn.
Find the rank (r) for the percentile (p) you want:
r=(p100)×(n−1)+1r = \left(\frac{p}{100}\right) \times (n – 1) + 1
If r is an integer: The percentile value is the data point at position r, so p=xrp = x_r.
If r is not an integer: You’ll need to interpolate between the integer part of r (ri) and the fractional part (rf):
p=xri+rf×(xri+1−xri)p = x_{ri} + rf \times (x_{ri + 1} – x_{ri})
To put it simply:
p=xri+rf×(xri+1−xri)p = x_{ri} + rf \times (x_{ri + 1} – x_{ri})
If ri is an integer: If ri equals r and is an integer, then rf doesn’t matter or is 0. The formula simplifies to:
p=xrip = x_{ri}
Acceptable Data Formats
Column (New Lines):
23
67
45
89
12
54
78
(Processed as: 23, 67, 45, 89, 12, 54, 78)Comma Separated (CSV):
23,
67,
45,
89,
12,
54,
78,
(or: 23, 67, 45, 89, 12, 54, 78)
(Processed as: 23, 67, 45, 89, 12, 54, 78)Spaces:
23 67
45 89
12 54
78
(or: 23 67 45 89 12 54 78)
(Processed as: 23, 67, 45, 89, 12, 54, 78)Mixed Delimiters:
23
67 45,,, 89,,12,
54 78
(Processed as: 23, 67, 45, 89, 12, 54, 78)
