How to use the BINOMDIST function
Author: Oscar Cronquist Article last updated on May 11, 2022
The BINOMDIST 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 BINOMDIST function is outdated and replaced by the BINOM.DIST function.
Formula in cell C8:
=BINOMDIST(C3,C4,C5,C6)
Excel Function Syntax
BINOMDIST(number_s,trials,probability_s,cumulative)
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 |
Comments
The BINOMDIST 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 'Compatibility' category
The BINOMDIST function function is one of many functions in the 'Compatibility' 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