- Version
- Download 15
- File Size 175.22 KB
- File Count 1
- Create Date May 11, 2022
- Last Updated May 11, 2022
Basic Statistical Summary
This is a macro-enabled (xlsm) Excel file which performs a basic statistical analysis on any data set (can be a few dozen data points, or a few thousand). The summary report provides the expected statistics: average, standard deviation, median, minimum, maximum. A histogram of the data is compared to a comparable "normal distribution". The VALUE of this tool is that it quantifies if your data set is "normally distributed" or "non-normal". The selection of subsequent statistical analyses (like ANOVA) depend on normally distributed data.

