diff options
Diffstat (limited to 'source/text')
| -rw-r--r-- | source/text/scalc/01/04060181.xhp | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/source/text/scalc/01/04060181.xhp b/source/text/scalc/01/04060181.xhp index 24d7963365..4768af7dfe 100644 --- a/source/text/scalc/01/04060181.xhp +++ b/source/text/scalc/01/04060181.xhp @@ -258,6 +258,36 @@ <paragraph xml-lang="en-US" id="par_id3150120" role="paragraph" l10n="U" oldref="86"> <item type="input">=BINOMDIST(A1;12;0.5;1)</item> shows the cumulative probabilities for the same series. For example, if A1 = <item type="input">4</item>, the cumulative probability of the series is 0, 1, 2, 3 or 4 times <emph>Heads</emph> (non-exclusive OR).</paragraph> </section> +<section id="binomdotdist"> +<bookmark xml-lang="en-US" branch="index" id="bm_id2943228"><bookmark_value>BINOM.DIST function</bookmark_value></bookmark> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BINOM_DIST_MS" id="bm_id2950146" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id2943228" role="heading" level="2" l10n="U" oldref="76">BINOM.DIST</paragraph> +<paragraph xml-lang="en-US" id="par_id2946897" role="paragraph" l10n="U" oldref="77"><ahelp hid="HID_FUNC_BINOM_DIST_MS">Returns the individual term binomial distribution probability.</ahelp></paragraph> +<paragraph xml-lang="en-US" id="hd_id2949289" role="heading" level="3" l10n="U" oldref="78">Syntax</paragraph> +<paragraph xml-lang="en-US" id="par_id2956009" role="code" l10n="U" oldref="79">BINOM.DIST(X; Trials; SP; C)</paragraph> +<paragraph xml-lang="en-US" id="par_id2954304" role="paragraph" l10n="U" oldref="80"><emph>X</emph> is the number of successes in a set of trials.</paragraph> +<paragraph xml-lang="en-US" id="par_id2947492" role="paragraph" l10n="U" oldref="81"><emph>Trials</emph> is the number of independent trials.</paragraph> +<paragraph xml-lang="en-US" id="par_id2946085" role="paragraph" l10n="U" oldref="82"><emph>SP</emph> is the probability of success on each trial.</paragraph> +<paragraph xml-lang="en-US" id="par_id299760" role="paragraph" l10n="U" oldref="83"><emph>C</emph> = 0 calculates the probability of a single event and <emph>C</emph> = 1 calculates the cumulative probability.</paragraph> +<paragraph xml-lang="en-US" id="hd_id291171" role="heading" level="3" l10n="U" oldref="84">Example</paragraph> +<paragraph xml-lang="en-US" id="par_id295666" role="paragraph" l10n="U" oldref="85"> + <item type="input">=BINOM.DIST(A1;12;0.5;0)</item> shows (if the values <item type="input">0</item> to <item type="input">12</item> are entered in A1) the probabilities for 12 flips of a coin that <emph>Heads</emph> will come up exactly the number of times entered in A1.</paragraph> +<paragraph xml-lang="en-US" id="par_id290120" role="paragraph" l10n="U" oldref="86"> + <item type="input">=BINOM.DIST(A1;12;0.5;1)</item> shows the cumulative probabilities for the same series. For example, if A1 = <item type="input">4</item>, the cumulative probability of the series is 0, 1, 2, 3 or 4 times <emph>Heads</emph> (non-exclusive OR).</paragraph> +</section> +<section id="binomdotinv"> +<bookmark xml-lang="en-US" branch="index" id="bm_id2843228"><bookmark_value>BINOM.INV function</bookmark_value></bookmark> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BINOM_INV_MS" id="bm_id2850146" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id2843228" role="heading" level="2" l10n="U" oldref="76">BINOM.INV</paragraph> +<paragraph xml-lang="en-US" id="par_id2846897" role="paragraph" l10n="U" oldref="77"><ahelp hid="HID_FUNC_BINOM_INV_MS">Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.</ahelp></paragraph> +<paragraph xml-lang="en-US" id="hd_id2849289" role="heading" level="3" l10n="U" oldref="78">Syntax</paragraph> +<paragraph xml-lang="en-US" id="par_id2856009" role="code" l10n="U" oldref="79">BINOM.INV(Trials; SP; Alpha)</paragraph> +<paragraph xml-lang="en-US" id="par_id2847492" role="paragraph" l10n="U" oldref="81"><emph>Trials</emph> The total number of trials.</paragraph> +<paragraph xml-lang="en-US" id="par_id2846085" role="paragraph" l10n="U" oldref="82"><emph>SP</emph> is the probability of success on each trial.</paragraph> +<paragraph xml-lang="en-US" id="par_id289760" role="paragraph" l10n="U" oldref="83"><emph>Alpha</emph>The border probability that is attained or exceeded.</paragraph> +<paragraph xml-lang="en-US" id="hd_id281171" role="heading" level="3" l10n="U" oldref="84">Example</paragraph> +<paragraph xml-lang="en-US" id="par_id285666" role="paragraph" l10n="U" oldref="85"><item type="input">=BINOM.INV(8;0.6;0.9)</item> returns 7, the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.</paragraph> +</section> <section id="chisqinv"> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CHISQINV" id="bm_id0119200902430717" localize="false"/> <bookmark xml-lang="en-US" branch="index" id="bm_id0119200902432928"><bookmark_value>CHISQINV function</bookmark_value> |