writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 27:
Line 27: − − <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> − ----
Manuals/calci/POISSONDISTRIBUTION (view source)
Revision as of 12:56, 27 October 2015
, 12:56, 27 October 2015no edit summary
==References==
==References==
[http://stattrek.com/probability-distributions/poisson.aspx Poisson Probability Distribution ]
[http://stattrek.com/probability-distributions/poisson.aspx Poisson Probability Distribution ]