Basic Statistical Summary

[featured_image]
  • 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.