Manuals/calci/DISCRETE
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.
Lets see an example in (Column1Row1)
=RANDOMNUMBERGENERATION(3, 4, "discrete", TRUE,[4,5,6,3,2,1],[0.2,0.1,0.3,0.2,0.1,0.1])
RANDOMNUMBERGENERATION returns the result in new sheet(13Space).
=RANDOMNUMBERGENERATION(5, 4, "discrete", TRUE, [2,1],[0.3,0.9])
RANDOMNUMBERGENERATION returns the #ERROR(sumofProbability >1).
RANDOM NUMBER GENERATION : DISCRETE
If Number < 0 or RandomNumber < 0, RANDOMNUMBERGENERATION returns the #ERROR.
RANDOMNUMBERGENERATION returns the #ERROR, if Probability< 0 or Probability >1.
| 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 | ||||
| Row5 | ||||
| Row6 |
| File:Calci1.gif | $ |
| 1 | 6 | 6 |
| 4 | 5 | 5 |
| 3 | 1 | 6 |
| 3 | 6 | 3 |