Excel - CRITBINOM Function

---

---

CRITBINOM Function

The Excel CRITBINOM function retrieves the smallest value where the cumulative binomial distribution is equal to or larger than a constraint value. It is categorized as a statistical function in Excel. This function can be used for inventory management, risk management, calculating the probability of completing certain projects within the time constraint, and quality control management.

The CRITBINOM function interchanges the BINOM.INV function in Excel 2010.

Compatibility

This advanced Excel function is compatible with the following versions of MS-Excel −

• Excel for Microsoft 365
• Excel for Microsoft 365 for Mac
• Excel for the web
• Excel 2021
• Excel 2021 for Mac
• Excel 2019
• Excel 2019 for Mac
• Excel 2016

Syntax

The syntax of CRITBINOM function is as follows −

CRITBINOM (trials,probability_s,alpha)

Arguments

You can use the following arguments with the CRITBINOM function −

Points to Remember

• If the first argument, Trials, is in a decimal form, its value gets truncated.
• If any argument contains values other than an integer, then CRITBINOM will receive the #VALUE!
• If the first argument, Trials, contains a negative value, the CRITBINOM function will retrieve the #NUM! Error.
• If probability_s does not lie between 0 and 1, then the CRITBINOM function will obtain the #NUM! Error.
• If the alpha argument does not lie between 0 and 1, then the CRITBINOM function will retrieve the #NUM! Error.

Examples of CRITBINOM Function

Practice the following examples to learn the use of the CRITBINOM function in Excel.

Example 1

Consider the sample dataset, which comprises two columns. Write the text Trial, Success Probability, and Alpha in the B3, B4, and B5 cells and enter their corresponding values in the range C3:C5.

Solution

In the B5 cell, write CRITBINOM formula text, enter the formula =CRITBINOM(C3, C4, C5) in the C7 cell, and press the Enter tab.

Example 2

If the first argument, Trials, is in a decimal form, its value gets rounded off and converted into integers.

Solution

You may write the decimal number 45.65 in the C3 cell. Enter the formula =CRITBINOM(C3, C4, C5) in the C7 cell and press Enter tab.

Here, the C3 cell value gets truncated to 45 as the CRITBINOM takes only integers for the first argument, Trials.

Example 3

If any argument contains values other than an integer, then CRITBINOM will receive the #VALUE!

Solution

First, you can write Autumn in the C4 cell. Write the formula =CRITBINOM(C3, C4, C5) in the C7 cell and press Enter tab.

Example 4

If the first argument, Trials, contains a negative value, the CRITBINOM function will retrieve the #NUM! Error value.

Solution

As you can see in this example, the C3 cell contains the negative value -87, which is not permitted in the CRITBINOM function. Enter the expression =CRITBINOM(C3,C4,C5) in the C7 cell.

Once you press the Enter tab, the #NUM! will be obtained.

Example 5

If probability_s doesnt lie between 0 and 1, then the CRITBINOM function will obtain the #NUM! Error value.

Solution

You may set the value of the Success Probability in every trial to 7 in the C4 cell. Enter the expression =CRITBINOM(C3,C4,C5) in the C7 cell.

Once you press the Enter tab, the CRITBINOM function will get the #NUM! Error as the second argument must contain a value between 0 and 1.

Example 6

If the third argument, Alpha, does not lie between 0 and 1, then the CRITBINOM function will retrieve the #NUM! Error.

Solution

First, you can rewrite the value of Alpha to integer 4 in the C5 cell. Enter the expression =CRITBINOM(C3,C4,C5) in the C7 cell and press the Enter tab.

Once you press the Enter tab, the #NUM error will be obtained as the Alpha value does not reside in the boundaries of 0 and 1.