Tell Your Data's Statistical Story: 1.5(IQR) Outlier AddIn

Tell Your Data's Statistical Story: The 1.5(IQR) Outlier AddIn

Tell your data story with the 1.5(IQR) Outlier 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 1.5(IQR) Outlier 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 1.5(IQR) Outlier AddIn let's you quickly learn, teach and apply statistical analysis in any Excel workbook. Purchase and download the 1.5(IQR) Outlier AddIn, and then add it to your Excel workbook the same way you do the Data Analysis Toolpak Excel AddIn.

Use the 1.5(IQR) Outlier AddIn on Any Data Source

Use the sample .csv data file provided and then connect to your own dataset on your hard drive, from OneDrive or in an Azure SQL Database to learn statistics and find outliers with this 1.5(IQR) Outlier Tutorial. Let the 1.5(IQR) Outlier AddIn process 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

Watch the 1.5(IQR) Outlier AddIn Demo Video

Watch this Demo Video with no sound about how the 1.5(IQR) Statistical Outlier AddIn teaches users, interactively with on-screen messages, about statistics while it builds a statistical story about a column of data. Learn the 1.5(IQR) Statistical Outlier Rule that is the first step in any data analysis. This is particularly true in cases where analysts must attempt to draw inferences about a larger population from a sample of customer behaviour or survey data. Regardless of the statistical software being used, statistical outliers must be investigated, understood and then addressed in one of three possible ways: transformed using a variety of statistical formulas (eg. LOG, POWER, SQUARE ROOT) and left in the data analysis, replaced with Box & Whisker Plot UPPER and LOWER limits, or excluded from the analysis altogether. In business, statistical outliers may reflect potential fraud, poor customer experience, network outages, or a lack of operational excellence.

View the 1.5(IQR) Outlier AddIn Sample Output Image

Data scientists and statistical analysts must first find and deal with outliers before doing their analysis:

- If you forecast sales, outliers in your dataset will make predictions inaccurate.
- Segmenting customers accurately based on behaviour requires outliers be isolated
- Analyzing survey research to understand larger populations is sensitive to outliers
- Quality control measures for product consistency demands outlier identification
- Scenario analysis to find optimal solutions based on data will be skewed by outliers

And, the process of statistical outlier identification can actually aid in the creation of natural, statistically significant segments: point in time or time series.

Share the 1.5(IQR) Outlier AddIn Web-Embedded Sample Output

Use the 1.5(IQR) Outlier AddIn Before the Data Analysis Toolpak

Get a quicker, interactive, more complete descriptive statistics and visualization report in Excel when you select a single column of data using the 1.5(IQR) Outlier AddIn. Compare the Excel Outlier Analysis AddIn Sample Output (below) to the 13 descriptive statistics (that's it!, and no charts, no on-screen feedback) you receive when doing a Data Analysis Toolpak descriptive statistics report. You can use the 1.5(IQR) Outlier AddIn as a descriptive statistics and data visualization extension of the Data Analysis Toolpak while doing statistical outlier analysis: and only use one mouse click to do so! Unlike the Data Analysis Toolpak, you will receive pop-up, on-screen messages from the 1.5(IQR) Outlier AddIn at each step of the report's creation to help you interpret your descriptives on the fly.

You will create a scatter diagram, box & whisker plot, pie chart, and histogram of your data with one mouse click using the 1.5(IQR) Outlier AddIn: unlike with the Data Analysis Toolpak which requires you to manually create each of these visuals one at a time. And, the 1.5(IQR) Outlier AddIn, gives you a much more complete descriptive statistics report versus the Data Analysis Toolpak. Unlike the Data Analysis Toolpak, the 1.5(IQR) Outlier AddIn automatically outputs Box & Whisker Plot UPPER and LOWER LIMITS for doing outlier analysis. And, you receive important statistics for creating a properly binned and distributed Histogram of your data using the 1.5(IQR) Outlier AddIn. A pie chart provides you a visualization of how your data is distributed based on 5 pre-defined variable segments. You also see each record in Column B of your worksheet flagged with one of these 5 category segments. And, finally, to the far right of your screen, view your dataset with statistical outliers, excluding statistical outliers, or after these outliers have been replaced with Box & Whisker Plot UPPER and LOWER LIMITS.

1.5(IQR) Outlier AddIn 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 1.5(IQR) Outlier 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 of your workbook that has a box and whisker plot icon that you will click to use the AddIn.

1.5(IQR) Outlier 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 1.5(IQR) Outlier 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 of your workbook that has a box and whisker plot icon that you will click to use the AddIn.

Laptops - Software - Textbooks + YOUR Data = 1.5(IQR) Outlier 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 = 1.5(IQR) Outlier 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 1.5(IQR) Outlier 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.