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

File:Calci1.gif

$

---

Random Number Generation
Bernoulli Distribution

0	0	0
0	0	0
0	1	1
0	0	1

---