Code the 1.5(IQR) Outlier Rule
Whether you are using source VBA Excel code macros or templates that contain VBA Excel macros, you will need to take the following steps so that you can do outlier and anomaly detection on your PC or MAC laptop or PC.
Windows PC or Laptop Installation:
1. Open a blank Excel workbook, select 'File - Options - Customize Ribbon' then check 'Developer' to add the 'Developer' tab at the top of every Excel workbook that you open from now on.
2. In the same Excel workbook, select 'File - Options - Trust Center - Trust Center Settings' then check 'Enable VBA Macros' to tell your Excel that it can trust the code.
MAC PC or Laptop Installation:
1. Open a blank Excel workbook, select 'Excel - Preferences - Toolbar & Ribbons' then check 'Developer' to add the 'Developer' tab at the top of every Excel workbook that you open from now on.
2. In the same Excel workbook, select 'Excel - Preferences - Trust Center - Trust Center Settings' then check 'Enable VBA Macros' to tell your Excel that it can trust the code.
Box Plot Outlier and Anomaly Detection Resources
Watch Videos
Write Macros
- Show the VBA Excel Developer Tab
- Excel VBA Reference
- MS Excel for MAC VBA Reference
- VBA Excel Dim Statement Reference
- VBA Excel Set Statement Reference
- VBA Excel Range Object Reference
- VBA Excel With Statement Reference
- VBA Excel For Statement Reference
- VBA Excel IF Statement Reference
- VBA Excel REPLACE Statement Reference
- VBA Excel User Forms Reference
- VBA Excel File User Permissions Reference
- VBA Excel File Format Reference
- VBA Excel Option Base Statement Reference
- VBA Excel and Using Arrays Reference
- VBA Excel and Dynamic Arrays Reference
- VBA Excel Data Bars Object Reference
Create Charts and Pivot Tables
- VBA Excel Chart Object Reference
- VBA Excel Add Trendline Chart
- VBA Excel Worksheet Function
- VBA Excel Pivot Table Object Reference
- VBA Excel Add Pivot Table Slicer
Write Functions and Calculations
- VBA Excel Worksheet Function
- VBA Excel Create Custom Functions
- VBA Excel Forecasting Worksheet Function
- VBA Excel Seasonality Forecasting Function
- VBA Excel Speak Method
Connect to Data
- VBA Excel Create an ADO SQL Database Connection
- VBA Excel Create an ADO Azure Database Connection
- Create and VBA Connect to SQL Azure Database
- Connect to Azure SQL Database in Excel
- Power BI Documentation
- VBA Excel Workbook SaveAs Method
- VBA Excel Workbooks Open Method
Perform Complex Analysis
- VBA Excel Macros and SAS
- VBA Excel and Tableau
- VBA Excel Frontline Solvers
Box Plot Analysis Resources
- Create Box Plot Graph in Excel
- Microsoft Excel Support and Help
- Microsoft Excel Developer Centre
- Contact Microsoft Excel for Support
- MS Excel Formulas and Functions
- Create Excel Charts From Start to Finish
- Add a Custom Pie Chart in MS Excel
- Insert Trendline to Excel Chart
- Use Data Bars to Visualize Data
- Get an Excel Add-in
- Excel for Windows Training
- Microsoft Excel Community
- Troubleshoot MS Excel Crashing Issues
- Analyze Data With Excel Templates
- Social Media Analytics Report Excel Template
- My Online Training Hub
- Clearly and Simply
- MrExcel.com
- ExcelForum.com
- VBA Excel on StackOverflow
Analytics Books and Authors