Difference between revisions of "Documentation/How Tos/Calc: CRITBINOM function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m
m
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
__NOTOC__
+
{{DISPLAYTITLE:CRITBINOM function}}
 +
{{Documentation/CalcFunc StatisticalTOC
 +
|ShowPrevNext=block
 +
|PrevPage=Documentation/How_Tos/Calc:_CONFIDENCE_function
 +
|NextPage=Documentation/How_Tos/Calc:_EXPONDIST_function
 +
}}__NOTOC__
  
 
== CRITBINOM ==
 
== CRITBINOM ==
Line 18: Line 23:
 
: returns approximately 0.9 (90%), the probability that heads will come up 56 or fewer times in 100 flips of a coin.
 
: returns approximately 0.9 (90%), the probability that heads will come up 56 or fewer times in 100 flips of a coin.
  
−
{{Documentation/SeeAlso|
+
{{SeeAlso|EN|
 
* [[Documentation/How_Tos/Calc: B function|B]]
 
* [[Documentation/How_Tos/Calc: B function|B]]
 
* [[Documentation/How_Tos/Calc: BINOMDIST function|BINOMDIST]]
 
* [[Documentation/How_Tos/Calc: BINOMDIST function|BINOMDIST]]

Latest revision as of 13:50, 2 February 2024



CRITBINOM

Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.

Syntax:

CRITBINOM(n; p; a)

With n independent trials, each with a probability p of success, CRITBINOM returns the number of successes, up to and including which are expected with a probability a. See the examples to relate this to BINOMDIST.
CRITBINOM is useful in quality assurance procedures.

Example:

CRITBINOM(100; 0.5; 0.9)

returns 56.

BINOMDIST(56; 100; 0.5; 1)

returns approximately 0.9 (90%), the probability that heads will come up 56 or fewer times in 100 flips of a coin.


See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_CRITBINOM_function&oldid=260041"
Views
Personal tools
Navigation
Tools