Box-Plots, Histograms, Normality tests in Microsoft Excel

Transform Microsoft Excel into a comprehensive, easy-to-use statistical analysis package, with powerful statistics like ANOVA, linear & polynominal regression.

A wide range of parametric and non-parametric statistics and hypothesis tests are provided. Confidence intervals are included wherever possible.

Describe location & distribution with summary statistics
Statistics include mean, median, standard deviation (all with confidence intervals), skewness, kurtosis, standard error of the mean, minimum, maximum, 1st & 3rd quartiles, interquartile range and percentiles.
Visualise distribution and identify outliers
Customisable histogram, frequency plot, box-whisker, Tukey box-, dot-, mean-, SD- and percentile plots. Tukey box and whisker plot shows potential near- and far- outliers.
See example Histogram with Normal overlay

See example skeletal box and whisker plot

See example Mean plot with CI diamond and +/-1 SD

See example Tukey outlier box and whisker plot
Test & visualise normality
Test normality with Shapiro-Wilk, Anderson Darling and Kolmogorov Smirnov tests, or visually assess it with a Normal Quantile plot.
See example Normal probability plot
Test randomness or for differences in mean/median/proportion
Includes 1-sample t-test, z-test, Binomial test, and Runs tests for randonmess.