EXCEL BINOMDIST FUNCTION

The BINOMDIST function in Excel returns the Binomial Distribution probability of a certain number of successes out of a given number of trials.

Syntax:

=BINOMDIST( number_strialsprobability_scumulative )

Parameter:

  • The following are the argument

number_s:

  • The number of achievements for which you wish to compute the probability.

trials:

  • The number of independent trials that will be conducted.

probability_s:

  • The likelihood of success in a single experiment.

cumulative:

  • A logical argument indicating whether the cumulative distribution function or the probability mass function should be computed. This parameter can be TRUE or FALSE, which means:

TRUE: Apply the cumulative distribution function;

FALSE: Apply the probability mass function.

The graph on the right depicts the Binomial Distribution Probability Mass Function for 100 coin tosses. The graphic depicts the chance that x heads will be tossed out of 100 coin flips.

  • #NUM! – This error occurs if either: the given value of the number s parameter is 0 or > trials; or the supplied probability s is 0 or > trials. 1.
  • #VALUE! – This error occurs if any of the number s, trials, or probability s parameters are not numeric.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now