Difference between revisions of "Manuals/calci/CRITBINOM"

From ZCubes Wiki
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 to 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).  
+
*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 to 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:33, 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 in to 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

  1. CRITBINOM(5,0.6,0.4) = 3
  2. CRITBINOM(8,0.1,0.25) = 1
  3. CRITBINOM(20,0.75,0.65) = 16
  4. CRITBINOM(20,1,1.5) = NAN
  5. CRITBINOM(9.5,0.4,0.35) = 3
  6. CRITBINOM(12,-0.25,0.3) = NAN

See Also

References

Correlation