Manuals/calci/RANDOMNUMBERGENERATIONUNIFORM

From ZCubes Wiki
Revision as of 20:43, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution,  NewTableFlag, MinNum, MaxNum) where, '''Num...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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.


Column1 Column2 Column3 Column4
Row1 5Space
Row2
Row3
Row4
Row5
Row6

Random Number Generation
Uniform Distribution
3.0921587828239025 3.16064508253283 3.129954016184432
3.619984838007554 3.741941227746203 3.242635785979709
3.182006104762761 3.726037179322319 3.476079577339252
3.735333265892912 3.573506282799059 3.1812050199395165