Skip to content

Descriptive Statistics Calculator

Paste a column of numbers to describe it: the middle, the spread…

Paste a column of numbers to describe it: the middle, the spread, the quartiles by the method your class or software uses, and any outliers, drawn as a box plot.

Read 25 values; left out the header row (“Commute (minutes)”).

Quartiles as in

ExampleMedian, middle half

33

Half the values lie between 29 and 39 (IQR 10). 1 value is an outlier beyond 1.5 × IQR: 95.

Paste your own column of numbers.

257541120406080100median 33

The histogram counts values in equal bins; under it the box is the middle half, the line the median, the diamond the mean, and dots beyond the dashed fences are outliers.

Mean (SD)
35.84 (13.86)
Five-number summary
22 · 29 · 33 · 39 · 95
Skewness
3.409 (long right tail)
How this works: 9 sources,

How this works

Method

Descriptive statistics summarise a list of numbers before any test: where the middle is, how spread out the values are, and whether any stand apart. The five-number summary (minimum, first quartile, median, third quartile, maximum) and the box plot drawn from it show all of that at a glance. In the example, 25 commute times have a median of 33 minutes and one 95-minute trip that is far from the rest. Full method

How it’s tested

3 worked examples for this page are checked by automated tests before every release: given the inputs, the tool must show the expected answer.

Privacy

On your device. Nothing you enter or open leaves this browser. About privacy labels

Changes

  • First published: live curves with draggable cut-offs, and tests on pasted data (t-tests, ANOVA, chi-square, Fisher’s exact, correlation, regression, A/B), checked against SciPy.

Every change on What’s new

How we make toolsReport a mistake

How quartiles, the IQR and outliers are found

Descriptive statistics summarise a list of numbers before any test: where the middle is, how spread out the values are, and whether any stand apart. The five-number summary (minimum, first quartile, median, third quartile, maximum) and the box plot drawn from it show all of that at a glance. In the example, 25 commute times have a median of 33 minutes and one 95-minute trip that is far from the rest.

Quartiles split the sorted data into four parts, but there is no single rule for where the split falls between two values, and software disagrees. Excel’s QUARTILE.INC, Google Sheets, R and NumPy interpolate at position (n − 1)p + 1; Excel’s QUARTILE.EXC, Minitab and SPSS use (n + 1)p; TI-84 calculators and most school textbooks take the median of each half. Hyndman and Fan catalogued nine definitions in 1996. Pick the one your course or software uses and the numbers will match.

The interquartile range, Q3 − Q1, is the spread of the middle half. John Tukey’s fences sit 1.5 IQR below Q1 and above Q3; values beyond them are flagged as outliers, and beyond 3 IQR as far out. An outlier is a value to check, not one to delete: it may be a typing error, or the most interesting number in the data. The mean is pulled towards it; the median is not, which is why a long right tail shows as a mean above the median and a positive skewness.

IQR = Q3 − Q1 · fences = Q1 − 1.5 IQR and Q3 + 1.5 IQR

The three quartile methods side by side

Q1 and Q3 of the numbers 1 to n by each method, showing how far they can disagree on small samples (they converge as n grows).

Q1 and Q3 of the numbers 1 to n by each method, showing how far they can disagree on small samples (they converge as n grows).
DataExcel, Sheets, RExcel EXC, MinitabTI-84, textbooks
1 to 41.75 and 3.251.25 and 3.751.5 and 3.5
1 to 52 and 41.5 and 4.51.5 and 4.5
1 to 62.25 and 4.751.75 and 5.252 and 5
1 to 72.5 and 5.52 and 62 and 6
1 to 82.75 and 6.252.25 and 6.752.5 and 6.5
1 to 93 and 72.5 and 7.52.5 and 7.5
1 to 103.25 and 7.752.75 and 8.253 and 8
1 to 113.5 and 8.53 and 93 and 9
1 to 123.75 and 9.253.25 and 9.753.5 and 9.5
1 to 154.5 and 11.54 and 124 and 12
Show all 11 rows
1 to 205.75 and 15.255.25 and 15.755.5 and 15.5

Common questions

Why do my quartiles differ from my calculator’s?

Different tools use different definitions. A TI-84 takes the median of each half; Excel’s QUARTILE.INC interpolates. Switch “Quartiles as in” to match your tool; the worked example shows all three.

Should I remove outliers?

Only with a reason: a measurement or typing error, or a value from outside the population you are studying. Otherwise keep them and report results with and without, or use methods based on ranks or medians that they barely move.

Where are the mean, median and mode worked out step by step?

In the Math Calculator’s mean, median and mode page, which shows every step with exact fractions. This page focuses on the shape of the data: quartiles, spread, outliers and the histogram.