Paste a column of numbers. Instantly get the mean, median, std deviation, and easily spot anomalies.
Sorted Dataset (Outliers highlighted using IQR method )
An outlier is a data point that differs significantly from other observations in a dataset. Outliers can be caused by experimental errors, measurement variability, or they may indicate a novel, true discovery. The Data Outlier Spotter is a free, professional-grade statistical tool that helps you clean your data by identifying these anomalies using the Interquartile Range (IQR) method—one of the most reliable ways to find "mild" and "extreme" deviations without being influenced by the outliers themselves.
[Image of Box and Whisker Plot with Outliers]To find outliers, our tool calculates Tukey’s Fences. Unlike a standard Z-score (which relies on the Mean), the IQR method uses the Median, making it much more robust for skewed data:
Q1 - (1.5 * IQR) or higher than Q3 + (1.5 * IQR) is flagged as a statistical outlier.In addition to anomaly detection, this tool provides four essential descriptive statistics for any numerical column:
| Metric | What it Tells You |
|---|---|
| Mean | The mathematical average. Highly sensitive to outliers. |
| Median | The middle value. More accurate than the Mean for "noisy" data. |
| Std Deviation | How spread out your numbers are around the average. |
| N (Count) | The total number of valid data points in your sample. |
Whether you are analyzing scientific trial results, checking financial logs for fraud, or cleaning up a CSV for a machine learning model, privacy is paramount. Many online outlier calculators require you to upload your spreadsheets to their servers.
The Data Outlier Spotter is a purely client-side application. When you paste your data, the statistical processing happens entirely within your browser's local memory. Your numbers never leave your device, ensuring that sensitive data—like business revenue or health metrics—remains completely confidential.