Data Analysis with Microsoft Excel: Updated for Office 2007

(Tuis.) #1
534

Number of Variables


Enter the number of columns of random variables you want to generate. If
no value is entered, Excel fi lls up all available columns.

Number of Random Numbers


Enter the number of rows in each column of random variables you want to
generate. If no value is entered, Excel fi lls up all available columns. This
command is not available for the patterned distribution (see below).

Distribution


Click the down arrow to open a list of seven distributions from which you
can choose to generate random numbers and then specify the parameters of
that distribution.

Random Seed


Enter an optional value used as a starting point, called a random seed, for gen-
erating a string of random numbers. You need not enter a random seed, but us-
ing the same random seed ensures that the same string of random numbers will
be generated. This box is not available for patterned or discrete random data.
See “Output Options” at the beginning of this section for information on
the output storage options.
Free download pdf