Part IV: Managing and Analyzing Data
FIGURE 33.8
This dialog box enables you to generate a wide variety of random numbers.
In the Random Seed field, you can specify the starting value that Excel uses in its random-
number-generating algorithm. Usually, you leave this field blank. If you want to gener-
ate the same random number sequence, however, you can specify a seed between 1 and
32,767 (integer values only). You can create the following types of distributions via the
Distribution drop-down list in the Random Number Generation dialog box:
Uniform Every random number has an equal chance of being selected. You specify the
upper and lower limits.
Normal The random numbers correspond to a normal distribution. You specify the mean
and standard deviation of the distribution.
Bernoulli The random numbers are either 0 or 1, determined by the probability of success
that you specify.
Binomial This option returns random numbers based on a Bernoulli distribution over a
specific number of trials, given a probability of success that you specify.
Poisson This option generates values in a Poisson distribution. A Poisson distribution is
characterized by discrete events that occur in an interval, where the probability of a single
occurrence is proportional to the size of the interval. The lambda parameter is the expected
number of occurrences in an interval. In a Poisson distribution, lambda is equal to the
mean, which also is equal to the variance.
Patterned This option doesn’t generate random numbers. Rather, it repeats a series of
numbers in steps that you specify.
