Difference between revisions of "Manuals/calci/CRITBINOM"
Jump to navigation
Jump to search
Line 7: | Line 7: | ||
*This function is the inverse of the Cumulative Binomial Distribution. | *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. | *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(ts,ps,alpha), <math>ts</math> is the number of independent trials that are to be done(if <math>ts</math> value is in decimal then it is converted | + | *In CRITBINOM(ts,ps,alpha), <math>ts</math> is the number of independent trials that are to be done (if <math>ts</math> value is in decimal then it is converted to an integer) ,<math>ps</math> is the probability of success in one trial and <math>alpha</math> is the criterion value of the Cumulative Binomial Distribution (must be between 0 and 1). |
*This function gives the result as error when | *This function gives the result as error when | ||
1.Any one of the argument is non-numeric. | 1.Any one of the argument is non-numeric. |
Revision as of 02:34, 10 December 2013
CRITBINOM(ts,ps,alpha)
- is the number of independent trials.
- is the probability of success in one trial.
- is the criterion value.
Description
- This function gives the smallest value for which the Cumulative Binomial Distribution is a specified probability.
- 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(ts,ps,alpha), 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).
- This function gives the result as error when
1.Any one of the argument is non-numeric. 2.,or or 3. or
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) = NAN
- CRITBINOM(9.5,0.4,0.35) = 3
- CRITBINOM(12,-0.25,0.3) = NAN