Difference between revisions of "Manuals/calci/CRITBINOM"

From ZCubes Wiki
Jump to navigation Jump to search
 
(8 intermediate revisions by 4 users not shown)
Line 4: Line 4:
 
*<math>alpha</math> is the criterion value.
 
*<math>alpha</math> is the criterion value.
 
*<math>accuracy</math> gives accurate value of the solution.
 
*<math>accuracy</math> 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==
 
==Description==
Line 17: Line 18:
 
  3.<math>alpha<0</math> or <math>alpha>1</math>.
 
  3.<math>alpha<0</math> or <math>alpha>1</math>.
  
==ZOS Section==
+
==ZOS==
 
*The syntax is to calculate CRITBINOM in ZOS is <math>CRITBINOM(trials,probabilitys,alpha,accuracy)</math>.
 
*The syntax is to calculate CRITBINOM in ZOS is <math>CRITBINOM(trials,probabilitys,alpha,accuracy)</math>.
 
**<math>trials</math> is the number of independent trials.  
 
**<math>trials</math> is the number of independent trials.  
Line 24: Line 25:
 
**<math>accuracy</math> gives accurate value of the solution.
 
**<math>accuracy</math> gives accurate value of the solution.
 
*For e.g.,CRITBINOM(5..8,0.5,0.4,0.02)
 
*For e.g.,CRITBINOM(5..8,0.5,0.4,0.02)
 +
{{#ev:youtube|VqXa3JGsSvY|280|center|CRITBINOM }}
  
 
==Examples==
 
==Examples==
Line 30: Line 32:
 
#CRITBINOM(8,0.1,0.25) = 1
 
#CRITBINOM(8,0.1,0.25) = 1
 
#CRITBINOM(20,0.75,0.65) = 16
 
#CRITBINOM(20,0.75,0.65) = 16
#CRITBINOM(20,1,1.5) = NAN
+
#CRITBINOM(20,1,1.5) = #N/A (ALPHA IN BETWEEN 0 AND 1 REQUIRED)
 
#CRITBINOM(9.5,0.4,0.35) = 3
 
#CRITBINOM(9.5,0.4,0.35) = 3
#CRITBINOM(12,-0.25,0.3) = NAN
+
#CRITBINOM(12,-0.25,0.3) = #N/A (PROBABILITY IN BETWEEN 0 AND 1 REQUIRED)
 +
 
 +
==Related Videos==
 +
 
 +
{{#ev:youtube|L6YX3ug1znM|280|center|Cumulative Probability}}
  
 
==See Also==
 
==See Also==
Line 41: Line 47:
 
==References==
 
==References==
 
[http://en.wikipedia.org/wiki/Binomial_distribution  Binomial Distribution]
 
[http://en.wikipedia.org/wiki/Binomial_distribution  Binomial Distribution]
 +
 +
 +
 +
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 03:32, 25 August 2020

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)
CRITBINOM

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) = #N/A (ALPHA IN BETWEEN 0 AND 1 REQUIRED)
  5. CRITBINOM(9.5,0.4,0.35) = 3
  6. CRITBINOM(12,-0.25,0.3) = #N/A (PROBABILITY IN BETWEEN 0 AND 1 REQUIRED)

Related Videos

Cumulative Probability

See Also

References

Binomial Distribution