Interactive 1.5(IQR) Statistical Outlier Rule Education AddIn

Tell Your Data's Statistical Story

Tell your data story with the Interactive 1.5(IQR) Outlier Rule Education AddIn and learn whether statistical outliers found with the 1.5(IQR) Outlier Rule skew your data analysis while you learn basic statistics. Receive custom, on-screen message alerts with the Interactive 1.5(IQR) Statistical Outlier Rule Education AddIn when you select a column of data (excluding the column heading) in "Column A" on "Sheet1" of your Excel workbook to create a full outliers and descriptive statistics analysis report. The Interactive 1.5(IQR) Statistical Outlier Rule Education AddIn let's you quickly learn, teach and apply statistical analysis in any Excel workbook. Purchase and download this Interactive 1.5(IQR) Statistical Outlier Rule Education AddIn, and then add it to your Excel workbook the same way you do the Data Analysis Toolpak Excel AddIn.

Use the sample .csv data file provided and then connect to your own dataset on OneDrive or in an Azure SQL Database to learn statistics and find outliers with this Free Step by Step 1.5(IQR) Statistical Outlier Tutorial. Let the Interactive 1.5(IQR) Statistical Outlier Rule Education AddIn algorithm automatically tell your data's statistical story as you present it to others:

- all key descriptive statistics (eg. Standard Deviation, Mean, Variance, Percentiles)
- whether your data is positively or negatively skewed or normally distributed
- which values in your dataset are statistically high or low outliers

- the R and R-squared statistics to summarize a positive, neutral or negative trend
- the # of bins and interval width for building a histogram of your data
- an actual histogram of your data for isolating outlier values

- a scatterplot of your data to identify trends and outliers

- a box & whisker plot diagram to visualize statistically high or low outliers

- box & whisker diagrams of your data with and without outliers

- a t-Test report to compare your data with and without outliers

- a new dataset with outliers automatically replaced

- descriptive statistics with/without data outliers, and with outliers automatically replaced

- create forecast scenarios of KPIs before and after outliers have been replaced

Windows PC or Laptop Installation:

1. Find the .xlam AddIn file in your downloads folder, right mouse-click, select 'Properties', then check 'Unblock' so that Excel knows this file is safe.

2. 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.

3. 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 that runs the Interactive Statistics Education AddIn.

4. Finally, click on the 'Developer' tab at the top of your Excel workbook, select 'Excel Addins', and then browse to find the '.xlam' file that you downloaded in Step 1 to make it an AddIn in every Excel workbook that you use. You should see an 'Outlier Analysis' tab show up beside the 'Help' menu fo your workbook that has a box and whisker plot icon that you will click to use the AddIn.

MAC PC or Laptop Installation:

1. Find the .xlam AddIn file in your downloads folder, right mouse-click, select 'Properties', then check 'Unblock' so that Excel knows this file is safe.

2. 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.

3. In the same Excel workbook, select 'Excel - Preferences - Privacy - Trust Center Settings'  then check 'Enable VBA Macros' to tell your Excel that it can trust the code that runs the Interactive Statistics Education AddIn.

4. Finally, click on the 'Developer' tab at the top of your Excel workbook, select 'Excel Addins', and then browse to find the '.xlam' file that you downloaded in Step 1 to make it an AddIn in every Excel workbook that you use. You should see an 'Outlier Analysis' tab show up beside the 'Help' menu fo your workbook that has a box and whisker plot icon that you will click to use the AddIn.

Laptops - Software - Textbooks + YOUR Data = Interactive Statistics Education AddIn

Imagine a video game for students that allows them to browse the web, find a dataset, and then play a story about this dataset in the classroom, real-time, on their laptop. And, then, have the student upload or broadcast this story in real-time via ZOOM to their classmates? Or, maybe you have students upload their data story to the Cloud (eg. OneDrive) for others to review later. That's the vision of the following equation of Box Plots + Laptops = Interactive Statistics Education AddIn.

The left side of this equation does not include printed textbooks or videos which don't allow students to interact with data to learn statistics (mean, median, mode, standard deviation, histograms, box plots and how these are related). And forget about using PowerPoint to present your data story. This Interactive Statistics Education AddIn lets you connect to and query data stored anywhere, and then it builds an interactive data story directly in your workbook.

The right side of this equation doesn't involve any new, expensive software: it simply requires students to install a Microsoft-Excel AddIn (like the Data Analysis Toolpak Excel AddIn) onto their laptop that likely already has Excel installed on it. No new software, just an improvement to existing software is required.

If you teach statistics, analytics, big data, modeling, or even programming, the real question is: are you teaching it to students how and where they need to learn it. Every day, many students play video games or watch videos and either get rated on their play or have a chance to rate the play. Shouldn't statistics be taught the same way?

Select "Outlier Analysis" beside the "Help" menu tab at the top of your Excel workbook. Click the "Find Outliers" icon, select your column of data, and then wait for your results: a new column of data indicating values that are statistically too high (High Outlier) or too low (Low Outlier) based on the statistical theory of the box & whisker plot.