Administrators, writer
3,314
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + + + + + + + + + + + + + + + + + + + + + + + + + − '''NEGBINOMDIST'''('''nf''','''ns''','''ps''')+ + + + + + + − '''Where nf''' is number of failures,ns is the threshold number of successes and ps is the probability of a success.+ + + + − </div> − ---- − <div id="1SpaceContent" class="zcontent" align="left"> − It calculates the negative binomial distribution.+ − + − </div> − ---- − <div id="7SpaceContent" class="zcontent" align="left"> − − · nf and ns are integers. − − · NEGBINOMDIST displays error , when any argument is nonnumeric. − − · The equation for the negative binomial distribution is: − − where: − − x is nf, r is ns, and p is ps. − − </div> − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> − − NEGBINOMDIST − − </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> − ----
Manuals/calci/NEGBINOMDIST (view source)
Revision as of 10:03, 26 November 2013
, 10:03, 26 November 2013no edit summary
<div id="6SpaceContent" class="zcontent" align="left">
<div style="font-size:30px">'''NEGBINOMDIST(nf,ns,ps)'''</div><br/>
*Where 'nf' is the number of failures.
*Where 'ns' is the number of successes on an individual trial
*And 'ps' is the probability of a success.
==Description==
This function gives the negative binomial distribution.
Negative binomial ditrbution 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; that is, the outcome on one trial does not affect the outcome on other trials.
#The experiment continues until r successes are observed, where r is a specified positive integer.
*The random variable of x = the number of failures that precede the rth success;
*x 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:
nb(x;r,p)=(x+r-1 p^r (1-p)^x
r-1)
*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 nonnumeric
#If ps<0 or ps>1
#If nf<0 or ns<1
==Examples==
=log 10(5)= 0.698970004
=log(55)= 1.740362689
=log(10)= 1
=log(1)= 0
=log(-10)= NaN
=log(0.25)= -0.602059991
==See Also==
*[[Manuals/calci/LN | LN ]]
*[[Manuals/calci/IMLOG10 | IMLOG10 ]]
*[[Manuals/calci/LOG | LOG ]]
==References==
[http://en.wikipedia.org/wiki/Logarithm| Logarithm]