Swapna at 19:36, 18 July 2015

2015-07-18T19:36:47Z

Swapna at 21:57, 30 March 2014

2014-03-30T21:57:09Z

MassBot1: Created page with "
'''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution, NewTableFlag, Value, Probability) where, ''..."

2013-10-25T02:33:50Z

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

New page

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

'''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution, NewTableFlag, Value, Probability)

where,

'''Number '''- represents the number of variables.

'''RandomNumber '''- represents the number of random number

'''Distribution '''- represents the distribution method(i.e discrete) 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.

'''ValueArr '''- represents the values.

'''Probability '''- represents the probability value.

</div>
----
<div id="1SpaceContent" class="zcontent" align="left">A discrete distribution is a distribution of a random variable that takes only finite set of values</div>
----
<div id="7SpaceContent" class="zcontent" align="left">

Lets see an example in (Column1Row1)

<nowiki>=RANDOMNUMBERGENERATION(3, 4, "discrete", TRUE,[4,5,6,3,2,1],[0.2,0.1,0.3,0.2,0.1,0.1])</nowiki>

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

<nowiki>=RANDOMNUMBERGENERATION(5, 4, "discrete", TRUE, [2,1],[0.3,0.9])</nowiki>

RANDOMNUMBERGENERATION returns the #ERROR(sumofProbability >1).

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

RANDOM NUMBER GENERATION : DISCRETE

</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 Probability< 0 or Probability >1.

</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="9SpaceContent" class="zcontent" align="left">

{| id="TABLE2" class="SpreadSheet blue"
|+ Random Number Generation<br />Poisson Distribution
|- class="even"
| 0
| 0
| 1
|- class="odd"
| 1
| 1
| 2
|- class="even"
| 0
| 1
| 0
|- class="odd"
| 2
| 2
| 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" | 13Space
| class=" " |
| class=" " |
| 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=" " |
| class=" " |
| class=" " |
|- class="odd"
| Row3
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| Row4
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
| class=" " | Row5
| class=" " |
| 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="13SpaceContent" class="zcontent" align="left">

{| class="SpreadSheet blue"
|+ Random Number Generation<br />Discrete Distribution
|- class="even"
| 1
| 6
| 6
|- class="odd"
| 4
| 5
| 5
|- class="even"
| 3
| 1
| 6
|- class="odd"
| 3
| 6
| 3
|}

</div>
----

@@ Line 55: / Line 55: @@
 | 10 || 11
 |}
 == See Also ==

Manuals/calci/DISCRETE - Revision history

Swapna at 19:36, 18 July 2015

Swapna at 21:57, 30 March 2014

MassBot1: Created page with " '''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution, NewTableFlag, Value, Probability) where, ''..."

MassBot1: Created page with "
'''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution, NewTableFlag, Value, Probability) where, ''..."