download.fan

Percentile Calculator

Find the value at any percentile of a data set, or the percentile rank of a value. Uses the same method as Excel's PERCENTILE.INC. Free.

90th percentile
91.2
25th (Q1)
68
50th (median)
75
75th (Q3)
85
Count
13

Uses linear interpolation between ranks, the same as Excel's PERCENTILE.INC.

Percentiles explained

A percentile tells you the value below which a given percentage of the data falls. The 90th percentile of test scores is the score that 90% of students scored at or below. For the example scores it's 91.2. Percentile rank goes the other way: a score of 81 is at the 65th percentile. The 25th, 50th and 75th percentiles are the quartiles; the 50th is the median.

How to use it

  1. 1

    Enter your data

    The full set of values.

  2. 2

    Choose the calculation

    Value at a percentile, or percentile of a value.

  3. 3

    Read the result

    With the quartiles for context.

Frequently asked questions

How is the percentile calculated?

Sort the data, find the rank (n − 1) × p, and interpolate between the two nearest values.

What is percentile rank?

The percentage of values below a score, counting half of any equal values.

Is the 50th percentile the average?

No. It's the median, the middle value. The average can be quite different in skewed data.

Is my data stored?

No. Everything stays in your browser.

Math calculators

Related tools