FREE Outlier and Anomaly Detection Template

Do outlier and anomaly detection with box and whisker plot graphs. Download a free outlier and anomaly detection template, click 'Find Unusual Data!', and follow the prompts in the template. And now, you can click the 'Start Over' button to clear the sheet so you can import your own data on which you to do outlier analysis when you download the new version "FindUnusualDatav2.xlsm" file.

Great for Data Analysis Toolpak users.

You may need to do the following before using any templates:

- Enable or disable macros in Microsoft 365 files
- Unblock macros from downloaded files

Notes:

- An excellent alternative to the K-Means or Hierarchical clustering algorithms commonly used for database segmentation analytics.

- The box & whisker plot algorithm is a more stable database segmentation solution that relies on the median for identifying segments; K-Means and Hierarchical clustering use the mean (average) to define segments making it sensitive to outliers and anomalies.

Create a scatterplot graph to find outliers and improve forecasts over time with the FREE Weekly Period Scatterplot and Trendlines Analysis Template. Or, automatically detect outliers, create a box & whisker plot graph, and receive a summary conclusion about dataset outliers with one button click using the Outlier Box Plot Graph Analysis Outlier and Anomaly Detection Template. The FREE SAMPLE OUTPUT - TIME SERIES Outlier and Anomaly Detection Template shows how you can detect patterns by finding outliers in data with the TIME SERIES Analysis Outlier Dashboard.