Difference between revisions of "Documentation/How Tos/Calc: NEGBINOMDIST function"

From Apache OpenOffice Wiki
Jump to: navigation, search
Line 113: Line 113:
 
: returns 0.25 (25%), the probability that heads will come up exactly once before tails has come up when tossing a coin.
 
: returns 0.25 (25%), the probability that heads will come up exactly once before tails has come up when tossing a coin.
  
{{Documentation/SeeAlso|
+
{{SeeAlso|EN|
 
* [[Documentation/How_Tos/Calc: BINOMDIST function|BINOMDIST]]
 
* [[Documentation/How_Tos/Calc: BINOMDIST function|BINOMDIST]]
  

Revision as of 08:20, 17 July 2018


NEGBINOMDIST

Calculates probabilities for a negative binomial distribution.

Syntax:

NEGBINOMDIST(x; r; p)

For independent trials each with a probability p of success, NEGBINOMDIST returns the probability that there will be exactly x failures before there have been r successes. The formula used is:
Calc negbinomdist equation.png

Example:

NEGBINOMDIST(1; 1; 0.5)

returns 0.25 (25%), the probability that heads will come up exactly once before tails has come up when tossing a coin.



See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_NEGBINOMDIST_function&oldid=243485"
Views
Personal tools
Navigation
Tools