A column of numbers, described honestly FIGURES
The mean is the balance point, so one large value drags it. Average household income is not what a household earns, and average response time is not what a caller waits.
The numbers
One per line, or separated by spaces or commas. Currency symbols and thousands separators are ignored.
The summary
Quartiles by linear interpolation between order statistics, which is what most statistical software uses. Nine published definitions of a quartile exist and they disagree on small samples, so the one in use is named rather than assumed.
What the mean is and is not telling you
The shape
A shape is worth more than any of the numbers above it, and one made of characters can be pasted into an email.
The report
How it works
FIGURES describes a set of numbers honestly: mean, median, quartiles and spread. It flags outliers and data with two humps, where a single average misleads, and says which quartile definition it used. Your data stays in this tab.
The guide: When the mean is the wrong average
Questions people ask about FIGURES
When should I not use the mean?
When the distribution is skewed, when a few values account for much of the total, or when the shape has two humps. All three are checked here and reported in words. The rule of thumb is simple: if the mean and the median disagree by much, quoting only the mean is a choice and somebody will eventually ask why you made it.
What is an outlier here?
A value more than one and a half interquartile ranges beyond the quartiles, which is the usual convention. It is worth saying plainly that outside the fences is not the same as wrong: the 412,000 in a column of salaries may be the chief executive, which is a fact rather than an error. Check them; do not delete them by reflex.
Why does the quartile definition matter?
Because on a sample of nine values the nine published definitions can give visibly different quartiles, and two people using different software will disagree about the same data. Naming the method is what makes the number checkable.
What does two humps mean?
That you are almost certainly looking at two populations added together: two teams, two products, two shifts. A mean sits in the valley between them and describes nothing at all. The fix is to separate them, not to summarise harder.
Does my data go anywhere?
No. There is no network call on this page.
Doing this often? For t-tests, ANOVA, regression and factor analysis, checked against the standard libraries, use OBSCURA Gnosis. On its own, US$2 a month; with everything else, US$5 a month or US$48 a year.