Five Number Summary Calculator

A five-number summary condenses one numeric dataset into five ordered landmarks: minimum, first quartile, median, third quartile, and maximum. It is useful when a full list is too long to scan but a single average hides too much. The summary shows where the center sits, how wide the middle half is, and how far the endpoints reach.

Quartiles matter because they split the sorted values into lower, middle, and upper parts. The median gives a resistant center, while Q1 and Q3 frame the middle 50% of the data. That makes the summary especially helpful for test scores, response times, prices, lab measurements, classroom examples, and quick checks where skewed or unusual values can pull the mean away from a typical value.

Different quartile conventions can give different Q1 and Q3 values for the same sorted list. That is not a calculation error. It means the quartile method must match the class, spreadsheet, report, or statistical convention you need to compare against.

The summary is descriptive, not diagnostic. A wide range, a large interquartile range, or a flagged value can point to a spread issue, measurement error, or a real unusual case, but the five numbers alone do not explain why the data look that way.

Technical Details:

The calculation starts by extracting numeric tokens, sorting them from smallest to largest, and using the sorted positions to compute the summary. The minimum and maximum are the first and last sorted values. The median is the middle sorted value when the count is odd, or the average of the two middle values when the count is even.

Q1 and Q3 require a method choice because quartiles are not defined by one universal convention. A classroom box plot often uses Tukey hinges, while spreadsheet functions commonly use inclusive or exclusive percentile interpolation. Comparing results across worksheets, textbooks, and statistics software is safest when the same quartile rule is used every time.

Formula Core:

The core spread measures use the five summary landmarks, and the optional outlier fences are built from the interquartile range.

In the fence formulas, m is 1.5 for the standard fence and 3 for the outer fence. Values below the lower fence or above the upper fence are flagged as potential outliers. Those values still remain in the five-number summary, the sorted list, the range, the mean, and the sample standard deviation.

The box plot uses the selected quartile method and fence rule. When fences are active, whiskers stop at the lowest and highest non-outlier values; flagged values are drawn separately. When fences are off or cannot be applied, the whiskers use the dataset minimum and maximum.

Everyday Use & Decision Guide:

Start with the Number list and check the Count in Five-Number Ledger. If the count is lower than expected, the paste likely included labels, missing values, or formatting that did not contain numeric tokens. Open Sorted Values to confirm the order before interpreting Q1, median, and Q3.

Leave Quartile method on Tukey hinges for many classroom box-plot problems. Switch to Inclusive percentile when matching spreadsheet-style inclusive quartiles, and choose Exclusive percentile only when the worksheet or reporting rule calls for that convention. The method choice can move Q1 and Q3 enough to change IQR, fences, and the box plot.

• Use Standard 1.5 x IQR when you want the common box-plot outlier flag.
• Use Outer 3 x IQR when you want a stricter flag for more extreme values.
• Use No outlier fence when the assignment asks for whiskers from minimum to maximum.
• Set Decimal places before copying tables or JSON if the result must match a report format.
• Read Mean and Sample standard deviation as supporting context. The five-number summary itself is driven by sorted positions, not by the average.

Step-by-Step Guide:

Use the controls in this order when you need a repeatable five-number summary.

1. Paste values into Number list. The result area should appear with a badge such as n=12. If you see Paste at least one numeric value. or No numeric values were found in the current input., replace the text with actual numbers.
2. Choose Quartile method. Watch Five-Number Ledger because Q1, Q3, Interquartile range, and the box plot can change when the method changes.
3. Set Outlier fence. Open Fence Review to see the lower fence, upper fence, whiskers, and Potential outliers. If the table says the fence is not applied, check whether the sample has fewer than four values, IQR is zero, or No outlier fence is selected.
4. Adjust Decimal places only after the method and fence are right. The displayed ledger, chart tooltip, copied CSV, downloaded CSV, DOCX exports, and JSON output follow that rounding setting.
5. Use Sorted Values to inspect rank, value, percentile rank, and position. Then open Box Plot Spread for the visual spread or JSON when another workflow needs structured values.

Interpreting Results:

The most important values are Median, Q1, Q3, Interquartile range, and Potential outliers. Median describes the sorted center. IQR describes the spread of the middle half. Potential outliers show values beyond the selected fence, not values that must be removed.

If a result will be compared with a class key, published worksheet, or spreadsheet, verify Quartile method first. A different method can make a correct answer look wrong even when the sorted data are identical.

Worked Examples:

A balanced homework dataset

Paste 12, 18, 19, 21, 24, 26, 31, 34, 38, 42, 47, 55 and keep Tukey hinges with Standard 1.5 x IQR. Five-Number Ledger returns minimum 12.00, Q1 20.00, median 28.50, Q3 40.00, and maximum 55.00. The IQR is 20.00, the full range is 43.00, and Fence Review shows no potential outliers.

A response-time list with one high value

For response times such as 8, 9, 10, 10, 11, 12, 13, 14, 15, 65, Tukey hinges give Q1 10.00, median 11.50, and Q3 14.00. With the standard fence, the upper fence is 20.00, so Potential outliers lists 65.00. The five-number summary still uses maximum 65.00, while the box-plot whisker stops at the highest non-outlier value, 15.00.

A method mismatch check

For 2, 4, 7, 9, 11, 30, Tukey hinges returns Q1 4.00 and Q3 11.00. Inclusive percentile returns Q1 4.75 and Q3 10.50. Exclusive percentile returns Q1 3.50 and Q3 15.75. If your answer key expects one of those pairs, match the method before checking the arithmetic.

A paste that needs cleanup

If Number list contains only labels such as low, middle, high, the page reports that no numeric values were found. Replace the labels with the actual values, for example 72, 84, 88, 91, 97, then confirm that Count in Five-Number Ledger shows 5 before copying the result.

FAQ:

Glossary:

Q1

The first quartile, used as the lower edge of the middle 50% of the sorted data.

Median

The center value of the sorted data, or the average of the two center values when the count is even.

Q3

The third quartile, used as the upper edge of the middle 50% of the sorted data.

IQR

The interquartile range, calculated as Q3 minus Q1.

Tukey hinges

A quartile method that finds Q1 and Q3 from the medians of the lower and upper halves of the sorted list.

Fence

An IQR-based threshold used to flag values that sit unusually far from the quartile box.

Whisker

The box-plot line from Q1 or Q3 to the nearest endpoint or nearest non-outlier endpoint.

Bowley skew

A resistant skew measure that compares how the median sits between Q1 and Q3.

References:

• Box Plot, NIST/SEMATECH e-Handbook of Statistical Methods.
• What are outliers in the data?, NIST/SEMATECH e-Handbook of Statistical Methods.
• 2.4 Box Plots, OpenStax, March 27, 2020.
• WorksheetFunction.Quartile_Inc method, Microsoft Learn, September 13, 2021.
• WorksheetFunction.Quartile_Exc method, Microsoft Learn, September 13, 2021.