Manuals/calci/PATTERNED
RANDOMNUMBERGENERATION(Number, RandomNumber, Distribution, NewTableFlag, FromNum, ToNum, StepSize, NumRep)
where,
Number - represents the number of variables.
RandomNumber - represents the number of random number
Distribution - represents the distribution method(i.e patterned) 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.
FromNum - represents the start number.
ToNum - represents the end number.
StepSize - represents the repeating the number.
NumRep - represents the repeating the sequence.
Lets see an example in (Column1Row1)
=RANDOMNUMBERGENERATION(3, 4, "Patterned", TRUE,1, 5, 3, 4 )
RANDOMNUMBERGENERATION returns the result in new sheet(143Space).
=RANDOMNUMBERGENERATION(5, 4, "Patterned", TRUE, 2, 5, 3, -1)
RANDOMNUMBERGENERATION returns the #ERROR(NumRep < 0).
RANDOM NUMBER GENERATION : PATTERNED
If Number < 0 or RandomNumber < 0, RANDOMNUMBERGENERATION returns the #ERROR.
RANDOMNUMBERGENERATION returns the #ERROR, if StepSize < 0 or NumRep < 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 | 14Space | |||
| Row2 | ||||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
| File:Calci1.gif | $ |
| 1 | 1 | 1 |
| 1 | 1 | 1 |
| 1 | 1 | 1 |
| 3 | 3 | 3 |
| 3 | 3 | 3 |
| 3 | 3 | 3 |
| 5 | 5 | 5 |
| 5 | 5 | 5 |
| 5 | 5 | 5 |