Lelifi·tools

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.

Paste your numbers and get Q1, Q2, Q3, the interquartile range and outlier fences, using the same interpolation rule as Excel QUARTILE.INC.

By the Lelifi editors ·

Key takeaways

Box plot of the 7 test scores62Q1 72median 79Q3 86.591Half of the scores sit inside the box, between Q1 and Q3, a span of 14.5 points.
Box plot of the seven scores, with the box running from Q1 to Q3 and the median line inside it.
Outlier fences on the 8 value listinside fencelower -0.875upper 12.12530 is an outlierFences sit 1.5 interquartile ranges below Q1 and above Q3, so anything outside them is flagged.
The 1.5 interquartile range fences for the eight value list, with the value 30 sitting outside the upper fence.
On this page
  1. What quartiles measure
  2. How this calculator finds the quartiles
  3. A worked example with 7 scores
  4. Even counts and fractional cut points
  5. Fences that flag outliers
  6. Quartiles, percentiles and competing methods
  7. Where quartiles show up in public data

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 nQ1 positionMedian positionQ3 position
7 values1 + 6 x 0.25 = 2.51 + 6 x 0.5 = 41 + 6 x 0.75 = 5.5
8 values1 + 7 x 0.25 = 2.751 + 7 x 0.5 = 4.51 + 7 x 0.75 = 6.25
10 values1 + 9 x 0.25 = 3.251 + 9 x 0.5 = 5.51 + 9 x 0.75 = 7.75
12 values1 + 11 x 0.25 = 3.751 + 11 x 0.5 = 6.51 + 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.

MeasurePositionScores usedResult
Minimum16262
Q12.570 and 7472
Median (Q2)47979
Q35.585 and 8886.5
Maximum79191

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.

MeasurePositionComputationResult
Q13.257.25, a quarter of the way up from 7 to 87.25
Median5.510.5, the average of the two middle scores 9 and 1210.5
Q37.7514.75, three quarters of the way from 14 to 1514.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.

StepComputationResult
Quartiles for 2, 4, 4, 5, 6, 7, 8, 30Q1 4, median 5.5, Q3 7.25as listed
Interquartile range7.25 - 4 = 3.253.25
Fence distance1.5 x 3.25 = 4.8754.875
Lower fence4 - 4.875 = -0.875-0.875
Upper fence7.25 + 4.875 = 12.12512.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:

MethodQ1 for the 7 scoresQ3 for the 7 scoresWhere you meet it
Linear interpolation on position 1 + (n - 1) x p7286.5Excel QUARTILE.INC, this calculator
Median of the lower and upper halves, median left out7088Many statistics textbooks, some calculators
Median of halves, median counted in both7286.5Tukey'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.

FieldWhat the quartiles showWhy it matters
Pay tablesQ1 and Q3 wages for an occupationShows the realistic band, not one headline average
Test scoresQ1, median and Q3 scaled scoresSeparates a class of similar scores from a split class
Home pricesQ1, median and Q3 sale prices in an areaReveals whether a market has a wide or narrow spread
Quality controlQuartiles of a measured dimensionFlags 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

See all Math tools

Fee schedules, rates and rules change without notice. Always confirm important figures with the official source before you rely on them.