Manuals/calci/RANDOMNUMBERGENERATION - Revision history

Devika at 22:25, 24 July 2018

2018-07-24T22:25:19Z

Devika at 22:24, 24 July 2018

2018-07-24T22:24:59Z

Jayaram at 13:01, 14 March 2017

2017-03-14T13:01:15Z

Swapna: /* See Also */

2015-04-27T21:10:52Z

Swapna at 21:10, 27 April 2015

2015-04-27T21:10:11Z

Swapna at 20:59, 31 July 2014

2014-07-31T20:59:05Z

Swapna at 20:28, 1 April 2014

2014-04-01T20:28:43Z

Swapna at 20:27, 1 April 2014

2014-04-01T20:27:52Z

Swapna at 20:16, 1 April 2014

2014-04-01T20:16:18Z

Show changes

MassBot1: Created page with "
'''RANDOMNUMBERGENERATION'''(Number, RandomNumber, "uniform", NewTableFlag, MinNum, MaxNum) '''RANDOMNUMBERGENE..."

2013-10-25T02:43:03Z

Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''RANDOMNUMBERGENERATION'''(Number, RandomNumber, "uniform", NewTableFlag, MinNum, MaxNum) '''RANDOMNUMBERGENE..."

New page

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

'''RANDOMNUMBERGENERATION'''(Number, RandomNumber, "uniform", NewTableFlag, MinNum, MaxNum)

'''RANDOMNUMBERGENERATION'''(Number, RandomNumber, "normal", NewTableFlag, Mean, StandardDeviation)

'''RANDOMNUMBERGENERATION'''(Number, RandomNumber, "binomial", NewTableFlag, ProbabilityValue,Trials)

'''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution(bernoulli), NewTableFlag, ProbabilityValue)

'''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution(patterned), NewTableFlag, FromNum, ToNum, StepSize, NumRep)

'''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution(discrete), NewTableFlag, Value, Probability)

where,

'''Number '''- represents the number of variables.

'''RandomNumber '''- represents the number of random number

'''Distribution '''- represents the distribution method(i.e uniform, normal, binomial, bernoulli, patterned, 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.

'''MinNum '''- represents the lower bound.

'''MaxNum '''- represents the upper bound.

'''Mean '''- represents the Mean.

'''StandardDeviation '''- represents the standard deviation.

'''ProbabilityValue '''- represents the probability value and should be in range 0 to 1.

'''Trails''' - represents the number of trials.

'''ProbabilityValue '''- represents the probability value and should be in range 0 to 1.

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

In Uniform Distribution, elements has an equal probability of being chosen at each draw.

Normal Distribution characterized by a mean and a standard deviation.

In Binomial Distribution, the frequency distribution of the probability of a specified number of successes is an arbitrary number of repeated independent Bernoulli trials.

A theoretical distribution of the number of successes in a finite set of independent trials with a constant probability of success is called bernoulli distribution.A theoretical distribution of the number of successes.

A patterned distribution is a distribution of random occurrences in which one occurrence has repeating number and sequence in between start and end number.

A discrete distribution is a distribution of a random variable that takes only finite set of values.

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

Lets see an example in (Column1Row1)

<nowiki>=RANDOMNUMBERGENERATION(3, 4, "Uniform", TRUE, 3, 4)</nowiki>

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

<nowiki>=RANDOMNUMBERGENERATION(3, 4, "Bernoulli", TRUE, 0.5)</nowiki>

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

<nowiki>=RANDOMNUMBERGENERATION(3, 4, "Binomial", TRUE, 0.75, 5)</nowiki>

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

<nowiki>=RANDOMNUMBERGENERATION(3, 4, "Normal", TRUE, 0, 4)</nowiki>

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

<nowiki>=RANDOMNUMBERGENERATION(3, 4, "discrete", TRUE,[4,5,6,3,2,1],[0.2,0.1,0.3,0.2,0.1,0.1])</nowiki>

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

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

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

<nowiki>=RANDOMNUMBERGENERATION(-3, 4, "Uniform", TRUE, 3, 4)</nowiki>

RANKANDPERCENTILE returns the #ERROR(Number < 0).

<span class="zCubesMenuIconTop" title="Account Management, Profiles and Documents"> <br /></span></div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">

RANDOM NUMBER GENERATION

</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 ProbabilityValue < 0 or ProbabilityValue > 1, Trails < 0, Probability< 0 or Probability >1,StepSize < 0 or NumRep < 0.

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

{| id="TABLE3" class="SpreadSheet blue"
|+ Default Calci
|- class="even"
| class=" " |
| Column1
| class=" " | Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f" | 5Space
| class=" " |
| class="sshl_f" | 16Space
| class=" " |
|- class="even"
| class=" " | Row2
| class=" 1" |
| class="sshl_f" | 9Space
| class=" SelectTD1 ChangeBGColor SelectTD1" |
<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="odd"
| Row3
| class="sshl_f" |
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| Row4
| class="sshl_f" | 13Space
| class=" 1" |
| class="sshl_f" | 15Space
| class=" " |
|- class="odd"
| class=" " | Row5
| class=" " |
| class="sshl_f" |
| class=" " |
| class=" " |
|- class="even"
| Row6
| class="sshl_f" | 14Space
| 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="5SpaceContent" class="zcontent" align="left">

{| class="SpreadSheet blue"
|+ Random Number Generation<br />Uniform Distribution
|- class="even"
| 3.0065124671093137
| 3.677568717214598
| 3.4744283915732352
|- class="odd"
| 3.163743257588417
| 3.6853662386924406
| 3.0128586791349416
|- class="even"
| 3.4533329456853092
| 3.0895808098399992
| 3.1303954347733547
|- class="odd"
| 3.55900044450085
| 3.0393674387757006
| 3.0808581511315527
|}

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

{| class="SpreadSheet blue"
|+ Random Number Generation<br />Bernoulli Distribution
|- class="even"
| 0
| 1
| 1
|- class="odd"
| 1
| 1
| 0
|- class="even"
| 1
| 0
| 1
|- class="odd"
| 0
| 1
| 0
|}

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

{| class="SpreadSheet blue"
|+ Random Number Generation<br />Normal Distribution
|- class="even"
| 7.3992591238306735
| -6.403583675547587
| 5.264094078919947
|- class="odd"
| 1.1468478642534703
| 1.6270109725799506
| -5.689357936346091
|- class="even"
| -4.82901237541827
| -4.166206583582642
| -4.860569757430193
|- class="odd"
| 2.9239233886923936
| -5.044394778185275
| 2.9528738508087664
|}

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

{| class="SpreadSheet blue"
|+ Random Number Generation<br />Binomial Distribution
|- class="even"
| 5
| 4
| 4
|- class="odd"
| 5
| 4
| 4
|- class="even"
| 4
| 5
| 5
|- class="odd"
| 4
| 5
| 4
|}

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

{| class="SpreadSheet blue"
|+ Random Number Generation<br />Discrete Distribution
|- class="even"
| 1
| 4
| 6
|- class="odd"
| 1
| 1
| 3
|- class="even"
| 5
| 3
| 2
|- class="odd"
| 1
| 6
| 3
|}

</div>
----
<div id="16SpaceContent" 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"
| 1
| 1
| 1
|- class="even"
| 4
| 4
| 4
|- class="odd"
| 4
| 4
| 4
|- class="even"
| 4
| 4
| 4
|- class="odd"
| 4
| 4
| 4
|- class="even"
| 5
| 5
| 5
|- class="odd"
| 5
| 5
| 5
|- class="even"
| 5
| 5
| 5
|- class="odd"
| 5
| 5
| 5
|}

</div>
----

← Older revision		Revision as of 22:25, 24 July 2018
Line 1:		Line 1:
	<div style="font-size:30px">'''RANDOMNUMBERGENERATION()'''</div><br/>		<div style="font-size:30px">'''RANDOMNUMBERGENERATION()'''</div><br/>

−	RANDOMNUMBERGENERATION(), creates a number of several types of random numbers including Uniform, Normal, Bernoulli, Poisson, Patterned and Discrete.	+	**RANDOMNUMBERGENERATION(), creates a number of several types of random numbers including Uniform, Normal, Bernoulli, Poisson, Patterned and Discrete.

← Older revision		Revision as of 22:24, 24 July 2018
Line 1:		Line 1:
−	=RANDOMNUMBERGENERATION()=	+	<div style="font-size:30px">'''RANDOMNUMBERGENERATION()'''</div><br/>
		+
		+	RANDOMNUMBERGENERATION(), creates a number of several types of random numbers including Uniform, Normal, Bernoulli, Poisson, Patterned and Discrete.

−	~~RANDOMNUMBERGENERATION() creates a number of several types of random numbers including Uniform, Normal, Bernoulli, Binomial, Poisson, Patterned and Discrete.~~

	== Description ==		== Description ==

← Older revision		Revision as of 13:01, 14 March 2017
Line 286:		Line 286:
	== References ==		== References ==
	*[http://en.wikipedia.org/wiki/Random_number_generation Random Number Generation]		*[http://en.wikipedia.org/wiki/Random_number_generation Random Number Generation]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 282: / Line 282: @@
 ==See Also==
-*[[Manuals/calci/RAND RAND]]
+*[[Manuals/calci/RAND | RAND]]
 == References ==
 *[http://en.wikipedia.org/wiki/Random_number_generation Random Number Generation]

@@ Line 275: / Line 275: @@
 | 6
 |}
 == References ==
 *[http://en.wikipedia.org/wiki/Random_number_generation Random Number Generation]

← Older revision		Revision as of 20:59, 31 July 2014
Line 125:		Line 125:

	=RANDOMNUMBERGENERATION(3, 4, "Bernoulli", TRUE, 0.5)		=RANDOMNUMBERGENERATION(3, 4, "Bernoulli", TRUE, 0.5)
		+
		+	The above command displays the random numbers with probability value '0.5'. The numbers are displayed in 3 columns and 4 rows in a separate zspace as -
		+
		+	<div id="13SpaceContent" class="zcontent" align="left">
		+
		+	{\| class="SpreadSheet blue"
		+	\|+ RANDOM NUMBER GENERATION<br />BERNOULLI DISTRIBUTION
		+	\|- class="even"
		+	\| 1
		+	\| 0
		+	\| 0
		+	\|- class="odd"
		+	\| 1
		+	\| 1
		+	\| 0
		+	\|- class="even"
		+	\| 1
		+	\| 0
		+	\| 1
		+	\|- class="odd"
		+	\| 0
		+	\| 1
		+	\| 1
		+	\|}

@@ Line 46: / Line 46: @@
 RANDOMNUMBERGENERATION(NumVariable,RandomNumber,"Discrete",Value,Probability)
 where,
@@ Line 66: / Line 65: @@
 *<math>Value</math> is the number value,
 *<math>Probability</math> is the probability value between 0 to 1. The addition of all probabilities in the array should be equal to 1.
 =Examples=

@@ Line 40: / Line 40: @@
 RANDOMNUMBERGENERATION(NumVariable,RandomNumber,"Patterened",NewTableFlag,FromNum,ToNum,StepSize,NumRep,SeqRep)
 )'''RANDOM NUMBER GENERATION - DISCRETE'''
@@ Line 155: / Line 154: @@
 | 2
 |}
 )'''RANDOM NUMBER GENERATION - POISSON'''