Click 'A Simple Box Plot!' button after downloading the 'SimpleBoxplotGraph.xlsm' box and whisker outlier and anomaly detection template. Follow the prompts in the template. Use this box & whisker graph template for anomaly and outlier detection. The updated version "SimpleBoxPlotGraphv2.xlsm" lets you click the 'Start Over' button to clear yor worksheet and start and analysis of your dataset from scratch.
You may need to do the following before using any templates:
- Enable or disable macros in Microsoft 365 files
- Unblock macros from downloaded files
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.
