Q1 is the median of the lower half of an ordered data set, so it marks the 25th percentile of the values.
If you’re trying to work out how to find the Q1, the clean routine is simple: sort the data, find the median, split the set into two halves, then find the median of the lower half. That final value is Q1, also called the lower quartile.
Q1 shows where the lowest quarter of the data ends. That makes it useful in classwork, box plots, and five-number summaries. Once you know how to get Q1 by hand, the rest of the quartiles feel much less slippery.
What Q1 Means In Plain Language
Q1 is the point below which 25% of the ordered values sit. If a data set has test scores, daily sales, or response times, Q1 marks the cutoff for the lowest quarter. In standard classroom stats, quartiles split data into four equal parts, with Q1 as the first quartile and Q2 as the median.
Q1 is not the first number in the list, and it is not the average of the whole set. It is the middle point of the lower half once the numbers are lined up from smallest to largest.
Say the ordered data are 2, 4, 6, 8, 10, 12, 14, 16, 18. The median is 10. The lower half is 2, 4, 6, 8. The median of that lower half is halfway between 4 and 6, so Q1 = 5.
How To Find The Q1 In A Sorted Data Set
The hand method stays the same most of the time. The part that trips people up is what to do with the overall median. If your teacher or software does not say otherwise, use the median-of-the-halves method below.
- Put every value in ascending order.
- Find the overall median, which is Q2.
- Split the data into a lower half and an upper half.
- Leave the overall median out if the data count is odd.
- Find the median of the lower half.
- That median is Q1.
Odd Number Of Values
With an odd count, one value sits in the middle. That middle value is Q2, so you set it aside before finding Q1.
Use this set: 3, 5, 7, 8, 12, 13, 15. The median is 8. The lower half is 3, 5, 7. The median of 3, 5, 7 is 5, so Q1 = 5.
Even Number Of Values
With an even count, there is no single middle value. The overall median is the average of the two middle values. Then you split the set into two equal halves and find the median of the lower half.
Use this set: 4, 6, 9, 11, 14, 18, 20, 25. The overall median is halfway between 11 and 14, so Q2 = 12.5. The lower half is 4, 6, 9, 11. The median of that lower half is halfway between 6 and 9, so Q1 = 7.5.
Duplicates, Decimals, And Negative Values
No special rule kicks in. You still sort the values and take medians in the same order-based way.
Use this set: -6, -2, -2, 1, 3, 5, 9, 9, 11. The median is 3. The lower half is -6, -2, -2, 1. The median of that lower half is halfway between -2 and -2, so Q1 = -2.
Worked Q1 Examples You Can Check Line By Line
Most slips happen during the split. One misplaced value, or one extra median in the lower half, can change the answer right away.
Try this set with nine values: 1, 2, 4, 6, 7, 9, 10, 13, 15. The median is 7. Set it aside. The lower half is 1, 2, 4, 6. The median of that lower half is halfway between 2 and 4, so Q1 = 3.
Now try a six-value set: 5, 8, 12, 14, 18, 21. The overall median is halfway between 12 and 14, which is 13. The lower half is 5, 8, 12. The median of 5, 8, 12 is 8, so Q1 = 8.
| Data Situation | What You Do | Q1 Result Pattern |
|---|---|---|
| Unsorted list | Sort from least to greatest before any median step | Q1 comes from the ordered lower half only |
| Odd number of values | Find the middle value and leave it out when splitting halves | Q1 is the median of the values below Q2 |
| Even number of values | Average the two middle values for Q2, then split into equal halves | Q1 is the median of the lower half |
| Lower half has odd length | Take the single middle value of that half | Q1 is one data point from the list |
| Lower half has even length | Average the two middle values of that half | Q1 falls between two data points |
| Repeated values | Leave repeats exactly where they land in order | Q1 may match a repeated number |
| Negative values | Keep the same order rule and median steps | Q1 can be negative with no rule change |
| Decimals | Sort by place value, then use the same median routine | Q1 may be a decimal or the average of decimals |
Why Books, Calculators, And Spreadsheets May Not Match
Quartiles do not use one single calculation rule across every textbook and tool. The broad idea stays the same, but the position rule can shift. Standard classroom texts such as OpenStax’s section on measures of location treat Q1 as the median of the lower half. Microsoft shows that spreadsheet functions can follow a different route. QUARTILE.INC and QUARTILE.EXC can return different first-quartile values for the same list.
That does not mean one answer is wrong. It means you need to match the method your class, test, or spreadsheet expects. In school work, the median-of-the-halves method is common because you can do it by hand and show each step. In software, percentile-based methods can shift Q1 a bit when the data set is small.
If you’re building a box plot, the same issue can show up. NIST’s box plot notes tie quartiles to the interquartile range, which is the distance from Q1 to Q3.
Finding Q1 In Excel, Tests, And Homework
In homework, show the sorted list, the overall median, the two halves, and the median of the lower half. That makes your work easy to check. If your teacher wants a percentile formula instead, the lesson wording will usually show it.
In Excel, the function matters. QUARTILE.INC and QUARTILE.EXC do not always return the same first quartile on small data sets, so use one method from start to finish.
| Method Or Tool | How Q1 Is Found | Best Use |
|---|---|---|
| Median-of-halves by hand | Sort the list, find Q2, split the set, take the lower-half median | Classwork, exams, step-by-step checking |
| Excel QUARTILE.INC | Uses one spreadsheet percentile rule | Sheets built around INC |
| Excel QUARTILE.EXC | Uses a different spreadsheet percentile rule | Sheets built around EXC |
| Graphing calculator or stats app | Depends on the built-in quartile convention | Fast summaries once the method is known |
Common Mistakes That Change Q1
Most wrong answers come from one of these slips:
- Using the raw data before sorting it.
- Forgetting to find the overall median first.
- Leaving the overall median inside both halves when the data count is odd.
- Averaging the wrong two values in the lower half.
- Mixing a hand method with a software method, then expecting the same output.
A quick self-check helps. Once you find Q1, ask whether about one quarter of the ordered values fall below it. If the answer looks off, go back to the split step.
When Q1 Tells You More Than The Average
Q1 is handy when the data are uneven or stretched by a few high values. The mean can get pulled upward by those extremes. Q1 stays tied to position in the ordered list, so it gives you a clean read on the lower end of the data.
That is why Q1 shows up in box plots, five-number summaries, and outlier checks. Once you know Q1 and Q3, you can compute the interquartile range with IQR = Q3 − Q1.
A Clean Way To Check Your Answer
If you want one routine that works well on paper, stick with this:
- Sort the values.
- Find Q2.
- Split the set into lower and upper halves.
- Leave out the overall median when the count is odd.
- Find the median of the lower half.
- Label that value Q1.
Once that rhythm clicks, finding the first quartile stops feeling fussy. You are just finding a median twice: once for the whole set, then once for the lower half.
References & Sources
- OpenStax.“2.3 Measures of the Location of the Data.”Defines quartiles and shows the standard classroom method for finding Q1 from the lower half of an ordered data set.
- Microsoft.“QUARTILE.INC Function.”Shows one Excel quartile method and how the first quartile is returned in spreadsheets.
- National Institute of Standards and Technology.“1.3.3.7. Box Plot.”Links quartiles to box plots and the interquartile range in standard statistical practice.