Manuals/calci/NORMAL
RANDOMNUMBERGENERATION(Number, RandomNumber, Distribution, NewTableFlag, Mean, StandardDeviation)
where,
Number - represents the number of variables.
RandomNumber - represents the number of random number.
Distribution - represents the distribution method(i.e normal) to create random values.
NewTableFlag - is the TRUE or FALSE.If set as TRUE,the result in new sheet. If NewTableFlag is omitted, it assumed to be FALSE.
Mean - represents the Mean.
StandardDeviation - represents the standard deviation.
Lets see an example in (Column3Row1)
=RANDOMNUMBERGENERATION(3, 4, "Normal", TRUE, 0, 4)
RANDOMNUMBERGENERATION returns the result in new sheet(5Space).
=RANDOMNUMBERGENERATION(-3, 4, "Uniform", TRUE, 3, 4)
RANDOMNUMBERGENERATION returns the #ERROR(Number < 0).
RANDOM NUMBER GENERATION : NORMAL
If Number < 0 or RandomNumber < 0, RANDOMNUMBERGENERATION returns the #ERROR.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 5Space | |||
| Row2 | ||||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
| -0.6469271541994427 | -1.9074080903736057 | -0.617997136104105 |
| -0.7646726307858795 | -0.12686814329075044 | -1.0016839542241755 |
| 1.5847698409152808 | 0.6334613031585946 | -0.4798269568260549 |
| -1.6687086155351085 | 1.102906962994111 | 1.4347768240383833 |