Find outliers and anomalies in your weekly plot of a key metric and identify trends for forecasting. Download the WeeklyScatterplotTrendlines.xlsm workbook template. Click the "Scatterplot & Trendlines" button, and you will generate a properly formatted scatterplot with 5 different trendlines (eg. linear regression, exponential smoothing etc.). Great for Data Analysis Toolpak users. You may need to do the following before using this template:
- Enable or disable macros in Microsoft 365 files
- Unblock macros from downloaded files
Notes:
- This template is set up to handle two columns of data: the first column, would be a weekly period (eg. weeks 1-52) to reflect what week of the year you are analyzing, and the second column would be a measure (eg. number of records, $ spent) that you are attempting to forecast.
You might also try the FREE Simple Box Plot Graph and Summary Message Outlier and Anomaly Detection Template or FREE Outlier and Anomaly Detection 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.
