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 signs
Use 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 Oscar
You can contact me through this contact form