Spread.NET 17 Formula Reference
Formula Functions / Functions A to C / BINOMDIST
In This Topic
    BINOMDIST
    In This Topic

    This function calculates the individual term binomial distribution probability.

    Syntax

    BINOMDIST(x,n,p,cumulative)

    Arguments

    This function has these arguments:

    Argument Description
    x Number representing the number of successes in trials; if not an integer, the number is truncated
    n Number representing the number of independent trials; if not an integer, the number is truncated
    p Probability of success on each trial; number between 0 and 1
    cumulative Logical value that determines the form of the function; if TRUE, then this function returns the cumulative distribution function, which is the probability that there are at most x successes; if FALSE, it returns the probability mass function, which is the probability that there are x successes

    Remarks

    Use this function in problems with a fixed number of tests or trials, when there are two mutually exclusive possible outcomes (a "success" and a "failure"), when trials are independent, and when the probability of one outcome is constant throughout the experiment. This function can, for example, calculate the probability that two of the next three babies born are male.

    The binomial probability mass function is calculated as follows:

    BINOMDIST (false) equation

    where x is the number of successes, n is the number of trials, and p is the probability of success on any one trial.The cumulative binomial distribution is calculated as follows:

    BINOMDIST (true) equation

    where n is the number of trials, x is the number of successes, and p is the possibility of success on any one trial.

    Data Types

    Accepts numeric data for all arguments, except cumulative, which accepts logical data. Returns numeric data.

    Example

    A baby can be either male or female; for the sake of this example, assume the odds are 50/50 that a baby is either male or female. If female equals TRUE, we can use the following to determine the probability of the next 5 babies in 10 born being female. The probability of the first baby being female is 0.5, and the probability of exactly 5 of 10 babies born being female is:

    BINOMDIST(5,10,0.5,FALSE) gives the result 0.2460937500

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    BETADIST | CRITBINOM | EXPONDIST | GAMMADIST | NEGBINOMDIST | WEIBULL | Statistical Functions