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.
Search JabSto ::




Custom Search