Manuals/calci/BERNOULLI

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

where,

Number - represents the number of variables.

RandomNumber - represents the number of random number

Distribution - represents the distribution method(i.e bernoulli) 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.

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

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.

Lets see an example in (Column1Row1)

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

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

=RANDOMNUMBERGENERATION(5, 4, "Bernoulli", TRUE, -1)

RANDOMNUMBERGENERATION returns the #ERROR(ProbabilityValue < 0).

RANDOM NUMBER GENERATION : BERNOULLI

Syntax

Remarks

Examples

Description

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

RANDOMNUMBERGENERATION returns the #ERROR, if ProbabilityValue < 0 or ProbabilityValue > 1.

Default Calci
	Column1	Column2	Column3	Column4
Row1	5Space
Row2
Row3
Row4	#ERROR
Row5	File:Copy-cube.gif
Row6

$

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