Data Analysis with Microsoft Excel: Updated for Office 2007

Excel Reference 553

Patterned Data

The StatPlus>Create Data>Patterned Data command generates a column of data

following a specifi ed pattern. The pattern can be created on the basis of a se-

quence of numbers or taken from a number sequence entered in a data column

already existing in the workbook. The user can specify how often each number

in the pattern is repeated and how many times the entire sequence is repeated.

Random Numbers

The StatPlus>Create Data>Random Numbers command generates columns

of random numbers for a specifi ed probability distribution. The user speci-

fi es the number of samples (columns) of random numbers and the sample

size (rows) of each sample.