How to find them
There is no formula to put numbers into, only a procedure. This page uses the one taught in school, the median of each half:
- Sort the values.
- Q₂ is the median.
- Q₁, the lower quartile, is the median of the values below Q₂.
- Q₃, the upper quartile, is the median of the values above Q₂.
With an odd number of values, the middle value is Q₂ itself and belongs to neither half.
Worked example
Eight values. 2, 4, 4, 4, 5, 5, 7, 9 is already sorted. The median is (4 + 5)/2 = 4.5. The lower half is 2, 4, 4, 4, with median Q₁ = 4. The upper half is 5, 5, 7, 9, with median (5 + 7)/2 = Q₃ = 6.
Why a spreadsheet gives another answer
Type the same list into a spreadsheet and ask for QUARTILE(…; 3): the answer is 5.5, not 6.
Spreadsheets interpolate between neighbouring values instead of taking the median of a half. Neither
number is a mistake — there are several definitions of a quartile in use — but they are different
methods, and on a test the one that counts is the one the course teaches.
| Method | Q₁ | Q₃ |
|---|---|---|
| Median of each half (this page, TI calculators) | 4 | 6 |
Spreadsheet QUARTILE / QUARTILE.INC |
4 | 5.5 |
A second example: an odd count
Seven values. 3, 5, 6, 8, 10, 12, 15. The median is the fourth value, 8. It is left out of both halves: the lower half is 3, 5, 6, so Q₁ = 5, and the upper half is 10, 12, 15, so Q₃ = 12.
Counting the 8 in both halves gives 3, 5, 6, 8 and 8, 10, 12, 15, and the quartiles 5.5 and 11 — plausible, and wrong by this method.
Where next
The distance from Q₁ to Q₃ is the interquartile range, and the five numbers min, Q₁, Q₂, Q₃ and max are what a box plot draws.
Common mistakes
- Not sorting first. The median of an unsorted half is just whatever value happens to sit there.
- Counting the median twice with an odd count. It belongs to neither half.
- Mixing methods. A spreadsheet, a calculator and a textbook can give three answers for one list. Say which method you used.
- Reading a quartile as a quarter of the values. Q₁ is a value, not a count: roughly a quarter of the values lie at or below it.
Common questions
Is Q₂ the same as the median?
Yes. The middle quartile is the median by definition, whichever method is used for the other two.
Why do different calculators give different quartiles?
Because there is no single agreed definition. Statistics software offers about nine. They differ little on
long lists and can differ by half a step or more on short ones.
How are quartiles related to percentiles?
Q₁ is the 25th percentile, Q₂ the 50th and Q₃ the 75th. Percentiles divide the list into a hundred
parts instead of four, and are found by a position rule the
percentiles page shows.

