BINOMIALPROBABILTY(NumberOftrials,NumberOfSuccess,ProbabiltyOfSuccess)
- or Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \binom{n}{r}p^r(1-p)^{n-r}}
where n = number of trials,r = number of specific events you wish to obtain. p = probability that the event will occur, q = probability that the event will not occur.(q = 1 - p, the complement of the event)
Examples
- BINOMIALPROBABILTY(5,3,0.4)=0.23040000000000005
- BINOMIALPROBABILTY(10,4,0.25)=0.1459980010986328
- BINOMIALPROBABILTY(12,11,0.75)=0.12670540809631348