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

From Apache OpenOffice Wiki
Jump to: navigation, search
(Initial content)
 
(See also:)
Line 18: Line 18:
  
 
[[Documentation/How_Tos/Calc: Statistical functions|'''Statistical functions''']]
 
[[Documentation/How_Tos/Calc: Statistical functions|'''Statistical functions''']]
 +
 +
[[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']],
 +
[[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']]

Revision as of 14:02, 13 September 2008


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:

BINOMDIST

Statistical functions

Functions listed alphabetically, Functions listed by category

Personal tools