source/text/scalc/01/04060181.xhp | 10 ++++------ 1 file changed, 4 insertions(+), 6 deletions(-)
New commits: commit 19bd09da0885b802eac86a8ed162f59ea65302c2 Author: Olivier Hallot <[email protected]> AuthorDate: Wed Jul 1 15:05:28 2026 +0200 Commit: Olivier Hallot <[email protected]> CommitDate: Wed Jul 1 16:00:21 2026 +0200 tdf#172643 Fix misleading exampls in BINOMDIST Refactor the examples of BINOMDIST and BINOM.DIST, Change-Id: Ic0d4e997099e53e5bde6697c1ef9581fbe191c77 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/207533 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/source/text/scalc/01/04060181.xhp b/source/text/scalc/01/04060181.xhp index c320614007..8cabb9c1cc 100644 --- a/source/text/scalc/01/04060181.xhp +++ b/source/text/scalc/01/04060181.xhp @@ -294,9 +294,7 @@ <bookmark branch="index" id="bm_id3143228"> <bookmark_value>BINOMDIST function</bookmark_value> </bookmark> - <bookmark branch="hid/SC_HID_FUNC_BINOMVERT" id="bm_id3150146" localize="false"/> - <h2 id="hd_id3143228">BINOMDIST</h2> <paragraph id="par_id3146897" role="paragraph"><ahelp hid="HID_FUNC_BINOMVERT">Returns the individual term binomial distribution probability.</ahelp></paragraph> @@ -308,8 +306,8 @@ <paragraph id="par_id3149760" role="paragraph"><emph>C</emph> = 0 calculates the probability of a single event and <emph>C</emph> = 1 calculates the cumulative probability.</paragraph> <embed href="text/scalc/01/common_func.xhp#IntegerTrunc"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id3145666" role="paragraph"><item type="input">=BINOMDIST(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 id="par_id3150120" role="paragraph"><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> +<paragraph role="paragraph" id="par_id621782909490927"><input>=BINOMDIST(3;12;0.5;0)</input> returns 0.0537109375, the probability of exactly 3 heads in 12 coin tosses.</paragraph> +<paragraph id="par_id3150120" role="paragraph"><input>=BINOMDIST(4;12;0.5;1)</input> returns 0.19384765625, the cumulative probabilities for the same series. That is, 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"> @@ -328,8 +326,8 @@ <paragraph id="par_id299760" role="paragraph"><emph>C</emph> = 0 calculates the probability of a single event and <emph>C</emph> = 1 calculates the cumulative probability.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id295666" role="paragraph"><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 id="par_id290120" role="paragraph"><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> +<paragraph role="paragraph" id="par_id331782910607156"><input>=BINOM.DIST(3;12;0.5;0)</input> returns 0.0537109375, the probability of exactly 3 heads in 12 coin tosses.</paragraph> +<paragraph id="par_id351782910660398" role="paragraph"><input>=BINOM.DIST(4;12;0.5;1)</input> returns 0.19384765625, the cumulative probabilities for the same series. That is, the cumulative probability of the series is 0, 1, 2, 3 or 4 times <emph>Heads</emph> (non-exclusive OR).</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/>
