Part IV: Managing and Analyzing Data
FIGURE 33.6
Use the histogram tool to generate distributions and graphical output.
Figure 33.7 shows a chart generated by the moving average tool. You can, of course,
specify the number of values that you want Excel to use for each average. If you select
the Standard Errors check box in the Moving Average dialog box, Excel calculates standard
errors and places formulas for these calculations next to the moving average formulas. The
standard error values indicate the degree of variability between the actual values and the
calculated moving averages.
