Difference between revisions of "Manuals/calci/NEGBINOMDIST"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''NEGBINOMDIST'''('''nf''','''ns''','''ps''') '''Where nf'''   is number of failures,ns   is the threshold num...")
 
 
(17 intermediate revisions by 4 users not shown)
Line 1: Line 1:
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''NEGBINOMDIST(x,r,p)'''</div><br/>
 +
*<math>x</math> is the number of failures.
 +
*<math>r</math> is the number of successes on an individual trial
 +
*<math>p</math> is the probability of a success.
 +
**NEGBINOMDIST(), returns the negative binomial distribution.
  
'''NEGBINOMDIST'''('''nf''','''ns''','''ps''')
+
==Description==
 +
*This function gives the Negative Binomial Distribution.
 +
*Negative Binomial Distribution is the discrete probability distribution with the fixed probability of success.
 +
*It is also called Pascal Distribution.
 +
This is the statistical experiment with the following conditions:
 +
This experiment consists of a sequence of independent trials.
 +
Each trial represents only two results(Success or failure)
 +
The probability of success is constant from trial to trial
 +
The trials are independent; ie, the outcome on one trial does not affect the outcome on other trials.
 +
The experiment continues until <math>r</math> the successes is obtained, where <math>r</math> is a specified positive integer.
 +
*The random variable <math>x</math> = the number of failures that precede the <math>r^{th}</math> success;
 +
*<math>x</math> is called a Negative Binomial Random variable because, in contrast to the
 +
binomial random variable, the number of successes is fixed and the number of trials is random.
 +
*Then probability mass function of the negative binomial distribution is
 +
:<math>nb(x;r,p)=(x+r-1 p^r (1-p)^x r-1)</math>
 +
*For example: If a fair coin is tossed repeatedly, what is the probability that at least 10 tosses are required.
 +
to obtain heads 8 times
 +
*This function will give the result as error when:
 +
#Any argument is non-numeric
 +
#If <math>ps<0</math> or <math>ps>1</math>
 +
#If <math>nf<0</math> or <math>ns<1</math>
  
'''Where nf'''   is number of failures,ns   is the threshold number of successes and ps  is the probability of a success.
+
==ZOS==
 +
*The syntax is to calculate NEGBINOMDIST in ZOS is <math>NEGBINOMDIST(x,r,p)</math>.
 +
**where <math>x</math> is the number of failures.
 +
**<math>r</math> is the number of successes on an individual trial
 +
**<math>p</math> is the probability of a success.
 +
*For e.g.,NEGBINOMDIST(8..9,5..7,0.5).
 +
{{#ev:youtube|GCR9HjTgLk4|280|center|Negative Binomial Distribution}}
  
</div>
+
==Examples==
----
+
#Find the probability that a man flipping a coin gets the fourth head on the ninth flip.
<div id="1SpaceContent" class="zcontent" align="left">
+
Here  total number of events =9, r= 4(since we define Heads as a success) and x=9-4=5(number of failures)
 +
p=1/2=0.5(Probability of success for any coin flip)
 +
NEGBINOMDIST(5,4,0.5)=0.109375
 +
#A company conducts a geological study that indicates that an exploratory goods well should have a 20% chance of striking goods. What is the probability that the first strike comes on the third well drilled?
 +
Here total number of events=3, r=1,x=3-1=2,and p=0.20
 +
NEGBINOMDIST(2,1,0.20)=0.128
 +
#What is the probability that the fourth strike comes on the eighth well drilled?
 +
Here total number of events=8, r=4, x=8-4=4 and p=0.20
 +
NEGBINOMDIST(4,4,0.20)=0.0229376
  
It calculates the negative binomial distribution.
+
==Related Videos==
  
</div>
+
{{#ev:youtube|BPlmjp2ymxw|280|center|Negative Binomial Distribution}}
----
 
<div id="7SpaceContent" class="zcontent" align="left">
 
  
·          nf and ns  are integers.
+
==See Also==
 +
*[[Manuals/calci/LN  | LN ]]
 +
*[[Manuals/calci/IMLOG10  | IMLOG10 ]]
 +
*[[Manuals/calci/LOG  | LOG ]]
  
·          NEGBINOMDIST displays error , when any argument is nonnumeric.
 
  
·          The equation for the negative binomial distribution is:
+
==References==
 +
[http://en.wikipedia.org/wiki/Logarithm  Logarithm]
  
where:
 
  
x is nf, r is ns, and p is ps.
 
  
</div>
+
*[[Z_API_Functions | List of Main Z Functions]]
----
 
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
NEGBINOMDIST
+
*[[ Z3 |  Z3 home ]]
 
 
</div></div>
 
----
 
<div id="8SpaceContent" class="zcontent" align="left">
 
 
 
<font size="3"><font face="Times New Roman">Let’s see an example in (Column1 Row 1, Column1Row2, Column1Row3)</font></font>
 
 
 
<font size="3">NEGBINOMDIST (C1R1, C1R2, C1R3)</font>
 
 
 
<font size="3">i.e. NEGBINOMDIST (15,7,0.5) is 0.0129</font>
 
 
 
</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="2SpaceContent" class="zcontent" align="left"><div>
 
 
 
{| id="TABLE3" class="SpreadSheet blue"
 
|- class="even"
 
| class=" " |
 
| Column1
 
| class="        " | Column2
 
| class="    " | Column3
 
| class="  " |
 
| class="  " | Column4
 
|
 
|- class="odd"
 
| class=" " | Row1
 
| class=" " | 15
 
| class="sshl_f" | 0.012938
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|
 
|- class="even"
 
| class="  " | Row2
 
| class=" " | 7
 
| class="sshl_f    SelectTD ChangeBGColor SelectTD" |
 
<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="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|
 
|- class="odd"
 
| Row3
 
| class="sshl_f " | 0.5
 
|
 
| class="sshl_f" |
 
| class="  " |
 
| class="sshl_f" |
 
|
 
|- class="even"
 
| Row4
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|
 
| class=" " |
 
| class="sshl_f" |
 
|
 
|- class="odd"
 
| class="sshl_f" | Row5
 
| class="sshl_f" |
 
| class="  " |
 
|
 
|
 
| class="  " |
 
|
 
|- class="even"
 
| class=" " | Row6
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|
 
| class="sshl_f" |
 
|
 
|
 
|}
 
 
 
<div align="left"></div>''''''</div></div>
 
----
 

Latest revision as of 15:58, 8 August 2018

NEGBINOMDIST(x,r,p)


  • is the number of failures.
  • is the number of successes on an individual trial
  • is the probability of a success.
    • NEGBINOMDIST(), returns the negative binomial distribution.

Description

  • This function gives the Negative Binomial Distribution.
  • Negative Binomial Distribution is the discrete probability distribution with the fixed probability of success.
  • It is also called Pascal Distribution.

This is the statistical experiment with the following conditions:

This experiment consists of a sequence of independent trials.
Each trial represents only two results(Success or failure)
The probability of success is constant from trial to trial
The trials are independent; ie, the outcome on one trial does not affect the outcome on other trials.
The experiment continues until  the successes is obtained, where  is a specified positive integer. 
  • The random variable = the number of failures that precede the success;
  • is called a Negative Binomial Random variable because, in contrast to the

binomial random variable, the number of successes is fixed and the number of trials is random.

  • Then probability mass function of the negative binomial distribution is
  • For example: If a fair coin is tossed repeatedly, what is the probability that at least 10 tosses are required.

to obtain heads 8 times

  • This function will give the result as error when:
  1. Any argument is non-numeric
  2. If or
  3. If or

ZOS

  • The syntax is to calculate NEGBINOMDIST in ZOS is .
    • where is the number of failures.
    • is the number of successes on an individual trial
    • is the probability of a success.
  • For e.g.,NEGBINOMDIST(8..9,5..7,0.5).
Negative Binomial Distribution

Examples

  1. Find the probability that a man flipping a coin gets the fourth head on the ninth flip.

Here total number of events =9, r= 4(since we define Heads as a success) and x=9-4=5(number of failures)

p=1/2=0.5(Probability of success for any coin flip)

NEGBINOMDIST(5,4,0.5)=0.109375

  1. A company conducts a geological study that indicates that an exploratory goods well should have a 20% chance of striking goods. What is the probability that the first strike comes on the third well drilled?

Here total number of events=3, r=1,x=3-1=2,and p=0.20 NEGBINOMDIST(2,1,0.20)=0.128

  1. What is the probability that the fourth strike comes on the eighth well drilled?

Here total number of events=8, r=4, x=8-4=4 and p=0.20 NEGBINOMDIST(4,4,0.20)=0.0229376

Related Videos

Negative Binomial Distribution

See Also


References

Logarithm