summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@edx.srv.br>2014-07-19 12:11:45 -0300
committerCaolán McNamara <caolanm@redhat.com>2014-07-21 08:06:41 +0000
commit0e6d0e8907c46f3d3dcaf3f06add2496beaf16a8 (patch)
treeec7706f3599ce3cdaeba5e8d0b08034604a4a872
parent3da3b8063d11ea0d584753e17d13f6ad6b9b0aa4 (diff)
Fix fdo#80447: Help pages for MS BINOM functions
Covers BIMOM.DIST and BINOM.INV Change-Id: If1f3ef61dfa5e23c6b88818439be2932eb98aabe Reviewed-on: https://gerrit.libreoffice.org/10409 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
-rw-r--r--source/text/scalc/01/04060181.xhp30
1 files changed, 30 insertions, 0 deletions
diff --git a/source/text/scalc/01/04060181.xhp b/source/text/scalc/01/04060181.xhp
index 24d796336..4768af7df 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>