Difference between revisions of "Manuals/calci/CRITBINOM"

From ZCubes Wiki
Jump to navigation Jump to search
Line 28: Line 28:
 
*[[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]

Revision as of 22:13, 11 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

  • 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(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

  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

Binomial Distribution