## How to use the BINOM.DIST function

**What is the BINOM.DIST function function?**

The BINOM.DIST function calculates the individual term binomial distribution probability, use this function when

- the success probability is constant through all trials
- you know the number of trials
- the outcome is either a success or failure
- each trial is independent of the other trials.

The BINOM.DIST function was introduced in Excel 2010 and replaces the outdated BINOMDIST function.

**What is the binomial distribution probability?**

The binomial distribution probability gives the likelihood of a specific number of successes occurring in a fixed number of independent trials, each having the same binary success/failure probability.

**What is the individual term binomial distribution probability?**

The individual term binomial distribution probability is the probability of exactly k successes in n trials with a given success probability p, calculated using combinations to determine the number of ways k successes can occur in those trials.

**What are combinations?**

A combination is a way of selecting items from a collection where the order of selection does not matter.

For example, if you have three fruits, say an apple, an orange, and a pear. There are three combinations of two that can be drawn from this set:

- apple and a pear
- apple and an orange
- pear and an orange

### BINOM.DIST function Syntax

BINOM.DIST(*number_s,trials,probability_s,cumulative*)

### BINOM.DIST function Arguments

number_s |
Required. The number of successfulÂ tests. |

trials |
Required.Â How many independent tests. |

probability_s |
Required. The probability of success in each test. |

cumulative |
Required. A boolean value. TRUE -Â cumulative distribution function. FALSE -Â probability mass function. |

**What is cumulative binomial distribution?**

The cumulative binomial distribution function gives the probability that a binomial random variable with a given number of trials and success probability will take on a value less than or equal to a specified number of successes x.

**What is probability mass function?**

A probability mass function is a function that defines a discrete probability distribution by providing the probability that each of a countable number of possible discrete outcomes will occur for a random variable.

**What is a binomial random variable?**

A binomial random variable is a discrete random variable that represents the number of "successes" in a fixed number of independent binary trials, where each trial has the same probability of success.

**What are discrete probabilities?**

Discrete probabilities are individual separated probabilities assigned to each of a countable number of possible outcomes that sum to 1, like rolling a die where each number has its own exact probability, as opposed to continuous distributions.

### BINOM.DIST function example

Formula in cell C8:

### BINOM.DIST function not working

The BINOM.DIST function returns

- #VALUE! error value ifÂ
*number_s,Â trials*orÂ*probability_s*argument is non-numeric. - #NUM! error value if:
*number_sÂ*<= 0 (zero)*number_sÂ*>*trials**probability_sÂ*< 0 (zero)*probability_sÂ*> 1- A = B

*number_s *andÂ *trials *are converted into integers.

### Functions in 'Statistical' category

The BINOM.DIST function function is one of many functions in the 'Statistical' category.

## How to comment

How to add a formula to your comment<code>Insert your formula here.</code>

Convert less than and larger than signsUse html character entities instead of less than and larger than signs.

< becomes < and > becomes >

How to add VBA code to your comment[vb 1="vbnet" language=","]

Put your VBA code here.

[/vb]

How to add a picture to your comment:Upload picture to postimage.org or imgur

Paste image link to your comment.

Contact OscarYou can contact me through this contact form