Step by Step Tutorial - 1.5(IQR) Statistical Outlier Rule

Below are the 14 steps that you must take to use the Interactive Statistics Education AddIn. Actually, all you need to do is Steps 1-4 and the rest just happens. You can just read the interactive messages that pop-up on screen and see your report being created in front of you. Here is your step-by-step tutorial to follow after you buy and download the Interactive Statistics Education AddIn. It's been tested on Canadian university business analytics students, and they like it. 

 Step 1: Add the AddIn in Excel

Step 2: Select the 'Outlier Analysis' Tab

Step 3: Click the 'Find Outliers' Button

Step 4: Select Your Column of Data

Step 5: Outlier Analysis Conclusion

Step 6: Descriptives Report and Charts

Step 7: Descriptives Report and Charts

Step 8: Descriptives Report and Charts

Step 9: Descriptives Report and Charts

Step 10: Histogram Analysis Conclusion

Step 11: Trend Analysis Conclusion

Step 12: With vs. Without Outliers Analysis Conclusion

Step 13: With vs. Without Outliers Box & Whisker Plot

Step 14: Student's T-test Analysis Conclusion

Step 15: Replace Statistical Outliers With Box & Whisker Upper and Lower Limits

Step 16: Descriptive Statistics With Outliers vs. With Statistical Outliers Replaced

Step 17: Forecast Data With Outliers vs. With Statistical Outliers Replaced