Outlier calculator

Find outliers by the IQR method or by z-score, with every quartile, fence and score shown so the answer can be checked.

1 · Your numbers

Separated by commas, spaces, tabs or new lines. Currency symbols are ignored; anything that is not a number is reported rather than dropped silently.

2 · Method

Finding an outlier is not permission to delete it. A value outside the fences is a value worth looking at — it may be a typo, a unit mix-up or a failed sensor, or it may be the most interesting observation you have. Removing points because a formula flagged them is how real effects get erased. Decide with knowledge of where the data came from, and say what you removed and why.


Two methods, both shown in full

Paste your numbers and the tool gives you the quartiles, the interquartile range, Tukey's fences and every flagged value — plus the mean, standard deviation and z-score of each point. Nothing is a black box; every intermediate number is on screen so the result can be checked.

Which quartile convention

This matters, and most tools do not say. There is no single correct definition of a quartile, and different software gives different answers for the same data. This uses Tukey's hinges: sort the values, split at the median, and if the count is odd the median goes in neither half. That is the definition the box plot and the 1.5 x IQR rule were built on.

Excel's QUARTILE.INC and R's default interpolate instead and will give slightly different numbers on small samples. Neither is wrong; they answer a slightly different question. Knowing which one you are looking at is what lets you explain a difference instead of arguing about it.

The z-score method has a trap

An extreme value inflates the very mean and standard deviation it is being measured against, so a single large outlier can hide itself. Worse, on a small sample the score is mathematically bounded: with ten values no z-score can exceed about 2.85, so the usual threshold of 3 can never flag anything however wrong a value looks. The tool detects that case and says so rather than reporting a clean dataset.

Finding an outlier is not permission to delete it

This is the most important thing on the page. A value outside the fences is a value worth looking at. It might be a typo, a unit mix-up, or a sensor that failed — or it might be the single most interesting observation you have. Removing points because a formula flagged them is how real effects get erased. Decide with knowledge of where the data came from, and say what you removed and why.

Example

For 1, 2, 3, 4, 5, 6, 7, 8, 100: Q1 is 2.5, Q3 is 7.5, the IQR is 5 and the upper fence is 15. Only 100 is flagged.

Related tools

See the percentage calculator and the nth root calculator.

Rate this tool

Was this tool useful? Your feedback helps us improve it.

No ratings yet — be the first to rate this tool.
Your rating (required)
0 / 2000

Please do not include passwords, payment details or other sensitive information.

Your feedback is sent privately to the A2Z.Tools team and will not be posted publicly.