CALC.binomdist(number_s, trials, probability_s, cumulative)

Returns the individual term binomial distribution probability. Number_s is the number of successes in trials. Trials is the number of independent trials. Probability_s is the probability of success on each trial. Cumulative is a logical value that determines the form of the function. If Cumulative is true, the function returns the cumulative distribution function, which is the probability that there are at most Number_s successes; if false, it returns the probability mass function, which is the probability that there are Number_s successes.

Example

CALC.binomdist(6, 10, 0.5);

// returns 0.205

<< CALC.averagea(array) © 1996-2013 InetSoft Technology Corporation (v11.4) CALC.correl(array1, array2) >>