Quartile Calculator
The quartiles of the scores 62, 70, 74, 79, 85, 88 and 91 are Q1 72, the median 79 and Q3 86.5 by interpolation. That makes the interquartile range 14.5 points. Paste a list and the calculator returns the three cut points, the range between Q1 and Q3, and any value outside the 1.5 fence.
| Count | |
| Sorted data | |
| Minimum | |
| Q1 | |
| Median (Q2) | |
| Q3 | |
| Maximum | |
| Interquartile range (Q3 - Q1) | |
| Outliers | |
The calculator sorts your numbers, finds Q1, Q2 and Q3 with the same interpolation rule that Excel uses for QUARTILE.INC, then builds interquartile fences that flag any value outside them. All numbers are processed in your browser, and nothing is uploaded or stored.
Paste your numbers and get Q1, Q2, Q3, the interquartile range and outlier fences, using the same interpolation rule as Excel QUARTILE.INC.
Key takeaways
- Quartiles split sorted data at the 25, 50 and 75 percent marks, so Q2 is the median
- Positions follow 1 + (n - 1) x p, and a fractional position is interpolated between two scores
- Seven scores from 62 to 91 give Q1 72, median 79 and Q3 86.5, so the IQR is 14.5
- The 1.5 x IQR rule puts fences at 4 - 4.875 = -0.875 and 7.25 + 4.875 = 12.125 for the list 2, 4, 4, 5, 6, 7, 8, 30
- Textbook methods and Excel can differ by a point or two on small lists, so match the method before comparing
On this page
What quartiles measure
Quartiles cut an ordered list into four groups of equal size. Q1 sits at the 25 percent mark, Q2 is the median at 50 percent, and Q3 sits at 75 percent. For the scores 62, 70, 74, 79, 85, 88 and 91 the four groups hold one or two scores each, and the cut points land at 72, 79 and 86.5. Those three numbers describe the shape of the data without a single average.
That is the appeal. An average salary, home price or test score tells you the middle of a distribution and nothing about the spread around it. Compare two school districts with a median of 78: in one, half the scores fall between 74 and 82, while in the other half fall between 58 and 95. Same median, completely different classrooms. The quartile spread exposes the difference, and a box plot draws it in one line.
Quartiles also survive extremes. Add a single score of 300 to a class of thirty, and the mean jumps by several points while the median barely moves and the quartile cut points shift by less than one rank. For pay tables, house prices and test results, that resistance to one wild value is the reason quartiles appear in published statistics while means get footnoted.
How this calculator finds the quartiles
The method is linear interpolation between the two scores that bracket each cut point, the same rule spreadsheets use when you call QUARTILE.INC or PERCENTILE.INC:
position = 1 + (n - 1) x p
Here n is the count of values and p is 0.25, 0.5 or 0.75. A whole number position lands exactly on a score. A fractional position sits partway between two scores, and the calculator takes that fraction of the gap.
| Count n | Q1 position | Median position | Q3 position |
|---|---|---|---|
| 7 values | 1 + 6 x 0.25 = 2.5 | 1 + 6 x 0.5 = 4 | 1 + 6 x 0.75 = 5.5 |
| 8 values | 1 + 7 x 0.25 = 2.75 | 1 + 7 x 0.5 = 4.5 | 1 + 7 x 0.75 = 6.25 |
| 10 values | 1 + 9 x 0.25 = 3.25 | 1 + 9 x 0.5 = 5.5 | 1 + 9 x 0.75 = 7.75 |
| 12 values | 1 + 11 x 0.25 = 3.75 | 1 + 11 x 0.5 = 6.5 | 1 + 11 x 0.75 = 9.25 |
Sorting happens first and is easy to forget by hand. If your list is unsorted the ranks above point at the wrong scores entirely, which is the most common source of a wrong quartile on a spreadsheet someone built from scratch.
A worked example with 7 scores
Seven test scores, already sorted: 62, 70, 74, 79, 85, 88, 91. With n = 7 each cut point sits at a half position, so every quartile is the midpoint of two scores.
| Measure | Position | Scores used | Result |
|---|---|---|---|
| Minimum | 1 | 62 | 62 |
| Q1 | 2.5 | 70 and 74 | 72 |
| Median (Q2) | 4 | 79 | 79 |
| Q3 | 5.5 | 85 and 88 | 86.5 |
| Maximum | 7 | 91 | 91 |
Read the Q1 row in full: the position is 2.5, which sits halfway between the second score (70) and the third (74), so it sits halfway between 70 and 74, which is 72. The Q3 row works the same way between 85 and 88: 85 and 88, so Q3 is 86.5.
The interquartile range is the distance between them: 86.5 - 72 = 14.5 points. Half of the class sits in that 14.5 point band, a tighter picture than the full 29 point spread from 62 to 91 suggests.
Even counts and fractional cut points
With an even count no cut point lands on a single score, so both the median and the quartiles come from interpolation. Take ten daily deliveries: 3, 5, 7, 8, 9, 12, 14, 15, 16, 20.
| Measure | Position | Computation | Result |
|---|---|---|---|
| Q1 | 3.25 | 7.25, a quarter of the way up from 7 to 8 | 7.25 |
| Median | 5.5 | 10.5, the average of the two middle scores 9 and 12 | 10.5 |
| Q3 | 7.75 | 14.75, three quarters of the way from 14 to 15 | 14.75 |
The median sits between the fifth and sixth values, which is the familiar average of the two middle scores. Q1 sits from the third to the fourth value, and Q3 three quarters of the way from the seventh to the eighth. Interpolation means a quartile can be a number that never appears in the data, 7.25 deliveries in this case, and that is expected rather than an error.
The interquartile range here is 14.75 - 7.25 = 7.5 deliveries. The mean of the same ten days is 10.9, slightly above the median because the two largest days pull it up.
Fences that flag outliers
The interquartile range doubles as an outlier test. Multiply it by 1.5 and place a fence that far below Q1 and that far above Q3. Anything outside the fences is worth a second look.
| Step | Computation | Result |
|---|---|---|
| Quartiles for 2, 4, 4, 5, 6, 7, 8, 30 | Q1 4, median 5.5, Q3 7.25 | as listed |
| Interquartile range | 7.25 - 4 = 3.25 | 3.25 |
| Fence distance | 1.5 x 3.25 = 4.875 | 4.875 |
| Lower fence | 4 - 4.875 = -0.875 | -0.875 |
| Upper fence | 7.25 + 4.875 = 12.125 | 12.125 |
The value 30 sits far above the upper fence and gets flagged, while 2 sits above the lower fence of -0.875 and stays in. A count of 2 is low but not unusual against this spread, which is exactly what the 1.5 rule is designed to separate: the extreme value that deserves a check from the merely small one.
The rule is a convention, not a law. Tukey's 1.5 multiplier flags moderate outliers, and 3.0 marks points that are extreme. Neither number knows your subject matter, so a flagged delivery day or a flagged lab result means start asking questions, not delete the row.
Quartiles, percentiles and competing methods
Quartiles are percentiles with fixed names: Q1 is the 25th percentile, Q2 the 50th and Q3 the 75th. Any percentile uses the same position rule with p set to the percentile over 100, so the 90th percentile of the delivery list above sits at position 9.1, one tenth of the way past the ninth value.
Different software answers the same question with slightly different numbers because the cut point can be defined several ways:
| Method | Q1 for the 7 scores | Q3 for the 7 scores | Where you meet it |
|---|---|---|---|
| Linear interpolation on position 1 + (n - 1) x p | 72 | 86.5 | Excel QUARTILE.INC, this calculator |
| Median of the lower and upper halves, median left out | 70 | 88 | Many statistics textbooks, some calculators |
| Median of halves, median counted in both | 72 | 86.5 | Tukey's original box plot convention |
The gap between 70 and 72 on the same seven scores is not a bug in either method. Each defines a quartile as a different compromise between equal group sizes and simple arithmetic. When you compare your number with a published table, match the method before you match the digits; the NIST handbook section on percentiles lays out the definitions side by side.
Where quartiles show up in public data
Wage tables are the most common place an ordinary reader meets quartiles. The Bureau of Labor Statistics occupational employment statistics publish the 10th, 25th, 50th, 75th and 90th percentile wage for each occupation, so an electrician's pay table reads as a ladder of percentiles rather than one average. The 25th percentile is Q1 and the 75th is Q3, and the distance between them shows how wide the pay band runs.
School reporting uses the same cut points. Test score summaries often give the median and the interquartile range because a single average hides a class split between strong and struggling readers, and quartiles show both halves at once.
| Field | What the quartiles show | Why it matters |
|---|---|---|
| Pay tables | Q1 and Q3 wages for an occupation | Shows the realistic band, not one headline average |
| Test scores | Q1, median and Q3 scaled scores | Separates a class of similar scores from a split class |
| Home prices | Q1, median and Q3 sale prices in an area | Reveals whether a market has a wide or narrow spread |
| Quality control | Quartiles of a measured dimension | Flags drift long before a mean crosses a limit |
One caution applies to every table of this kind. Quartiles describe the sample they were computed from, so a Q3 wage for a metro area covers full time workers in that area only, and a Q3 test score covers the students who sat that test. Read the footnote that says who is counted before you compare two tables that look alike.
Frequently asked questions
What are quartiles in plain terms?
They are the three values that cut a sorted list into four equal groups. Q1 has a quarter of the data below it, Q2 is the median, and Q3 has three quarters below it.
How does this calculator compute quartiles?
It sorts the values, then locates each cut point with position = 1 + (n - 1) x p and interpolates between the neighbouring scores. That is the rule Excel uses for QUARTILE.INC.
What is Q1 for the scores 62, 70, 74, 79, 85, 88 and 91?
Q1 is 72. The position is 1 + 6 x 0.25 = 2.5, halfway between 70 and 74, so the value is 70 + 0.5 x (74 - 70) = 72.
What is the interquartile range of those scores?
It is 14.5 points, the distance from Q1 to Q3: 86.5 - 72 = 14.5. Half the scores sit inside that band.
How do quartiles work with an even number of values?
Every cut point falls between two scores. For 3, 5, 7, 8, 9, 12, 14, 15, 16, 20 the results are Q1 7.25, median 10.5 and Q3 14.75, with an interquartile range of 7.5.
Why do different tools give different quartiles for the same list?
Because there are several accepted definitions. On the seven scores above, linear interpolation gives Q1 72 and Q3 86.5, while the median of the halves with the median excluded gives Q1 70 and Q3 88.
How do I find outliers with the 1.5 IQR rule?
Multiply the interquartile range by 1.5, then subtract it from Q1 and add it to Q3. For the list 2, 4, 4, 5, 6, 7, 8, 30 the range is 3.25, the fences are -0.875 and 12.125, and 30 is the only outlier.
What is the difference between a quartile and a percentile?
A percentile reports the share of data below a value, so Q1 is the 25th percentile, Q2 the 50th and Q3 the 75th. Quartiles are just the percentiles with familiar names.
Can a quartile be a number that is not in the data?
Yes. Interpolation can land between two scores, so a list of whole numbers can produce Q1 7.25 or Q3 14.75. The result describes a position, not a recorded value.
How many numbers do I need to get a quartile?
Four is enough to be meaningful, and the interpolation works for any count above one. Small lists give unstable cut points, so treat quartiles from a handful of values as rough.
Do quartiles ignore extreme values?
They move less than the mean. Adding a score of 300 to a class of thirty shifts the mean by several points while the median holds and Q1 and Q3 shift by less than a rank.
Where do published quartiles come from in official data?
The Bureau of Labor Statistics publishes 25th and 75th percentile wages for each occupation, and school reports often give median and interquartile range scores. Both use the same cut point idea, sometimes with a different definition.
What does a small interquartile range mean?
The middle half of the data is tightly packed. A range of 3.25 on the eight value list above says most values sit within a few points of each other, while 30 still sits far outside.
Spotted a wrong number or a broken result?
More Math tools
Fee schedules, rates and rules change without notice. Always confirm important figures with the official source before you rely on them.