How to Install the 1.5×IQR Statistical Outlier Rule Excel Add‑In
The Interactive Statistics Education AddIn can be downloaded onto your laptop or PC. Then mark the AddIn as a Trusted 365 File. Then enable your VBA Macros in Microsoft 365.
Once you have the Interactive Statistics Education AddIn downloaded and trusted, load the AddIn so you can use it in any Excel workbook on your laptop or PC.
When you open your Excel workbook, make sure that you have a data tab named 'Sheet1' where you can have your column of data displayed in Column A. If you bring a dataset into your workbook using PowerQuery, query it into a worksheet and call it 'Data'. Then, copy and paste the column of data that you wish to analyze in Column A of the 'Sheet1' tab.
And, then, you will be ready to do the 14 Step by Step Tutorial - 1.5(IQR) Statistical Outlier Rule and learn core business statistics concepts on your own datasets using the Interactive Statistics Education AddIn.
Follow the video to select your data and follow the prompts. Learn the 1.5(IQR) Statistical Outlier Rule to Analyze Datasets and understand why this rule is so reliable to analyze datasets.
Download and install the Free 1.5(IQR) Statistical Outlier Rule Template to see a simple example of how the 1.5(IQR) Statistical Outlier Rule theory of the box & whisker plot can be used to analyze and visualize data.
Here's a quick Gen AI TIP - Using Copilot With the Interactive Statistics Education AddIn. Here's some detail About this 1.5(IQR) Statistical Outlier Rule Blog.
