Manuals/calci/RANDOMUNIFORM
RANDOMNUMBERGENERATION(Number, RandomNumber, Distribution, NewTableFlag, MinNum, MaxNum)
where,
Number - represents the number of variables.
RandomNumber - represents the number of random number
Distribution - represents the distribution method(i.e uniform) 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.
MinNum - represents the lower bound.
MaxNum - represents the upper bound.
Lets see an example in (Column3Row1)
=RANDOMNUMBERGENERATION(3, 4, "Uniform", TRUE, 3, 4)
RANDOMNUMBERGENERATION returns the result in new sheet(5Space).
=RANDOMNUMBERGENERATION(-3, 4, "Uniform", TRUE, 3, 4)
RANKANDPERCENTILE returns the #ERROR(Number < 0).
RANDOM NUMBER GENERATION : UNIFORM
If Number < 0 or RandomNumber < 0, RANDOMNUMBERGENERATION returns the #ERROR.
Column1 | Column2 | Column3 | Column4 | |
Row1 | 5Space | |||
Row2 | ||||
Row3 | ||||
Row4 | ||||
Row5 | ||||
Row6 |
File:Calci1.gif | $ |
3.416686530585033 | 3.734185651797884 | 3.1254911890325703 |
3.725631870866405 | 3.9069897822707027 | 3.072565176392711 |
3.8419014310807382 | 3.8300204537883324 | 3.6992338183966544 |
3.6645259480487007 | 3.691631406563622 | 3.4257506403761404 |