Menu
EXCEL CRITBINOM FUNCTION
Excel CRITBINOM Function Introduction
The CRITBINOM function in Excel calculates the inverse of the Cumulative Binomial Distribution. In other words, for a given number of independent trials, the function returns the least value (number of successes) whose cumulative binomial distribution is higher than or equal to a given value. For example, the Critbinom method will be used to calculate the fewest number of permutations with a 50% likelihood with at least 20 heads.
Description of Excel CRITBINOM Function
Syntax:
=CRITBINOM( trials, probability_s, alpha )
Parameter:
- The following are the arguments:
trials:
- The number of independent trials that will be conducted.
(If this number is a decimal, Excel truncates it to an integer.)
probability_s:
- The likelihood of success in a single experiment.
alpha :
- The Cumulative Binomial Distribution’s criteria value (must be between 0 and 1).
Step By Step Guide of CRITBINOM Function
Example :
The graph on the right depicts the Cumulative Binomial Distribution Function for 100 coin tosses. This curve depicts the likelihood that x heads will be tossed out of a total of 100 tosses.
The inverse of the curve on the right is calculated using the Excel Critbinom function. In other words, the Critbinom function computes the smallest value of x for which the Cumulative Binomial Distribution function returns a given value. The spreadsheets below demonstrate this for three distinct criteria values.
Key Points
- #NUM! – Occurs if any of the following conditions are met: the supplied trials argument is 0; the supplied probability s argument is 0 or greater than 1; and the supplied alpha argument is 0 or greater than 1.
- #VALUE! – Occurs if any of the supplied arguments are present.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
