The Histogram - The Simplest Normality Test
Probably the easiest normality test is to plot the data in an Excel histogram and then
compare the histogram to a normal curve. This method works much better with
larger data sets. It is extremely simple to perform in Excel. Here is an example of
how a Histogram is used in Excel as the most basic Normality test:
We are going to evaluate the following data for Normality using a Histogram: