Documentation/How Tos/Calc: NEGBINOMDIST function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 12:20, 20 November 2009 by OOoWikiBot (Talk | contribs)

Jump to: navigation, search


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.

Template:Documentation/SeeAlso

Personal tools