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