Manuals/calci/UNIFORM
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 |
3.9179240869362353 | 1.9353770981878542 | 3.1999177033935786 |
2.6672694494628155 | 2.304309051607576 | 3.5802220587629203 |
3.463705677339731 | 3.0560718547489056 | 2.2494758116026307 |
2.561365618826837 | 2.456471014450667 | 2.4974644940169765 |