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
| Inputs | Result |
|---|---|
| Your numbers12, 16, 14, 21, 19 | Q1: 14Median: 16Q3: 19IQR: 5 |
Show 2 more examples
| Your numbers5, 7, 8, 12, 30 | Q1: 7Median: 8Q3: 12IQR: 5 |
| Your numbers100, 110, 120, 125, 140 | Q1: 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
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.