Percentiles show up everywhere from standardized test scores to salary bands to growth charts, but two related questions get mixed up constantly: "what's the value at the 90th percentile?" and "what percentile is my value at?" This calculator answers both, and lets you see exactly how the interpolation method you choose changes the first answer.

Value at a percentile vs. percentile rank

These are inverse questions. Value at percentile starts with a percentage (like 90) and returns a data value — "what score do I need to be in the top 10%?" Percentile rank starts with a value and returns a percentage — "how does my score of 82 compare to everyone else's?" It's easy to conflate the two because both use the word "percentile," but they run in opposite directions through the same sorted dataset.

Why interpolation methods disagree

A percentile rarely lands exactly on a data point — the 90th percentile of 20 values sits between the 18th and 19th sorted values, not on either one. Linear interpolation (the default here, matching Excel's PERCENTILE.INC) blends between those two points proportionally. Nearest rank instead rounds to whichever actual data point is closest, so it never reports a value that isn't really in your dataset. The two methods converge as your sample size grows and diverge most on small samples or datasets with a lot of repeated values — which is exactly what the Method tab's side-by-side comparison is built to show.

Handling ties in percentile rank

When several data points share the same value, a naive percentile-rank formula has to decide whether ties count as "below" or "above" the value being ranked. This calculator uses the standard mean-rank convention: ties are split evenly, counting half of the tied group as below and half as above. It's a small detail, but it keeps the reported rank fair rather than systematically inflating or deflating scores that happen to share a value with others in the set.