MassBot1: Created page with "
'''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution, NewTableFlag, MinNum, MaxNum) where, '''Num..."

2013-10-25T02:43:06Z

Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution, NewTableFlag, MinNum, MaxNum) where, '''Num..."

New page

<div id="6SpaceContent" class="zcontent" align="left">

'''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.

</div>
----
<div id="1SpaceContent" class="zcontent" align="left">In Uniform Distribution, elements has an equal probability of being chosen at each draw.</div>
----
<div id="7SpaceContent" class="zcontent" align="left">

Lets see an example in (Column3Row1)

<nowiki>=RANDOMNUMBERGENERATION(3, 4, "Uniform", TRUE, 3, 4)</nowiki>

RANDOMNUMBERGENERATION returns the result in new sheet(5Space).

<nowiki>=RANDOMNUMBERGENERATION(-3, 4, "Uniform", TRUE, 3, 4)</nowiki>

RANKANDPERCENTILE returns the #ERROR(Number < 0).

</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">

RANDOM NUMBER GENERATION : UNIFORM

</div></div>
----
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
----
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
----
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
----
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
----
<div id="8SpaceContent" class="zcontent" align="left">

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

</div>
----
<div id="2SpaceContent" class="zcontent" align="left">

{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
| class=" " |
| Column1
| Column2
| class=" " | Column3
| Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f" | 5Space
|
| class=" " |
|
|- class="even"
| class=" " | Row2
| class=" SelectTD1 ChangeBGColor SelectTD1" |
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]] </div>
|
|
|
|- class="odd"
| Row3
|
|
|
|
|- class="even"
| Row4
| class="sshl_f" |
|
|
|
|- class="odd"
| class=" " | Row5
|
|
|
|
|- class="even"
| Row6
|
|
|
|
|}

<div align="left">[[Image:calci1.gif]]</div></div>
----
<div id="5SpaceContent" class="zcontent" align="left">

{| class="SpreadSheet blue"
|+ Random Number Generation<br />Uniform Distribution
|- class="even"
| 3.0921587828239025
| 3.16064508253283
| 3.129954016184432
|- class="odd"
| 3.619984838007554
| 3.741941227746203
| 3.242635785979709
|- class="even"
| 3.182006104762761
| 3.726037179322319
| 3.476079577339252
|- class="odd"
| 3.735333265892912
| 3.573506282799059
| 3.1812050199395165
|}

</div>
----

Manuals/calci/RANDOMNUMBERGENERATIONUNIFORM - Revision history

MassBot1: Created page with " '''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution, NewTableFlag, MinNum, MaxNum) where, '''Num..."

MassBot1: Created page with "
'''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution, NewTableFlag, MinNum, MaxNum) where, '''Num..."