Manuals/calci/RANDOMUNIFORM

From ZCubes Wiki
Jump to navigation Jump to search

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.


In Uniform Distribution, elements has an equal probability of being chosen at each draw.

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


Syntax

Remarks

Examples

Description

If Number < 0 or RandomNumber < 0, RANDOMNUMBERGENERATION returns the #ERROR.



Random Number Generation
Uniform Distribution
3.416686530585033 3.734185651797884 3.1254911890325703
3.725631870866405 3.9069897822707027 3.072565176392711
3.8419014310807382 3.8300204537883324 3.6992338183966544
3.6645259480487007 3.691631406563622 3.4257506403761404