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

From Apache OpenOffice Wiki
Jump to: navigation, search
m
 
(10 intermediate revisions by 5 users not shown)
Line 1: Line 1:
−
__NOTOC__
+
{{DISPLAYTITLE:B function}}
 +
{{Documentation/CalcFunc StatisticalTOC
 +
|ShowPrevNext=block
 +
|PrevPage=Documentation/How_Tos/Calc:_VARPA_function
 +
|NextPage=Documentation/How_Tos/Calc:_BETADIST_function
 +
}}__NOTOC__
  
 
== B ==
 
== B ==
Line 8: Line 13:
  
 
: With <tt>'''n'''</tt> independent trials, each with a probability <tt>'''p'''</tt> of success, <tt>'''B'''</tt> returns the probability that the number of successes will be between <tt>'''k'''</tt> and <tt>'''k2'''</tt> inclusive, or if <tt>'''k2'''</tt> is omitted the probability that the number of successes will be exactly <tt>'''k'''</tt>.
 
: With <tt>'''n'''</tt> independent trials, each with a probability <tt>'''p'''</tt> of success, <tt>'''B'''</tt> returns the probability that the number of successes will be between <tt>'''k'''</tt> and <tt>'''k2'''</tt> inclusive, or if <tt>'''k2'''</tt> is omitted the probability that the number of successes will be exactly <tt>'''k'''</tt>.
 +
 +
: The probability is calculated as:
 +
:: [[Image:Calc_b_equation.png]] (where <tt>'''k2'''</tt> = <tt>'''k'''</tt> if <tt>'''k2'''</tt> is omitted).
  
 
=== Example: ===
 
=== Example: ===
Line 13: Line 21:
 
: returns approximately 0.29 (29%), the probability that the number four will be thrown exactly twice in 10 throws of a die.
 
: returns approximately 0.29 (29%), the probability that the number four will be thrown exactly twice in 10 throws of a die.
  
−
=== See also: ===
+
=== Issues: ===
−
[[Documentation/How_Tos/Calc: BINOMDIST function|'''BINOMDIST''']]
+
* Excel does not have this function.
 +
 
 +
 
 +
{{SeeAlso|EN|
 +
* [[Documentation/How_Tos/Calc: BINOMDIST function|BINOMDIST]]
 +
 
 +
* [[Documentation/How_Tos/Calc: Statistical functions|Statistical functions]]
  
−
[[Documentation/How_Tos/Calc: Statistical functions|'''Statistical functions''']]
+
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 +
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 +
[[Category: Documentation/Reference/Calc/Statistical functions]]

Latest revision as of 13:37, 2 February 2024



B

Calculates probabilities for a binomial distribution.

Syntax:

B(n; p; k; k2)

With n independent trials, each with a probability p of success, B returns the probability that the number of successes will be between k and k2 inclusive, or if k2 is omitted the probability that the number of successes will be exactly k.
The probability is calculated as:
Calc b equation.png (where k2 = k if k2 is omitted).

Example:

B(10; 1/6; 2)

returns approximately 0.29 (29%), the probability that the number four will be thrown exactly twice in 10 throws of a die.

Issues:

  • Excel does not have this function.



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