Microsoft Office Tutorials and References

In Depth Information

**Plotting a normal curve**

Figure 8-41: The chart displays a histogram; the contents of cell E1 determine the

number of categories.

Figure 8-42: The previous chart, after changing the bin size

See Chapter 7 for more about creating charts that use named formulas in

their SERIES formulas.

Plotting a normal curve

Figure 8-43 shows two XY charts that display a normal distribution and the

cumulative normal distribution. The top chart uses the data in columns A and B. The

bottom chart uses the data in columns A and C. Cell B1, named
Mean,
controls the

mean of the distribution, and cell B2, named
SD, controls the standard deviation.