Difference between revisions of "Manuals/calci/CRITBINOM"

From ZCubes Wiki
Jump to navigation Jump to search
 
(18 intermediate revisions by 4 users not shown)
Line 1: Line 1:
<div style="font-size:30px">'''CRITBINOM(ts,ps,alpha)'''</div><br/>
+
<div style="font-size:30px">'''CRITBINOM(trials,probabilitys,alpha,accuracy)'''</div><br/>
*<math>ts</math> is the number of independent trials.  
+
*<math>trials</math> is the number of independent trials.  
*<math>ps</math> is the  probability of success in one trial.
+
*<math>probabilitys</math> is the  probability of success in one trial.
 
*<math>alpha</math> is the criterion value.
 
*<math>alpha</math> is the criterion value.
 +
*<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==
This function gives the smallest value for which the cumulative binomial distribution is a specified probability.
+
*The smallest value in Cumulative Binomial Distribution probability result is the Critbinom.
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) ,ts is the number of independent trials that are to be done(the ts value is in decimal then it is converted in to integer) ,ps is the  probability of success in one trial and alpha The criterion value of the Cumulative Binomial Distribution (must be between 0 and 1).  
+
*In CRITBINOM(trials,probabilitys,alpha,accuracy), <math>trials</math> is the number of independent trials that are to be done (if <math>trials</math> value is in decimal then it is converted to an integer).
This function gives the result as error when  
+
*<math>probabilitys</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).  
#Any one of the argument is nonnumeric.
+
*<math>accuracy</math> gives accurate value of the solution.
#ts<0,or ps<0 or ps>1
+
*This function gives the result as error when  
#alpha<0 or alpha>1
+
1.Any one of the argument is non-numeric.
 +
2.<math>trials<0</math>,or <math>probabilitys<0</math> or <math>probabilitys>1</math>
 +
3.<math>alpha<0</math> or <math>alpha>1</math>.
 +
 
 +
==ZOS==
 +
*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>probabilitys</math> is the  probability of success in one trial.
 +
**<math>alpha</math> is the criterion value.
 +
**<math>accuracy</math> gives accurate value of the solution.
 +
*For e.g.,CRITBINOM(5..8,0.5,0.4,0.02)
 +
{{#ev:youtube|VqXa3JGsSvY|280|center|CRITBINOM }}
 +
 
 
==Examples==
 
==Examples==
  
#CRITBINOM(5,0.6,0.4)=3
+
#CRITBINOM(5,0.6,0.4) = 3
#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 27: Line 46:
 
*[[Manuals/calci/FACT  | FACT ]]
 
*[[Manuals/calci/FACT  | FACT ]]
 
==References==
 
==References==
[http://en.wikipedia.org/wiki/Pearson_product-moment_correlation_coefficient| Correlation]
+
[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