Manuals/calci/PATTERNED - Revision history

Swapna at 18:41, 13 May 2015

2015-05-13T18:41:15Z

Swapna: /* Examples */

2014-04-02T20:24:25Z

Examples

Swapna at 20:56, 31 March 2014

2014-03-31T20:56:44Z

Swapna at 20:55, 31 March 2014

2014-03-31T20:55:09Z

Swapna at 20:46, 31 March 2014

2014-03-31T20:46:33Z

Swapna at 20:41, 31 March 2014

2014-03-31T20:41:39Z

Show changes

MassBot1: Created page with "
'''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution, NewTableFlag, FromNum, ToNum, StepSize, NumRep) ..."

2013-10-25T02:41:53Z

Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution, NewTableFlag, FromNum, ToNum, StepSize, NumRep) ..."

New page

<div id="6SpaceContent" class="zcontent" align="left">

'''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.

</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>

RANDOMNUMBERGENERATION returns the result in new sheet(143Space).

<nowiki>=RANDOMNUMBERGENERATION(5, 4, "Patterned", TRUE, 2, 5, 3, -1)</nowiki>

RANDOMNUMBERGENERATION returns the #ERROR(NumRep < 0).

</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">

RANDOM NUMBER GENERATION : PATTERNED

</div></div>
----
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
----
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
----
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
----
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
----
<div id="8SpaceContent" class="zcontent" align="left">

If Number < 0 or RandomNumber < 0, RANDOMNUMBERGENERATION returns the #ERROR.

RANDOMNUMBERGENERATION returns the #ERROR, if StepSize < 0 or NumRep < 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"
|+ Random Number Generation<br />Poisson Distribution
|- class="even"
| 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"
|+ Default Calci
|- class="even"
| class=" " |
| Column1
| Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class=" " | 14Space
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| class=" " | Row2
| class=" " |
| 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>
| class=" " |
| class=" " |
|- class="odd"
| Row3
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| Row4
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
| class=" " | Row5
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| Row6
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|}

{|
| <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>
----
<div id="13SpaceContent" class="zcontent" align="left">

{| class="SpreadSheet blue"
|+ 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>
----

@@ Line 150: / Line 150: @@
 | 6
 |}
 == See Also ==

@@ Line 30: / Line 30: @@
 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 -
-{| class="wikitable"
+<div id="13SpaceContent" class="zcontent" align="left">
-|-
+{| class="SpreadSheet blue"
 |+ RANDOM NUMBER GENERATION<br />PATTERNED DISTRIBUTION
-|-
+|- class="even"
-| 2 || 2 || 2 || 2 || 2
+| 2
-|-
+| 2
-| 2 || 2 || 2 || 2 || 2
+| 2
-|-
+| 2
-| 4 || 4 || 4 || 4 || 4
+| 2
-|-
+|- class="odd"
-| 4 || 4 || 4 || 4 || 4
+| 2
-|-
+| 2
-| 6 || 6 || 6 || 6 || 6
+| 2
-|-
+| 2
-| 6 || 6 || 6 || 6 || 6
+| 2
-|-
+|- class="even"
 |}
   =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 -
-{| class="wikitable"
+<div id="13SpaceContent" class="zcontent" align="left">
-|-
+{| class="SpreadSheet blue"
 |+ RANDOM NUMBER GENERATION<br />PATTERNED DISTRIBUTION
-|-
+|- class="even"
-| 2 || 2 || 2 || 2 || 2
+| 2
-|-
+| 2
-| 2 || 2 || 2 || 2 || 2
+| 2
-|-
+| 2
-| 4 || 4 || 4 || 4 || 4
+| 2
-|-
+|- class="odd"
-| 4 || 4 || 4 || 4 || 4
+| 2
-|-
+| 2
-| 6 || 6 || 6 || 6 || 6
+| 2
-|-
+| 2
-| 6 || 6 || 6 || 6 || 6
+| 2
-|-
+|- class="even"
-| 2 || 2 || 2 || 2 || 2
+| 4
-|-
+| 4
-| 2 || 2 || 2 || 2 || 2
+| 4
-|-
+| 4
-| 4 || 4 || 4 || 4 || 4
+| 4
-|-
+|- class="odd"
-| 4 || 4 || 4 || 4 || 4
+| 4
-|-
+| 4
-| 6 || 6 || 6 || 6 || 6
+| 4
-|-
+| 4
-| 6 || 6 || 6 || 6 || 6
+| 4
-|-
+|- class="even"
 |}

@@ Line 32: / Line 32: @@
 {| class="wikitable"
 |-
-|+ Random Number Generation<br />Patterned Distribution
+|+ RANDOM NUMBER GENERATION<br />PATTERNED DISTRIBUTION
 |-
 | 2 || 2 || 2 || 2 || 2
@@ Line 54: / Line 54: @@
 {| class="wikitable"
 |-
-|+ Random Number Generation<br />Patterned Distribution
+|+ RANDOM NUMBER GENERATION<br />PATTERNED DISTRIBUTION
 |-
 | 2 || 2 || 2 || 2 || 2

@@ Line 31: / Line 31: @@
 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 -
 {| class="wikitable"
 |-
 | 2 || 2 || 2 || 2 || 2
@@ Line 51: / Line 53: @@
 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 -
 {| class="wikitable"
 |-
 | 2 || 2 || 2 || 2 || 2

@@ Line 23: / Line 23: @@
 *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.
+*<math>StepSize</math> represents the step size in between the given numbers. e.g. In the range of numbers 1 to 7 in steps of 2 are considered as 1,3,5,7.
 =Examples=
@@ Line 30: / Line 30: @@
 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 -
 {| class="wikitable"
 |-
@@ Line 51: / Line 50: @@
 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 -
 {| class="wikitable"
 |-