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 and enter 1.
- Choose .
- In Number of rows of data to generate, enter 40.
- In Store in column(s), type C1 C2 C3 C4 C5.
- In Mean, enter 10.
- In Standard deviation, enter 2.
- 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 |
| ... |
... |
... |
... |
... |