Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

BINOMDIST

Returns the individual term binomial distribution probability.

Sample Usage

BINOMDIST(C2,C3,C4,FALSE)
BINOMDIST(4,100,0.005,TRUE)

Syntax

BINOMDIST(number_s, trials, probability_s, cumulative)

  • number_s - The number of successes for which to calculate the probability.
  • trials - The number of independent trials.
  • probability_s - The probability of success in any given trial.
  • cumulative - A logical value that determines the form of the function.

 

Examples

BINOMDIST(C2,C3,C4,FALSE) returns the probability of exactly 6 of 10 trials being successful.
BINOMDIST(4,100,0.005,FALSE) returns a value of 0.00151.

Notes

  • If cumulative is TRUE then BINOMDIST returns the probability of number_s or fewer successes, otherwise the probability of exactly number_s successes.
  • cumulative is FALSE by default.