Number statistics

A quick read on a column of numbers

Paste in your numbers, a column copied out of a spreadsheet for instance, and you immediately see the mean, the median, the deviation and the quartiles. No workbook to set up, no function names to remember.

• The mean gets pulled around by extremes, the median does not. When the two differ, there are outliers in your data.
• The standard deviation says how far from the mean the numbers typically sit. The sample version divides by n − 1 and applies to a sample; the population one divides by n and applies when you have all the data.
• Quartiles cut the sorted numbers into quarters. Between the lower and the upper one lies the middle half of the values.

Labels and blank lines do no harm, they are counted separately as skipped. Numbers are recognised in both notations, 1,234.5 and 1 234,5, and percentages are read as fractions.

Frequently asked questions

Do the numbers match Excel?

Yes. Quartiles use the same method as QUARTILE.INC and the deviations match STDEV.S and STDEV.P.

Why is there no most frequent value?

Because nothing repeats. A mode only makes sense where values come back, such as grades or unit counts.

How many numbers can it take?

Tens of thousands without blinking, since it all runs in the browser. For larger volumes use the spreadsheet editor or a database.

Is the data sent anywhere?

No, the whole calculation runs in your browser.