Difference between revisions of "Manuals/calci/PATTERNED"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution,  NewTableFlag, FromNum, ToNum, StepSize, NumRep) ...")
 
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
=RANDOMNUMBERGENERATION(NumVariable,RandomNumber,Distribution,NewTableFlag,FromNum,ToNum,StepSize,NumRep,SeqRep)=
−
 
 
−
'''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution,  NewTableFlag, FromNum, ToNum, StepSize, NumRep)
 
  
 
where,
 
where,
 +
*<math>NumVariable</math> represents the number of columns for displaying the random numbers,
 +
*<math>RandomNumber</math> represents the number of rows for displaying the random numbers,
 +
*<math>Distribution</math> is the distribution method (i.e. "Patterned") for creating random values,
 +
*<math>NewTableFlag</math> is the flag TRUE or FALSE.
 +
*<math>FromNum</math> represents the starting number,
 +
*<math>ToNum</math> represents the ending number,
 +
*<math>StepSize</math> represents the step size in between the given numbers,
 +
*<math>NumRep</math> represents the number of times the resulting numbers are to be repeated,
 +
*<math>SeqRep</math> represents the number of times the result sequence has to be repeated.
  
−
'''Number '''- represents the number of variables.
+
PATTERNED RANDOMNUMBERGENERATION() is used to display the random numbers in which one occurrence can have repeating number and sequence in between the start and the end numbers.
−
 
 
−
'''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.
 
−
 
 
−
</div>
 
−
----
 
−
<div id="1SpaceContent" class="zcontent" align="left">A patterned distribution is a distribution  of random occurrences in which one occurrence has repeating number and sequence in between start and end number.</div>
 
−
----
 
−
<div id="7SpaceContent" class="zcontent" align="left">
 
−
 
 
−
Lets see an example in (Column1Row1)
 
  
−
<nowiki>=RANDOMNUMBERGENERATION(3, 4, "Patterned", TRUE,1, 5, 3, 4 )</nowiki>
+
=Description=
  
−
RANDOMNUMBERGENERATION returns the result in new sheet(143Space).
+
RANDOMNUMBERGENERATION(NumVariable,RandomNumber,"Patterned",FromNum,ToNum,StepSize,NumRep,SeqRep)
  
−
<nowiki>=RANDOMNUMBERGENERATION(5, 4, "Patterned", TRUE, 2, 5, 3, -1)</nowiki>
+
*A Patterned Distribution is a distribution of random occurrences in which one occurrence has repeating number and sequence in between the start and the end numbers.
 +
*If <math>NewTableFlag</math> is TRUE, the result is displayed on new zspace.
 +
*If <math>NewTableFlag</math> is FALSE, the result is displayed on the same zcube. If omitted, it is assumed to be FALSE.
 +
*If <math>NumVariable</math> &lt;0 or <math>RandomNumber</math> &lt;0, Calci displays an error message.
 +
*<math>ToNum</math> should be &gt; <math>FromNum</math>, else Calci returns an error message.
  
−
RANDOMNUMBERGENERATION returns the #ERROR(NumRep &lt; 0).
 
  
−
</div>
+
=Examples=
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
−
RANDOM NUMBER GENERATION : PATTERNED
+
=RANDOMNUMBERGENERATION(5,4,"Patterned",TRUE,2,6,2,2)
 +
 +
The above command displays the random numbers from 2 to 6 in steps of 2. The numbers are repeated twice and result is displayed in 5 columns and 4 rows in a separate zspace as -
  
−
</div></div>
+
{| class="wikitable"
−
----
+
|-
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
+
| 2 || 2 || 2 || 2 || 2
−
----
+
|-
−
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
+
| 2 || 2 || 2 || 2 || 2
−
----
+
|-
−
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
+
| 4 || 4 || 4 || 4 || 4
−
----
+
|-
−
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
+
| 4 || 4 || 4 || 4 || 4
−
----
+
|-
−
<div id="8SpaceContent" class="zcontent" align="left">
+
| 6 || 6 || 6 || 6 || 6
−
 
+
|-
−
If Number &lt; 0 or RandomNumber &lt; 0, RANDOMNUMBERGENERATION returns the #ERROR.
+
| 6 || 6 || 6 || 6 || 6
−
 
+
|-
−
RANDOMNUMBERGENERATION returns the #ERROR, if StepSize &lt; 0 or NumRep &lt; 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"
+
=RANDOMNUMBERGENERATION(5,4,"Patterned",TRUE,2,6,2,2,2)
−
|+ Random Number Generation<br />Poisson Distribution
+
−
|- class="even"
+
The above command displays the random numbers from 2 to 6 in steps of 2. The numbers are repeated twice. Also the whole sequence is repeated twice and result is displayed in 5 columns and 4 rows in a separate zspace as -
−
| 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"
+
{| class="wikitable"
−
|+ Default Calci
+
|-
−
|- class="even"
+
| 2 || 2 || 2 || 2 || 2
−
| class=" " |
+
|-
−
| Column1
+
| 2 || 2 || 2 || 2 || 2
−
| Column2
+
|-
−
| Column3
+
| 4 || 4 || 4 || 4 || 4
−
| Column4
+
|-
−
|- class="odd"
+
| 4 || 4 || 4 || 4 || 4
−
| class=" " | Row1
+
|-
−
| class=" " | 14Space
+
| 6 || 6 || 6 || 6 || 6
−
| class=" " |
+
|-
−
| class=" " |
+
| 6 || 6 || 6 || 6 || 6
−
| class=" " |
+
|-
−
|- class="even"
+
| 2 || 2 || 2 || 2 || 2
−
| class="  " | Row2
+
|-
−
| class="  " |
+
| 2 || 2 || 2 || 2 || 2
−
| class="  SelectTD1  SelectTD1 ChangeBGColor" |
+
|-
−
<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>
+
| 4 || 4 || 4 || 4 || 4
−
| class=" " |
+
|-
−
| class=" " |
+
| 4 || 4 || 4 || 4 || 4
−
|- class="odd"
+
|-
−
| Row3
+
| 6 || 6 || 6 || 6 || 6
−
| class="  " |
+
|-
−
| class=" " |
+
| 6 || 6 || 6 || 6 || 6
−
| class=" " |
+
|-
−
| class=" " |
 
−
|- class="even"
 
−
| Row4
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="even"
 
−
| Row6
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
 
|}
 
|}
  
−
{|
+
== See Also ==
−
| <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>
+
*[[Manuals/calci/RANDOMNUMBERGENERATION | RANDOMNUMBERGENERATION]]
−
----
+
*[[Manuals/calci/DISCRETE | DISCRETE]]
−
<div id="13SpaceContent" class="zcontent" align="left">
 
  
−
{| class="SpreadSheet blue"
+
== References ==
−
|+ Random Number Generation<br />Patterned Distribution
 
−
|- class="even"
 
−
| 1
 
−
| 1
 
−
| 1
 
−
|- class="odd"
 
−
| 1
 
−
| 1
 
−
| 1
 
−
|- class="even"
 
−
| 1
 
−
| 1
 
−
| 1
 
−
|- class="odd"
 
−
| 3
 
−
| 3
 
−
| 3
 
−
|- class="even"
 
−
| 3
 
−
| 3
 
−
| 3
 
−
|- class="odd"
 
−
| 3
 
−
| 3
 
−
| 3
 
−
|- class="even"
 
−
| 5
 
−
| 5
 
−
| 5
 
−
|- class="odd"
 
−
| 5
 
−
| 5
 
−
| 5
 
−
|- class="even"
 
−
| 5
 
−
| 5
 
−
| 5
 
−
|}
 
  
−
</div>
+
*[http://en.wikipedia.org/wiki/Random_number_generation Random Number Generation]
−
----
 

Revision as of 15:41, 31 March 2014

RANDOMNUMBERGENERATION(NumVariable,RandomNumber,Distribution,NewTableFlag,FromNum,ToNum,StepSize,NumRep,SeqRep)

where,

  • represents the number of columns for displaying the random numbers,
  • represents the number of rows for displaying the random numbers,
  • is the distribution method (i.e. "Patterned") for creating random values,
  • is the flag TRUE or FALSE.
  • represents the starting number,
  • represents the ending number,
  • represents the step size in between the given numbers,
  • represents the number of times the resulting numbers are to be repeated,
  • represents the number of times the result sequence has to be repeated.

PATTERNED RANDOMNUMBERGENERATION() is used to display the random numbers in which one occurrence can have repeating number and sequence in between the start and the end numbers.

Description

RANDOMNUMBERGENERATION(NumVariable,RandomNumber,"Patterned",FromNum,ToNum,StepSize,NumRep,SeqRep)

  • A Patterned Distribution is a distribution of random occurrences in which one occurrence has repeating number and sequence in between the start and the end numbers.
  • If is TRUE, the result is displayed on new zspace.
  • If is FALSE, the result is displayed on the same zcube. If omitted, it is assumed to be FALSE.
  • If <0 or <0, Calci displays an error message.
  • should be > , else Calci returns an error message.


Examples

=RANDOMNUMBERGENERATION(5,4,"Patterned",TRUE,2,6,2,2)

The above command displays the random numbers from 2 to 6 in steps of 2. The numbers are repeated twice and result is displayed in 5 columns and 4 rows in a separate zspace as -

2 2 2 2 2
2 2 2 2 2
4 4 4 4 4
4 4 4 4 4
6 6 6 6 6
6 6 6 6 6 


=RANDOMNUMBERGENERATION(5,4,"Patterned",TRUE,2,6,2,2,2)

The above command displays the random numbers from 2 to 6 in steps of 2. The numbers are repeated twice. Also the whole sequence is repeated twice and result is displayed in 5 columns and 4 rows in a separate zspace as -

2 2 2 2 2
2 2 2 2 2
4 4 4 4 4
4 4 4 4 4
6 6 6 6 6
6 6 6 6 6
2 2 2 2 2
2 2 2 2 2
4 4 4 4 4
4 4 4 4 4
6 6 6 6 6
6 6 6 6 6

See Also

References

Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/PATTERNED&oldid=198321"