About this tool
Quartiles split a sorted data set into four parts with roughly a quarter of the values in each. The first quartile Q1 has a quarter of the data below it, the median Q2 half and the third quartile Q3 three quarters. The distance from Q1 to Q3, the interquartile range (IQR), measures the spread of the middle half of the data and is not affected by extreme values.
Together with the minimum and maximum, the quartiles form the five-number summary drawn in a box plot. Values more than 1.5 IQR below Q1 or above Q3 are flagged as outliers, following John Tukey's rule.
How it works
Type or paste your data, then choose a quartile method. The calculator sorts the values and shows the first quartile Q1, the median Q2 and the third quartile Q3, the interquartile range, the 1.5 × IQR fences with any outliers, the five-number summary and a box plot.
Quartiles have no single universal definition, and calculators, textbooks and spreadsheets use different rules. Pick the one you were taught: the median-of-halves methods are common in school and on TI calculators, while spreadsheets and NumPy interpolate between data points. The comparison table shows Q1, Q3 and the IQR under every method, so you can see at once whether the choice matters for your data.
Example
For 7, 12, 5, 30, 9, 2, 11, 8, 14, 6, 10 the sorted list is 2, 5, 6, 7, 8, 9, 10, 11, 12, 14, 30, and the median is the 6th value, 9. With the exclusive method the lower half is 2, 5, 6, 7, 8, so , and the upper half is 10, 11, 12, 14, 30, so . The IQR is .
The fences are and , so 30 is an outlier and the upper whisker ends at 14. Excel QUARTILE.INC gives and for the same data: the method changes the answer for small samples.
Assumptions and limits
No quartile method is the correct one; they are conventions that agree for large data sets and can differ noticeably for small ones. If your teacher, textbook or software expects specific values, choose the matching method. The 1.5 × IQR rule is a screening rule rather than a test: a flagged value is unusual, not necessarily an error, and it should not be removed without a reason.
The Excel QUARTILE.EXC method needs at least 3 values. Results use double-precision arithmetic and are shown to 10 significant digits.
Frequently asked questions
Why do different calculators give different quartiles?
Because there are several definitions. TI calculators take the median of each half and leave out the median when the count is odd, Tukey's hinges include it, and Excel, Google Sheets and NumPy interpolate between neighbouring values at positions based on n − 1 or n + 1. For large data sets the methods agree closely; for a dozen values they can differ by a whole data point.
How do I find outliers with the IQR?
Compute the fences and . Any value below the lower fence or above the upper fence is an outlier. Some texts call values beyond 3 IQR extreme outliers.
What is the five-number summary?
It is the minimum, Q1, the median, Q3 and the maximum. These five numbers describe the centre, the spread and the extremes of a data set, and they are exactly what a box plot draws.
How do I read a box plot?
The box runs from Q1 to Q3 with a line at the median, so it contains the middle half of the data. The whiskers reach the smallest and largest values that are not outliers, and outliers are drawn as separate points. A median off-centre in the box or one long whisker suggests skewed data.
Which method does Excel use?
QUARTILE and QUARTILE.INC interpolate at position (n − 1)p + 1, the same as Google Sheets and NumPy's default. QUARTILE.EXC uses position (n + 1)p, like Minitab and SPSS. Choose the matching method here to reproduce a spreadsheet result.
Link with your values
Add these parameters to this page’s address to open it with the values filled in, for example to share a calculation or to link to it from an AI assistant. The result is calculated in the browser: the page HTML shows an example for the default values, and the tool sets the data-url-params attribute once the link’s values are applied.
| Parameter | Value | If omitted |
|---|---|---|
valuesData set | values separated by commas: 2,4,4,6 | required |
methodMethod | one of: median_exclusive, median_inclusive, excel_inc, excel_exc | default median_exclusive |
Examples
?values=6,7,15,36,39,40,41,42,43,47,49&method=median_inclusive?values=1,2,3,4,5,6,7,8,9,10&method=excel_exc
Write decimals with a point. Encode a space as %20, + as %2B, # as %23 and & as %26.
Result elements: [data-result-block="quartile_calculator"]