About this 1.5(IQR) Statistical Outlier Rule Blog
I spent the past 5 years teaching business analytics, applied statistics and VBA Excel spreadsheet programming to undergraduate and graduate students at the Schulich School of Business at York University. And my passion for statistics and programming led me to develop a tool for teaching students about business analytics call the Interactive Statistics Education AddIn.
Below is a detailed description of this AddIn which every student should have loaded onto their laptop. Students can keep it for their entire academic journey. I have even developed a tutorial that students can follow as they use the AddIn on different datasets. And, there is a demonstration video as well if students have an interest.
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 you receive when doing a Data Analysis Toolpak descriptive statistics report. Students 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, students 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.
Interactive Statistics Education AddIn Sample Output
Students 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.
