Percentile Calculator Find the value at any percentile, plus the quartiles Q1, Q2 and Q3

Paste your numbers, choose a percentile, and get the value at that rank using the same linear-interpolation method as Excel's PERCENTILE.INC. Quartiles are shown automatically.

between 0 and 100

The 90th percentile is the value below which 90% of your data falls.

90th percentile
—
value at this rank
Q1 (25th)
—
Q2 (median)
—
Q3 (75th)
—
Minimum
—
Maximum
—

Do this in Excel or Google Sheets

With your numbers in A1:A10:

StatisticFormula
90th percentile=PERCENTILE.INC(A1:A10, 0.9)
Q1 (25th)=QUARTILE.INC(A1:A10, 1)
Q2 (median)=MEDIAN(A1:A10)
Q3 (75th)=QUARTILE.INC(A1:A10, 3)
Rank of a value=PERCENTRANK.INC(A1:A10, x)

Percentiles power performance benchmarks and dashboards in Excel and Power BI. My courses show you how to build them properly.

Learn Excel & Power BI with my courses →

What a percentile means

A percentile marks the value below which a given share of your data falls. If a test score is at the 90th percentile, 90% of scores are lower. Quartiles are just three well-known percentiles: Q1 at 25%, Q2 (the median) at 50%, and Q3 at 75%. The gap between Q1 and Q3, the interquartile range, describes the spread of the middle half of the data.

How this is calculated

This tool uses linear interpolation between the two closest ranked values — the inclusive method that matches Excel's PERCENTILE.INC and QUARTILE.INC. Results can therefore differ slightly from calculators that use the exclusive method.

Frequently asked questions

Why doesn't the percentile equal one of my numbers?

Because it interpolates between values when the exact rank falls between two data points — the same behaviour as Excel's inclusive method.

What percentile is the median?

The 50th percentile is the median, shown here as Q2.

Does it handle decimals and negatives?

Yes. Mix whole numbers, decimals and negatives freely; non-numeric entries are ignored.