Percentile Rank Calculator

A percentile is a cut point in the dataset: the 90th percentile is the value below which 90 percent of the data falls. A percentile rank goes the other direction: you start with a value and ask what percent of the dataset sits at or below it. A test score at the 73rd percentile rank means roughly 73 percent of scores were lower or equal. The percentile slices the data; the percentile rank locates a single value within the data.

Exclusive uses belowCount / N times 100, counting only values that are strictly less than yours. Inclusive uses (belowCount + equalCount) / N times 100, counting values that are less than or equal. Midpoint splits the difference: (belowCount + 0.5 times equalCount) / N times 100, the formula NIST recommends and the one Excel 2010+ uses for PERCENTRANK.INC and its successors. When there are no ties the three methods only disagree at the extremes; the more ties at your value, the wider the spread between them.

The midpoint formula treats ties symmetrically: each tied value contributes half a count above and half below itself, which is the only way to get a percentile rank that is the inverse of the percentile function. It also lands closer to a continuous interpolation of the empirical cumulative distribution, so the same value gives nearly the same answer whether you compute it from rank or from percentile. That is why the NIST Engineering Statistics Handbook and Excel's modern PERCENTRANK.INC default to it, and why this calculator defaults to it too.

Ties (values exactly equal to yours) are the only thing the three methods treat differently. With no ties, all three return the same number. With ties, exclusive ignores them, inclusive counts every one of them as below or equal, and midpoint counts half. The bigger the cluster of identical values at your number, the bigger the gap between methods. If your dataset has many repeated scores (a 1-to-5 survey, integer test scores with a low ceiling), pick midpoint to avoid jumping by a full bucket every time a tie shifts in or out.

Standardized test reports (SAT, GRE, GMAT) show your score and the percentile rank of that score across all test takers. Pediatric growth charts use height and weight percentile ranks to compare a child against the reference population for their age. Salary surveys publish the 25th, 50th, and 75th percentile rank for each role. Sports rankings, college admissions cutoffs, fitness benchmarks, and clinical lab reference ranges all rely on the same idea: a single number is most useful when you know how it stacks up against everyone else.