Percentile & Quantile Calculator
Compute quartiles, the median, and arbitrary percentiles of a dataset, plus the percentile rank of any value (what percent of the data falls at or below it). Three interpolation methods are supported. Everything runs locally in your browser.
Data
Quartiles & summary
Percentile value (p-th percentile)
Percentile rank of a value
A percentile is the value below which a given percentage of the sorted data falls. Quartiles are the 25th, 50th (median), and 75th percentiles; the IQR is Q3 − Q1. The three methods differ in how they interpolate when the desired rank lands between two data points: inclusive (R-7, the NumPy/R default, PERCENTILE.INC) maps p∈[0,1] onto ranks 1..n so p=0 is the min and p=100 the max; exclusive (R-6, PERCENTILE.EXC) maps p onto ranks 0..n+1 and is undefined for extreme p (errors near 0%/100% for small samples); nearest rank rounds up to the nearest whole rank (no interpolation). The percentile rank of a value is (# of values ≤ x) / n × 100. Pairs with the Statistics, Histogram, and Frequency tools. Everything runs locally — nothing leaves your browser.