Example of Generate Random Data

An engineer wants to generate a few columns of random normal data to demonstrate the variability in a process. The process has a mean of 10 and a standard deviation of 2. The engineer generates 5 columns of data from a normal distribution, with 40 rows in each column.

  1. Open the Generate Random Data dialog box.
    • Mac: Data > Generate Random Data
    • PC: DATA > Random Data
  2. In Number of columns to generate, enter 5.
  3. In Number of rows in each column, enter 40.
  4. From Distribution, select Normal.
  5. In Mean, enter 10.
  6. In Standard deviation, enter 2.
  7. Click OK.

Results

The columns of random data are stored in the worksheet.

C1 C2 C3 C4 C5
Normal Normal_1 Normal_2 Normal_3 Normal_4
10.0613 8.4648 7.9726 10.5831 9.8932
9.5264 7.1687 4.4360 11.3124 11.2211
7.6160 7.8190 11.1446 8.8531 9.3126
11.6369 11.6133 12.3594 10.9214 11.8148
8.1001 9.8552 8.8182 8.9463 9.5570
... ... ... ... ...
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy