What does your data look like - with and without statistical outliers? Use this template and receive custom, on-screen message alerts when you select a column of data (excluding the column heading) in "Column A" on "Sheet1" of your Excel workbook to get an on-screen report that summarizes key descriptive statistics for your data - with and without outliers. You will also receive the following:
- 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 to visualize statistically high or low outlier data points
To run this template, select "Developer" and then click "Macros" at the top of your Excel workbook. Highlight the "mcrCallfindOutlier" macro, and then click the "Run" button. Follow the prompt to 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.
You may need to do the following before using any templates:
- Enable or disable macros in Microsoft 365 files
- Unblock macros from downloaded files
