Excel Function : CRITBINOM

Download now!

Excel Function : CRITBINOM

Category

Compatibility

Description

Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value

Microsoft Excel Reference Page

https://support.office.com/en-us/article/CRITBINOM-function-eb6b871d-796b-4d21-b69b-e4350d5f407b

Syntax and Description of the CRITBINOM Excel Function

The CRITBINOM function in Excel returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. The syntax for the CRITBINOM function is as follows: =CRITBINOM(trials,probability_s,alpha) where "trials" is the number of independent trials, "probability_s" is the probability of success on each trial, and "alpha" is the criterion value.

About CRITBINOM Excel Function

CRITBINOM(trials,probability_s,alpha) The CRITBINOM function returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.