CRITBINOM Excel Formula

Author Zaheer    Category Formulas     Tags ,

Normally, users of Microsoft Excel identify the program as a great tool for storing and administering data. This is definitely true, but aside from this information, in order to utilize this tool to its maximum point, users must learn the different functions that are incorporated in the program. This can be used in different aspects of business, not only in keeping and managing data but also in calculating records. With this, a lot of people could take advantage of the program by utilizing it to any job related business in engineering and various financial fields.

This program could perform certain data computations easily. With regards to this, one of the functions that the users should learn and understand is the CRITBINOM function.

Description of CRITBINOM Function

The function is used to compute the smallest value wherein the collective binomial distribution is equivalent or higher than the set of values. This function is best to utilize for quality assertion application. For instance, it can be utilized to find the biggest value of substandard parts permissible to appear on certain assembly line without the need of rejecting the whole set.

CRITBINOM Function Syntax

When using Microsoft Excel, it is very important to know certain function formulas, since this is a program that runs through a formula. For CRITBINOM function, the formula to remember is:

=CRITBINOM(trials, probability_s, alpha)

Where in:

  • trials – is the value of Bernoulli trials
  • probability_s – the value of the probability of success on every trial
  • alpha – is the value of criterion

Information to Ponder

In order to use the program efficiently, below are the important facts to keep in mind.

  • Once the value of any argument is considered a non-numeric value, the result of the function is equal to #VALUE!.
  • If the trial is not a numeral then it is truncated by the function.
  • Once the value of trials is less than zero, the result of the function would be a #NUM! error value.
  • Once the supplied argument on probability_s is less than zero or probability_s is greater than 1, then the result of the function is a #NUM! error value.
  • If the value of alpha is less than zero or alpha is greater than 1, the result of the function is #NUM! error value.

Example of CRITBINOM Function

By looking at the example, you will have an idea on how the function is used in Microsoft Excel.

Calculate the smallest value of the cumulative binomial distribution wherein the Bernoulli’s trial is equal to 98%, the probability of success is 6% and the set criterion is 10%.

To compute using Microsoft Excel, do the following steps:

  • Write all the given value in an empty worksheet. Ensure that each value is entered in different cells.
  • Once all the given data are typed in, click an empty cell in the worksheet.
  • In the empty cell, type in the CRITBINOM function formula which is “=CRITBINOM(trials, probability_s, alpha)”.
  • To supply the values on the arguments, simply click the reference cell that contains the value for every argument. For instance the values given are written from A1 cell to A3 cell, then the formula to appear on this problem must be “=CRITBINOM(A1,A2,A3)”.
  • Once the syntax is already entered, press the enter key. The answer will instantly appear and it is equal to 3.

If ever you’re not able to come up with the same or correct answer, check your formula because you might have keyed in wrongly the required values.

Post comment