Overview

The first quartile, Q1, is the value below which 25% of the data falls. It marks the bottom of a box plot's box.

Enter your values in any order. You also get the median, Q3 and the IQR.

Worked examples

InputsResult
Your numbers12, 16, 14, 21, 19Q1: 14Median: 16Q3: 19IQR: 5
Show 2 more examples
Your numbers5, 7, 8, 12, 30Q1: 7Median: 8Q3: 12IQR: 5
Your numbers100, 110, 120, 125, 140Q1: 110Median: 120Q3: 125IQR: 15

How it works

Sort the values and find position 0.25 × (n − 1), counting from zero, interpolating between neighbors if needed. With five values, Q1 is exactly the second value. Quartiles use linear interpolation, the method in Excel's QUARTILE.INC, so other tools may give slightly different values for small data sets.

The formula

Position of Q1 = 0.25 × (n − 1)

Practical tips

  • For 12, 14, 16, 19 and 21, Q1 is 14.
  • Q1 is the same as the 25th percentile.
  • The lower fence for outliers is Q1 − 1.5 × IQR.

Frequently asked questions

Is Q1 the median of the lower half?

In some methods, yes. They can give different answers for small data sets.

Why does Excel give a different answer?

QUARTILE.EXC uses a different method from QUARTILE.INC.

What is Q1 used for?

Describing spread, box plots and finding outliers.