Manuals/calci/RANDOMNUMBERGENERATIONUNIFORM

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.