Using the New Variable - Random Numbers Function
The NEW VARIABLE - RANDOM NUMBERS function, part of the NEW VARIABLE MENU in EZAnalyze, allows you to quickly create random numbers to demonstrate various statistical problems and concepts - or 'just for fun'. You can set the mean and standard deviation, generate completely random numbers within a specified range, or specify a range, mean, and standard deviation.
To create a random numbers variable for your data, select the "New Variable" option from the EZAnalyze menu in Excel, then select "Random Numbers."
In the "Random Number Generator" dialogue box, type a name into the 'Variable name' box; this is what will appear in the first row on your data sheet. Also, specify the number of rows of data you would like to generate.
Next, choose at least one of the first two options below
When you click OK, a new column will be added to your data sheet that has the name you specified, with randomly generated numbers with parameters you specified.