source/text/scalc/01/04060181.xhp | 22 +++++++++++----------- 1 file changed, 11 insertions(+), 11 deletions(-)
New commits: commit ec4ea5b3f355f0ffe80a570e786ce9852aa79e49 Author: Olivier Hallot <[email protected]> AuthorDate: Mon May 4 20:11:40 2026 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Tue May 5 13:00:27 2026 +0200 tdf#170437 how LO treats non-integer values for function parameters Statistics part 1 Change-Id: I94161b18da0425a505e8a20332c4c5b8355f7d58 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/204783 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 fd78682e7e..c320614007 100644 --- a/source/text/scalc/01/04060181.xhp +++ b/source/text/scalc/01/04060181.xhp @@ -158,7 +158,7 @@ <paragraph id="par_id3148875" role="paragraph"><emph>SP</emph> is the probability of success on each trial.</paragraph> <paragraph id="par_id3145352" role="paragraph"><emph>T1</emph> defines the lower limit for the number of trials.</paragraph> <paragraph id="par_id3149538" role="paragraph"><emph>T2</emph> (optional) defines the upper limit for the number of trials.</paragraph> - +<embed href="text/scalc/01/common_func.xhp#IntegerTrunc"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3154633" role="paragraph">What is the probability with ten throws of the dice, that a six will come up exactly twice? The probability of a six (or any other number) is 1/6. The following formula combines these factors:</paragraph> <paragraph id="par_id3149393" role="paragraph"><item type="input">=B(10;1/6;2)</item> returns a probability of 29%.</paragraph> @@ -306,7 +306,7 @@ <paragraph id="par_id3147492" role="paragraph"><emph>Trials</emph> is the number of independent trials.</paragraph> <paragraph id="par_id3146085" role="paragraph"><emph>SP</emph> is the probability of success on each trial.</paragraph> <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> @@ -318,7 +318,6 @@ </bookmark> <bookmark branch="hid/SC_HID_FUNC_BINOM_DIST_MS" id="bm_id2950146" localize="false"/> - <h2 id="hd_id2943228">BINOM.DIST</h2> <paragraph id="par_id2946897" role="paragraph"><ahelp hid="HID_FUNC_BINOM_DIST_MS">Returns the individual term binomial distribution probability.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> @@ -365,13 +364,15 @@ <bookmark branch="index" id="bm_id0119200902432928"> <bookmark_value>CHISQINV function</bookmark_value> </bookmark> - <h2 id="hd_id0119200902421451">CHISQINV</h2> <paragraph id="par_id0119200902421449" role="paragraph"><ahelp hid=".">Returns the inverse of CHISQDIST.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id21585771564740" role="code">CHISQINV(Probability; Degrees of Freedom)</paragraph> <paragraph id="par_id0119200902475286" role="paragraph"><emph>Probability</emph> is the probability value for which the inverse of the chi-square distribution is to be calculated.</paragraph> <paragraph id="par_id0119200902475282" role="paragraph"><emph>Degrees Of Freedom</emph> is the degrees of freedom for the chi-square function.</paragraph> +<embed href="text/scalc/01/common_func.xhp#IntegerTrunc"/> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<paragraph role="paragraph" id="par_id891777935092576"><input>=CHISQINV(0.5;1)</input> returns 0.4549364231.</paragraph> </section> <section id="chisqdotinv"> @@ -379,8 +380,6 @@ <bookmark branch="index" id="bm_id2919200902432928"> <bookmark_value>CHISQ.INV function</bookmark_value> </bookmark> - - <h2 id="hd_id2919200902421451">CHISQ.INV</h2> <paragraph id="par_id2919200902421449" role="paragraph"><ahelp hid="HID_FUNC_CHISQINV_MS">Returns the inverse of the left-tailed probability of the chi-square distribution.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> @@ -389,7 +388,7 @@ <paragraph id="par_id2919200902475282" role="paragraph"><emph>Degrees Of Freedom</emph> is the degrees of freedom for the chi-square function.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id275666" role="paragraph"><item type="input">=CHISQ.INV(0,5;1)</item> returns 0.4549364231.</paragraph> +<paragraph id="par_id275666" role="paragraph"><item type="input">=CHISQ.INV(0.5;1)</item> returns 0.4549364231.</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"/> @@ -410,7 +409,7 @@ <paragraph id="par_id3150504" role="code">CHIINV(Number; DegreesFreedom)</paragraph> <paragraph id="par_id3154898" role="paragraph"><emph>Number</emph> is the value of the error probability.</paragraph> <paragraph id="par_id3154294" role="paragraph"><emph>DegreesFreedom</emph> is the degrees of freedom of the experiment.</paragraph> - +<embed href="text/scalc/01/common_func.xhp#IntegerTrunc"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3150777" role="paragraph">A die is thrown 1020 times. The numbers on the die 1 through 6 come up 195, 151, 148, 189, 183 and 154 times (observation values). The hypothesis that the die is not fixed is to be tested.</paragraph> <paragraph id="par_id3153062" role="paragraph">The Chi square distribution of the random sample is determined by the formula given above. Since the expected value for a given number on the die for n throws is n times 1/6, thus 1020/6 = 170, the formula returns a Chi square value of 13.27.</paragraph> @@ -588,7 +587,7 @@ <paragraph id="par_id3158439" role="code">CHIDIST(Number; DegreesFreedom)</paragraph> <paragraph id="par_id3148675" role="paragraph"><emph>Number</emph> is the chi-square value of the random sample used to determine the error probability.</paragraph> <paragraph id="par_id3155615" role="paragraph"><emph>DegreesFreedom</emph> are the degrees of freedom of the experiment.</paragraph> - +<embed href="text/scalc/01/common_func.xhp#IntegerTrunc"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3145774" role="paragraph"><item type="input">=CHIDIST(13.27; 5)</item> equals 0.02.</paragraph> <paragraph id="par_id3156141" role="paragraph">If the Chi square value of the random sample is 13.27 and if the experiment has 5 degrees of freedom, then the hypothesis is assured with a probability of error of 2%.</paragraph> @@ -649,7 +648,6 @@ <bookmark_value>chi-square distribution</bookmark_value> </bookmark> - <h2 id="hd_id0119200901583452">CHISQDIST</h2> <paragraph id="par_id0119200901583471" role="paragraph"><ahelp hid=".">Returns the value of the probability density function or the cumulative distribution function for the chi-square distribution.</ahelp></paragraph> @@ -658,8 +656,10 @@ <paragraph id="par_id011920090239564" role="paragraph"><emph>Number</emph> is the number for which the function is to be calculated.</paragraph> <paragraph id="par_id0119200902395660" role="paragraph"><emph>Degrees Of Freedom</emph> is the degrees of freedom for the chi-square function.</paragraph> <paragraph id="par_id0119200902395623" role="paragraph"><emph>Cumulative</emph> (optional): 0 or False calculates the probability density function. Other values or True or omitted calculates the cumulative distribution function.</paragraph> +<embed href="text/scalc/01/common_func.xhp#IntegerTrunc"/> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<paragraph role="paragraph" id="par_id581777934770315"><input>=CHISQDIST(13.27; 5)</input> returns 0.979024230596978.</paragraph> </section> - <section id="expondist"> <bookmark branch="index" id="bm_id3150603"> <bookmark_value>EXPONDIST function</bookmark_value>
