Microsoft Office Tutorials and References

In Depth Information

Figure 10-7:
Comparing a set of data with a normal distribution.

The formula in cell H2, which is copied down the column, is

=NORMDIST(F2,$D$5,$D$6,FALSE)

In the chart, the values in column H are plotted as a line and use the right axis. As you can see, the data con-

forms fairly well to the normal distribution. There are goodness-of-fit tests to determine the “normality” of a set

of data sample, but that's beyond the scope of this book.