Excel 2010 Bible

Chapter 38: Analyzing Data with the Analysis ToolPak

789

FIGURE 38.7

A chart produced by the Moving Average tool.

The first few cells in the output are #N/A because not enough data points exist to calculate the

average for these initial values.

Random Number Generation

Although Excel contains built-in functions to calculate random numbers, the Random Number

Generation tool is much more flexible because you can specify what type of distribution you want

the random numbers to have. Figure 38.8 shows the Random Number Generation dialog box. The

Parameters section varies, depending upon the type of distribution that you select.

FIGURE 38.8

This dialog box enables you to generate a wide variety of random numbers.