Example of 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.
Tip

To get the same sample as in the table below, set the random generator base to 1, before you generate the random sample. Choose Calc > Set Base and enter 1.

  1. Choose Calc > Random Data > Normal.
  2. In Number of rows of data to generate, enter 40.
  3. In Store in column(s), type C1 C2 C3 C4 C5.
  4. In Mean, enter 10.
  5. In Standard deviation, enter 2.
  6. Click OK.

Results

The columns of random data are stored in the worksheet.

C1 C2 C3 C4 C5
         
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