The 1.5(IQR) Statistical Outlier Rule Interactive Statistics Education AddIn
Receive custom, on-screen message alerts with the 1.5(IQR) Statistical Outlier Microsoft Excel AddIn when you select a column of data (excluding the column heading) in "Column A" on "Sheet1" of your Excel workbook to create visuals of your data, and a full statistical report with the following information as you see in the video about the 1.5(IQR) Statistical Outlier AddIn:
- 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 and without data outliers, and with outliers automatically replaced
- EXTRA: there are also data transformation and forecasting modules not in video
