Difference between revisions of "Manuals/calci/BERNOULLI"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution,  NewTableFlag, ProbabilityValue) where, '''N...")
 
 
(6 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''BERNOULLIDISTRIBUTED(k,p)'''</div><br/>
 +
*<math>k</math> represents the number of variables.
 +
*<math>p</math>  is the probability value.
  
'''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution,  NewTableFlag, ProbabilityValue)
+
==Description==
 +
*This function gives the value of the Bernoulli distribution.
 +
*It is  a discrete probability distribution.
 +
*Bernoulli distribution is the theoretical distribution of the number of successes in a finite set of independent trials with a constant probability of success.
 +
*The Bernoulli distribution is simply BINOM(1,P).
 +
*This distribution best describes all situations where a  trial  is made resulting in either  success or failure, such as when tossing a coin, or when modeling the success or failure.
 +
*<math>BERNOULLIDISTRIBUTED(k,p)</math> ,<math>k</math>  represents the number of variables.
 +
*<math>p</math> is the probability value. The <math>p</math> vaule is ranges from 0 to 1.
 +
*The Bernoulli distribution is defined by:<math>f(x)=p^x(1-p)^{1-x}</math> for x=0,1, where <math>p</math> is the probability that a particular event will occur.
 +
*The probability mass function is :<math>f(k,p) = \begin{cases}p if& k=1\\
 +
                                                            1-p if &k=0.
 +
                                                  \end{cases}</math>
 +
*This function will give the result as error when
 +
      1. Any one of the argument is nonnumeric.
 +
      2. The value of p<0 or p>1.
  
where,
+
==ZOS==
 +
*The syntax is to calculate this function in ZOS is <math>BERNOULLIDISTRIBUTED(a,b)</math>.
 +
**<math>a</math> represents the number of variables.
 +
**<math>b</math>  is the probability value.
 +
*For e.g.,BERNOULLIDISTRIBUTED(5,0.4)
 +
*BERNOULLIDISTRIBUTED(3..7,0.7)
  
'''Number '''- represents the number of variables.
+
==Examples==
 +
#=BERNOULLIDISTRIBUTED(5,0.5)=1    1    0  0  1,  0    0    0    0    0
 +
#=BERNOULLIDISTRIBUTED(3,0.2)= 0  0  0
  
'''RandomNumber '''- represents the number of random number
+
==Related Videos==
  
'''Distribution '''- represents the distribution method(i.e bernoulli) to create random values.
+
{{#ev:youtube|ry81_iSHt6E|280|center|Bernoulli Distribution}}
  
'''NewTableFlag''' - is the TRUE or FALSE.If set as TRUE,the result in new sheet. If NewTableFlag is omitted, it assumed to be FALSE.
+
==See Also==
 +
*[[Manuals/calci/KURT | KURT]]
 +
*[[Manuals/calci/MULTINOMIAL | MULTINOMIAL]]
  
'''ProbabilityValue '''- represents the probability value and should be in range 0 to 1.
+
==References==
 
+
*[http://en.wikipedia.org/wiki/Bernoulli_distribution BERNOULLI]
</div>
 
----
 
<div id="1SpaceContent" class="zcontent" align="left">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.</div>
 
----
 
<div id="7SpaceContent" class="zcontent" align="left">
 
 
 
Lets see an example in (Column1Row1)
 
 
 
<nowiki>=RANDOMNUMBERGENERATION(3, 4, "Bernoulli", TRUE, 0.5)</nowiki>
 
 
 
RANDOMNUMBERGENERATION returns the result in new sheet(5Space).
 
 
 
<nowiki>=RANDOMNUMBERGENERATION(5, 4, "Bernoulli", TRUE, -1)</nowiki>
 
 
 
RANDOMNUMBERGENERATION returns the #ERROR(ProbabilityValue &lt; 0).
 
 
 
</div>
 
----
 
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
 
 
RANDOM NUMBER GENERATION : BERNOULLI
 
 
 
</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 &lt; 0 or RandomNumber &lt; 0, RANDOMNUMBERGENERATION returns the #ERROR.
 
 
 
RANDOMNUMBERGENERATION returns the #ERROR, if ProbabilityValue &lt; 0 or ProbabilityValue &gt; 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="sshl_f" | 5Space
 
| class=" " |
 
| class=" " |
 
| class=" " |
 
|- class="even"
 
| class="  " | Row2
 
| class="    " |
 
| class=" " |
 
| class=" " |
 
| class=" " |
 
|- class="odd"
 
| Row3
 
| class=" " |
 
| class=" " |
 
| class=" " |
 
| class=" " |
 
|- class="even"
 
| Row4
 
| class="sshl_f" | #ERROR
 
| class=" " |
 
| class=" " |
 
| class=" " |
 
|- class="odd"
 
| class=" " | Row5
 
| 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=" " |
 
| 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="5SpaceContent" class="zcontent" align="left">
 
 
 
{| class="SpreadSheet blue"
 
|+ Random Number Generation<br />Bernoulli Distribution
 
|- class="even"
 
| 0
 
| 0
 
| 0
 
|- class="odd"
 
| 0
 
| 0
 
| 0
 
|- class="even"
 
| 0
 
| 1
 
| 1
 
|- class="odd"
 
| 0
 
| 0
 
| 1
 
|}
 
 
 
</div>
 
----
 

Latest revision as of 15:01, 7 December 2016

BERNOULLIDISTRIBUTED(k,p)


  • represents the number of variables.
  • is the probability value.

Description

  • This function gives the value of the Bernoulli distribution.
  • It is a discrete probability distribution.
  • Bernoulli distribution is the theoretical distribution of the number of successes in a finite set of independent trials with a constant probability of success.
  • The Bernoulli distribution is simply BINOM(1,P).
  • This distribution best describes all situations where a trial is made resulting in either success or failure, such as when tossing a coin, or when modeling the success or failure.
  • , represents the number of variables.
  • is the probability value. The vaule is ranges from 0 to 1.
  • The Bernoulli distribution is defined by: for x=0,1, where is the probability that a particular event will occur.
  • The probability mass function is :
  • This function will give the result as error when
      1. Any one of the argument is nonnumeric.
      2. The value of p<0 or p>1.

ZOS

  • The syntax is to calculate this function in ZOS is .
    • represents the number of variables.
    • is the probability value.
  • For e.g.,BERNOULLIDISTRIBUTED(5,0.4)
  • BERNOULLIDISTRIBUTED(3..7,0.7)

Examples

  1. =BERNOULLIDISTRIBUTED(5,0.5)=1 1 0 0 1, 0 0 0 0 0
  2. =BERNOULLIDISTRIBUTED(3,0.2)= 0 0 0

Related Videos

Bernoulli Distribution

See Also

References