A professor generates 50 rows of random normal data for use in a classroom exercise. The professor wants to demonstrate a standard normal distribution, so the mean is 0 and the standard deviation is 1. The professor and students each set the base to 1 to generate the same data.

  1. Choose Calc > Set Base.
  2. In Set base of random data generator to, enter 1.
  3. Click OK.
  4. Choose Calc > Random Data > Normal.
  5. In Number of rows of data to generate, enter 50.
  6. In Store in column(s), type C1.
  7. In Mean, enter 0.
  8. In Standard deviation, enter 1.
  9. Click OK.

Results

The column of random data is stored in the worksheet.

C1
 
0.03064
−0.23680
−1.19198
0.81844
−0.94993
...
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy