Combine the power of the FREE Ratio Analysis Template and FREE Outlier and Anomaly Detection Template into your Advanced Ratio Analysis Toolkit. Buy and download the "AdvancedRatioAnalysisToolkit.xlsm" template, then copy and paste as many columns of data into the grey-shaded rows 1, 2 and 3. When you click the "Ratio Analysis" button in the top right-hand corner of the worksheet, follow the prompts to build your own chart visualizing "Ratio Analysis", "Growth Rate" and "Market Share" trends in your financial data. You will also see which of your ratios are unusually high or low (yellow shaded cells) based on the statistical theory of the box & whisker plot. Click the "Start Over" button to do a new analysis from scratch. 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
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.
