|
|
(2 intermediate revisions by the same user not shown) |
Line 26: |
Line 26: |
| | | |
| ==References== | | ==References== |
− | [http://stattrek.com/probability-distributions/poisson.aspx ] | + | [http://stattrek.com/probability-distributions/poisson.aspx Poisson Probability Distribution ] |
− | | |
− | <div id="6SpaceContent" class="zcontent" align="left">
| |
− | | |
− | '''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution, NewTableFlag, Lambda)
| |
− | | |
− | where,
| |
− | | |
− | '''Number '''- represents the number of variables.
| |
− | | |
− | '''RandomNumber '''- represents the number of random number
| |
− | | |
− | '''Distribution '''- represents the distribution method(i.e poisson) 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.
| |
− | | |
− | '''Lambda '''- represents the probability value and should be in range 0 to 1.
| |
− | | |
− | </div>
| |
− | ----
| |
− | <div id="1SpaceContent" class="zcontent" align="left">A poisson distribution is a distribution of random occurrences in which one occurrence has no influence on any other occurrence.</div>
| |
− | ----
| |
− | <div id="7SpaceContent" class="zcontent" align="left">
| |
− | | |
− | Lets see an example in (Column1Row1)
| |
− | | |
− | UNIQa09fd274c5c89988-nowiki-00000004-QINU
| |
− | | |
− | RANDOMNUMBERGENERATION returns the result in new sheet(13Space).
| |
− | | |
− | UNIQa09fd274c5c89988-nowiki-00000005-QINU
| |
− | | |
− | RANDOMNUMBERGENERATION returns the #ERROR(Lambda < 0).
| |
− | | |
− | </div>
| |
− | ----
| |
− | <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
| |
− | | |
− | RANDOM NUMBER GENERATION : POISSON
| |
− | | |
− | </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 Lambda < 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="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=" " |
| |
− | | class=" " |
| |
− | | class=" " |
| |
− | | class=" " |
| |
− | |- class="odd"
| |
− | | Row3
| |
− | | class=" " |
| |
− | | class=" " |
| |
− | | class=" " |
| |
− | | class=" " |
| |
− | |- class="even"
| |
− | | 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="13SpaceContent" class="zcontent" align="left">
| |
− | | |
− | {| class="SpreadSheet blue"
| |
− | |+ Random Number Generation<br />Poisson Distribution
| |
− | |- class="even"
| |
− | | 0
| |
− | | 0
| |
− | | 0
| |
− | |- class="odd"
| |
− | | 1
| |
− | | 0
| |
− | | 1
| |
− | |- class="even"
| |
− | | 1
| |
− | | 0
| |
− | | 1
| |
− | |- class="odd"
| |
− | | 0
| |
− | | 0
| |
− | | 0
| |
− | |}
| |
− | | |
− | </div>
| |
− | ----
| |