NEGBINOMDIST (PQL - xl)

This function returns the negative binomial distribution

Syntax

NEGBINOMDIST(number f, number s, probability s)
Function Arguments

Name

Description

Type

Optional

number f

An integer representing the number of failures in trials

Number

number s

An integer representing the threshold number of successes

Number

probability s

Probability of success on each trial A number between 0 and 1

Number

Comments

This function is the same as the Microsoft Excel 'NEGBINOMDIST' function - using the same inputs, logic and outputs.