Manuals/calci/CRITBINOM
CRITBINOM(trials,probabilitys,alpha,accuracy)
- is the number of independent trials.
- is the probability of success in one trial.
- is the criterion value.
- gives accurate value of the solution.
- CRITBINOM(), returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.
Description
- The smallest value in Cumulative Binomial Distribution probability result is the Critbinom.
- This function is the inverse of the Cumulative Binomial Distribution.
- For example, the Critbinom function could be used to find the smallest number of through the dice for which there is a 40% chance of at least 10 six's.
- In CRITBINOM(trials,probabilitys,alpha,accuracy), is the number of independent trials that are to be done (if value is in decimal then it is converted to an integer).
- is the probability of success in one trial and is the criterion value of the Cumulative Binomial Distribution (must be between 0 and 1).
- gives accurate value of the solution.
- This function gives the result as error when
1.Any one of the argument is non-numeric. 2.,or or 3. or .
ZOS
- The syntax is to calculate CRITBINOM in ZOS is .
- is the number of independent trials.
- is the probability of success in one trial.
- is the criterion value.
- gives accurate value of the solution.
- For e.g.,CRITBINOM(5..8,0.5,0.4,0.02)
Examples
- CRITBINOM(5,0.6,0.4) = 3
- CRITBINOM(8,0.1,0.25) = 1
- CRITBINOM(20,0.75,0.65) = 16
- CRITBINOM(20,1,1.5) = #N/A (ALPHA IN BETWEEN 0 AND 1 REQUIRED)
- CRITBINOM(9.5,0.4,0.35) = 3
- CRITBINOM(12,-0.25,0.3) = #N/A (PROBABILITY IN BETWEEN 0 AND 1 REQUIRED)
Related Videos
See Also
References