Percentile Calculator – Calculate Percentiles, Ranks & Data Positions
Percentile Calculator
Do you need to find a specific data point in a large set of numbers? Our simple online percentile calculator instantly finds the exact percentile you need from any data set.
A percentile is a statistical measure that tells you the value below which a certain percentage of the data falls. For example, if your test result is in the 85th percentile, this means that you performed better than 85 percent of the people who took the test.
Simply enter your data, and our tool will do the work for you. We use the exact same calculation method as the standard QUANTILE (PERCENTILE) function found in programs like Excel, Google Sheets, and Apple Numbers.
If you need a more detailed breakdown, this percentile calculator can generate a complete table listing every 5th percentile. It also shows you the quartiles and deciles for your data. Just click the checkbox before clicking the Calculate button.
You can enter your data separated by commas or spaces. If you have a long list of numbers, you can easily copy and paste rows of data directly from your spreadsheets or text documents.
How to calculate the percentile
When people search for how to calculate a percentile manually, the mathematical formulas can look very confusing. Here is the step-by-step breakdown in simple English:
- First, arrange all your numbers in order from lowest to highest.
- Next, you need to find the "rank" (the exact position in your list) for the percentile you are looking for. To do this, divide your target percentile by 100. Multiply this result by the total number of your items minus one. Finally, add one to this sum.
- If your final rank is a perfect integer, simply count down your list to that exact position. That number is your percentile.
- If your rank has a decimal (like 3.75), you need to find the value between the two closest numbers in your list. To do this, find the difference between these two numbers and multiply it by the decimal part of your rank.
Let's look at a clear example of how to calculate the 75th percentile for a small dataset.
Imagine your dataset consists of 6 numbers: 15, 20, 25, 30, 35, and 40. They are already sorted in ascending order. Your total count is 6. You want to find the 75th percentile.
Step 1: Find the rank using the math steps described above.
Step 2:
Step 3:
Since 4.75 is not an integer, we need to look at the 4th number (30) and the 5th number (35) in our list.
The decimal part of our rank is 0.75. The difference between our 5th and 4th number is 5 (because 35 - 30 = 5). So we add 75% of this difference to our 4th number.
For this specific dataset, the 75th percentile is 33.75.
Allowed data formats
Here are the different ways you can enter your information into the calculator.
| Type | Your Format Input Options | Actually Processed Input |
|---|---|---|
| Column (new lines) | 10 20 30 40 50 |
10, 20, 30, 40, 50 |
| Comma-separated (CSV) | 10, 20, 30, 40, 50 |
10, 20, 30, 40, 50 |
| Spaces | 10 20 30 40 50 |
10, 20, 30, 40, 50 |
| Mixed delimiters | 10 20 30,,, 40,,50 |
10, 20, 30, 40, 50 |
Last updated: August 16, 2026