Manuals/calci/RANDOMNUMBERGENERATION

Revision as of 21:43, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''RANDOMNUMBERGENERATION'''(Number, RandomNumber, "uniform",  NewTableFlag, MinNum, MaxNum) '''RANDOMNUMBERGENE...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.


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.


Lets see an example in (Column1Row1)

=RANDOMNUMBERGENERATION(3, 4, "Uniform", TRUE, 3, 4)

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

=RANDOMNUMBERGENERATION(3, 4, "Bernoulli", TRUE, 0.5)

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

=RANDOMNUMBERGENERATION(3, 4, "Binomial", TRUE, 0.75, 5)

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

=RANDOMNUMBERGENERATION(3, 4, "Normal", TRUE, 0, 4)

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

=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(15Space).

=RANDOMNUMBERGENERATION(3, 4, "Patterned", TRUE,1, 5, 3, 4 )

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

=RANDOMNUMBERGENERATION(-3, 4, "Uniform", TRUE, 3, 4)

RANKANDPERCENTILE returns the #ERROR(Number < 0).

 

RANDOM NUMBER GENERATION


Syntax

Remarks

Examples

Description

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.


Default Calci
Column1 Column2 Column3 Column4
Row1 5Space 16Space
Row2 9Space
Row3
Row4 13Space 15Space
Row5
Row6 14Space
File:Calci1.gif

File:Bold.gif

File:Italic.gif

File:Normal.gif

File:Underline.gif

File:Border.gif

File:Numbers.gif

File:Sort.gif

File:Formatcells.gif

File:Graphs.gif

$

Random Number Generation
Uniform Distribution
3.0065124671093137 3.677568717214598 3.4744283915732352
3.163743257588417 3.6853662386924406 3.0128586791349416
3.4533329456853092 3.0895808098399992 3.1303954347733547
3.55900044450085 3.0393674387757006 3.0808581511315527

Random Number Generation
Bernoulli Distribution
0 1 1
1 1 0
1 0 1
0 1 0

Random Number Generation
Normal Distribution
7.3992591238306735 -6.403583675547587 5.264094078919947
1.1468478642534703 1.6270109725799506 -5.689357936346091
-4.82901237541827 -4.166206583582642 -4.860569757430193
2.9239233886923936 -5.044394778185275 2.9528738508087664

Random Number Generation
Binomial Distribution
5 4 4
5 4 4
4 5 5
4 5 4

Random Number Generation
Discrete Distribution
1 4 6
1 1 3
5 3 2
1 6 3

Random Number Generation
Patterned Distribution
1 1 1
1 1 1
1 1 1
1 1 1
4 4 4
4 4 4
4 4 4
4 4 4
5 5 5
5 5 5
5 5 5
5 5 5