Manuals/calci/POISSONDISTRIBUTION
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.
Lets see an example in (Column1Row1)
=RANDOMNUMBERGENERATION(3, 4, "Poisson", TRUE, 0.8)
RANDOMNUMBERGENERATION returns the result in new sheet(13Space).
=RANDOMNUMBERGENERATION(5, 4, "Poisson", TRUE, 0.3, -1)
RANDOMNUMBERGENERATION returns the #ERROR(Lambda < 0).
RANDOM NUMBER GENERATION : POISSON
If Number < 0 or RandomNumber < 0, RANDOMNUMBERGENERATION returns the #ERROR.
RANDOMNUMBERGENERATION returns the #ERROR, if Lambda < 0.
| 0 | 1 | 1 |
| 1 | 0 | 2 |
| 0 | 2 | 1 |
| 1 | 1 | 1 |
| 0 | 0 | 1 |
| 1 | 1 | 2 |
| 0 | 1 | 0 |
| 2 | 2 | 1 |
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 13Space | |||
| Row2 | ||||
| Row3 | ||||
| Row4 | #ERROR | |||
| Row5 | ||||
| Row6 |
| File:Calci1.gif | $ |
| 0 | 0 | 0 |
| 1 | 0 | 1 |
| 1 | 0 | 1 |
| 0 | 0 | 0 |