Percentile Calculator

What Is a Percentile?

A percentile is a value below which a given percentage of the data falls. If your test score sits at the 90th percentile, it means you scored higher than about 90% of everyone else who took the test. Percentiles turn a raw number — which means little on its own — into a statement about relative standing: where you sit compared to the rest of the group. That’s why they show up everywhere, from standardized exams and salary surveys to your baby’s growth chart at the pediatrician’s office.

The key idea is that a percentile answers the question “where do I stand?” rather than “how much did I get?” A score of 650 on the SAT Math section tells you nothing by itself, but knowing it corresponds to roughly the 79th percentile instantly tells you it outranked about four out of five test-takers. This calculator handles both directions of that question: it can find the value sitting at any percentile you choose, or tell you the percentile rank of any value you enter.

Percentile vs. Percentile Rank: What’s the Difference?

These two terms get mixed up constantly, but they point in opposite directions, and this calculator does both:

In everyday language, when a report says “you scored in the 85th percentile,” that 85 is your percentile rank — the share of people you outperformed. Use the two tabs at the top of the calculator to switch between finding a value and finding a rank.

Percentile vs. percentage

A percentile is also not the same as a percentage. A percentage is a raw proportion of a total — getting 90% on a quiz means you answered 90% of the questions correctly. A percentile is about your position relative to others — being in the 90th percentile means you outscored 90% of the group, whether the test was easy or brutally hard. You can score 65% on a punishing exam and still land in the 90th percentile if almost everyone else scored lower.

How to Calculate a Percentile

There are two distinct calculations, depending on which direction you’re going.

Finding the value at a given percentile

To find the value at the Pth percentile using the standard linear-interpolation method (the one Excel and NumPy use), sort the data and locate the rank position:

position = (P / 100) × (n − 1)

If that position is a whole number, the percentile is simply the value at that spot in the sorted list. If it falls between two positions — say between the 3rd and 4th values — you interpolate: take the lower value plus the fractional part times the gap to the next value. The calculator shows this interpolation explicitly in its steps.

Finding the percentile rank of a value

To find what percentile rank a particular value holds, use the widely accepted midpoint (NIST) formula:

Percentile rank = (B + 0.5 × E) / N × 100

Here B is the count of values strictly below your target, E is the count of values equal to it, and N is the total number of values. The “0.5 × E” term is what correctly handles ties — a detail many quick calculations get wrong, which inflates the rank.

Which Percentile Method Should You Use?

Just like quartiles, percentiles have more than one accepted calculation method, and they can give slightly different answers on the same data. This calculator offers the three most common for finding a value:

For most purposes, linear interpolation is the right default — it’s what spreadsheets and data-science tools use out of the box. Choose nearest rank when you need an answer that’s guaranteed to be an actual value from your dataset. Choose exclusive when you’re matching a result from Excel’s PERCENTILE.EXC function. If your answer differs from another tool, switching the method will usually reconcile it.

What Does Your Percentile Actually Mean?

A percentile is a ranking, not a grade — and whether a high number is good or bad depends entirely on context.

Test scores and exams

For SAT, GRE, GMAT, and most standardized tests, a higher percentile is better: the 90th percentile means you outscored 90% of test-takers. Colleges often care more about your percentile than your raw score, because it shows how you stack up against everyone else who sat the same exam.

Baby and child growth charts

On a WHO or CDC growth chart, a percentile is simply a comparison, not a report card. A baby at the 40th percentile for weight is heavier than about 40% of babies the same age and sex — nothing more. The 50th percentile is the median, not a warning sign, and a baby who has tracked steadily along the 10th percentile since birth is usually perfectly healthy. Pediatricians care far more about a consistent growth curve than the specific number; a sudden drop from the 75th to the 15th percentile draws more attention than a stable low percentile ever would.

Salary, income, and health markers

For salary, a job paying at the 75th percentile means only 25% of similar roles pay more — clearly good news for the earner. But context can flip the meaning entirely: a high percentile for LDL cholesterol, blood pressure, or a golf score is the opposite of good. In those cases, a lower percentile is the healthier or better result. Always ask whether the thing being measured is something you want more or less of.

Common Percentile Mistakes to Avoid

• Treating a percentile like a percentage. The 90th percentile does not mean you got 90% of the questions right — it means you outscored 90% of people.
• Assuming the 50th percentile is bad. The 50th percentile is the median, the exact middle. Half of everyone is below it by definition; it’s not a red flag.
• Ignoring ties. When several values are equal, the correct percentile rank uses the “below + 0.5 × equal” formula. Counting only the values below inflates the rank.
• Comparing percentiles across different tests or reference groups. A percentile only means something relative to its specific group — the 90th percentile nationally is not the same as the 90th in your school.
• Forgetting that small samples are noisy. In a tiny dataset, adding or removing one value can swing a percentile by several points.

Percentiles and Quartiles

Quartiles are just three specific percentiles: the first quartile (Q1) is the 25th percentile, the median (Q2) is the 50th, and the third quartile (Q3) is the 75th. Percentiles are simply the more granular version, letting you pinpoint any position from 0 to 100 rather than only the quarters. If you specifically need Q1, Q2, and Q3, our Quartile Calculator shows them with the full method, and the Interquartile Range Calculator uses those same percentiles to measure spread and flag outliers.

Frequently Asked Questions

Methodology & formulas used

This calculator handles two questions with documented formulas, reviewed July 2026. All computation runs locally in your browser; your data is never uploaded.

• Value at a percentile — Linear (Excel PERCENTILE.INC / NumPy): position = (P/100)(n − 1), 0-indexed; interpolate linearly between adjacent sorted values when the position is fractional.
• Value at a percentile — Nearest rank: k = ⌈(P/100) × n⌉, 1-indexed; returns the value at that rank, always an existing data point.
• Value at a percentile — Exclusive (Excel PERCENTILE.EXC): position = (P/100)(n + 1); undefined when the position falls below 1 or at/above n.
• Percentile rank of a value (NIST midpoint): (B + 0.5 × E) / N × 100, where B is the count strictly below, E the count equal, and N the total.
• Median & range are shown for context in both modes.

Different tools adopt different conventions, so results can vary slightly between methods, particularly for small samples. Results are rounded for display but computed at full precision.

References

1. NIST/SEMATECH e-Handbook of Statistical Methods. Percentiles. itl.nist.gov
2. Wikipedia. Percentile — methods and formulas. en.wikipedia.org
3. Wikipedia. Percentile rank. en.wikipedia.org

Related Statistics Calculators