Bots, writer
193,448
edits
Changes
Jump to navigation
Jump to search
Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution, NewTableFlag, ProbabilityValue,Trials) where, ..."
<div id="6SpaceContent" class="zcontent" align="left">
'''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution, NewTableFlag, ProbabilityValue,Trials)
where,
'''Number '''- represents the number of variables.
'''RandomNumber '''- represents the number of random number
'''Distribution '''- represents the distribution method(i.e binomial) 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.
'''ProbabilityValue '''- represents the probability value and should be in range 0 to 1.
'''Trails''' - represents the number of trials.
</div>
----
<div id="1SpaceContent" class="zcontent" align="left">The frequency distribution of the probability of a specified number of successes is an arbitrary number of repeated independent Bernoulli trials.</div>
----
<div id="7SpaceContent" class="zcontent" align="left">
Lets see an example in (Column1Row1)
<nowiki>=RANDOMNUMBERGENERATION(3, 4, "Binomial", TRUE, 0.5)</nowiki>
RANDOMNUMBERGENERATION returns the result in new sheet(9Space).
<nowiki>=RANDOMNUMBERGENERATION(5, 4, "Binomial", TRUE, 0.3, -1)</nowiki>
RANDOMNUMBERGENERATION returns the #ERROR(Trails < 0).
</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
RANDOM NUMBER GENERATION : BINOMIAL
</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.
RANDOMNUMBERGENERATION returns the #ERROR, if Trails < 0.
</div>
----
<div id="5SpaceContent" class="zcontent" align="left">
{| id="TABLE1" class="SpreadSheet blue"
|+ Random Number Generation<br />Binomial Distribution
|- class="even"
| 0
| 1
| 1
|- class="odd"
| 1
| 0
| 2
|- class="even"
| 0
| 2
| 1
|- class="odd"
| 1
| 1
| 1
|}
</div>
----
<div id="2SpaceContent" class="zcontent" align="left">
{| id="TABLE3" class="SpreadSheet blue"
|+ Default Calci
|- class="even"
| class=" " |
| Column1
| Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f" | 9Space
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| class=" " | Row2
| class=" " |
| class=" " |
| class=" " |
| class=" sshl_f " |
|- class="odd"
| Row3
| class=" " |
| class=" " |
| class=" " |
| class=" sshl_f " |
|- class="even"
| class=" " | Row4
| class="sshl_f" | #ERROR
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
| class=" " | Row5
| 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=" " |
| class=" " |
| class=" " |
|- class="even"
| Row6
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|}
{|
| <span align="left">[[Image:calci1.gif]]</span>
|
|
[[Image:bold.gif]]
|
[[Image:italic.gif]]
|
[[Image:normal.gif]]
|
[[Image:underline.gif]]
|
[[Image:border.gif]]
|
[[Image:numbers.gif]]
|
[[Image:sort.gif]]
|
[[Image:formatcells.gif]]
|
[[Image:graphs.gif]]
| $
|}
</div>
----
<div id="9SpaceContent" class="zcontent" align="left">
{| class="SpreadSheet blue"
|+ Random Number Generation<br />Binomial Distribution
|- class="even"
| 0
| 0
| 0
|- class="odd"
| 1
| 1
| 3
|- class="even"
| 1
| 1
| 3
|- class="odd"
| 0
| 0
| 1
|}
</div>
----
'''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution, NewTableFlag, ProbabilityValue,Trials)
where,
'''Number '''- represents the number of variables.
'''RandomNumber '''- represents the number of random number
'''Distribution '''- represents the distribution method(i.e binomial) 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.
'''ProbabilityValue '''- represents the probability value and should be in range 0 to 1.
'''Trails''' - represents the number of trials.
</div>
----
<div id="1SpaceContent" class="zcontent" align="left">The frequency distribution of the probability of a specified number of successes is an arbitrary number of repeated independent Bernoulli trials.</div>
----
<div id="7SpaceContent" class="zcontent" align="left">
Lets see an example in (Column1Row1)
<nowiki>=RANDOMNUMBERGENERATION(3, 4, "Binomial", TRUE, 0.5)</nowiki>
RANDOMNUMBERGENERATION returns the result in new sheet(9Space).
<nowiki>=RANDOMNUMBERGENERATION(5, 4, "Binomial", TRUE, 0.3, -1)</nowiki>
RANDOMNUMBERGENERATION returns the #ERROR(Trails < 0).
</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
RANDOM NUMBER GENERATION : BINOMIAL
</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.
RANDOMNUMBERGENERATION returns the #ERROR, if Trails < 0.
</div>
----
<div id="5SpaceContent" class="zcontent" align="left">
{| id="TABLE1" class="SpreadSheet blue"
|+ Random Number Generation<br />Binomial Distribution
|- class="even"
| 0
| 1
| 1
|- class="odd"
| 1
| 0
| 2
|- class="even"
| 0
| 2
| 1
|- class="odd"
| 1
| 1
| 1
|}
</div>
----
<div id="2SpaceContent" class="zcontent" align="left">
{| id="TABLE3" class="SpreadSheet blue"
|+ Default Calci
|- class="even"
| class=" " |
| Column1
| Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f" | 9Space
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| class=" " | Row2
| class=" " |
| class=" " |
| class=" " |
| class=" sshl_f " |
|- class="odd"
| Row3
| class=" " |
| class=" " |
| class=" " |
| class=" sshl_f " |
|- class="even"
| class=" " | Row4
| class="sshl_f" | #ERROR
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
| class=" " | Row5
| 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=" " |
| class=" " |
| class=" " |
|- class="even"
| Row6
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|}
{|
| <span align="left">[[Image:calci1.gif]]</span>
|
|
[[Image:bold.gif]]
|
[[Image:italic.gif]]
|
[[Image:normal.gif]]
|
[[Image:underline.gif]]
|
[[Image:border.gif]]
|
[[Image:numbers.gif]]
|
[[Image:sort.gif]]
|
[[Image:formatcells.gif]]
|
[[Image:graphs.gif]]
| $
|}
</div>
----
<div id="9SpaceContent" class="zcontent" align="left">
{| class="SpreadSheet blue"
|+ Random Number Generation<br />Binomial Distribution
|- class="even"
| 0
| 0
| 0
|- class="odd"
| 1
| 1
| 3
|- class="even"
| 1
| 1
| 3
|- class="odd"
| 0
| 0
| 1
|}
</div>
----