source/text/scalc/01/04060182.xhp | 4 +++- source/text/scalc/01/04060183.xhp | 1 + source/text/scalc/01/04060184.xhp | 1 + source/text/scalc/01/04060185.xhp | 10 ++++++---- 4 files changed, 11 insertions(+), 5 deletions(-)
New commits: commit f48f1eb1f4297179c670e2ec26158c3eefd83999 Author: Olivier Hallot <[email protected]> AuthorDate: Wed May 6 16:12:04 2026 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Thu May 7 10:45:46 2026 +0200 tdf#170437 how LO treats non-integer values for function parameters Statistics part 2,3,4,5 Change-Id: I0e8eece0651c8571b72ba9d0bc4a435f5c9ab398 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/204891 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/source/text/scalc/01/04060182.xhp b/source/text/scalc/01/04060182.xhp index 19b6e15093..e86e39cb52 100644 --- a/source/text/scalc/01/04060182.xhp +++ b/source/text/scalc/01/04060182.xhp @@ -43,6 +43,7 @@ <emph>DegreesFreedom1</emph> is the number of degrees of freedom in the numerator of the F distribution.</paragraph> <paragraph id="par_id3148607" role="paragraph"> <emph>DegreesFreedom2</emph> is the number of degrees of freedom in the denominator of the F distribution.</paragraph> + <embed href="text/scalc/01/common_func.xhp#IntegerTrunc"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3145073" role="paragraph"> <item type="input">=FINV(0.5;5;10)</item> yields 0.93.</paragraph> @@ -167,7 +168,8 @@ <emph>degreesFreedom1</emph> is the degrees of freedom in the numerator in the F distribution.</paragraph> <paragraph id="par_id3146877" role="paragraph"> <emph>degreesFreedom2</emph> is the degrees of freedom in the denominator in the F distribution.</paragraph> - <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <embed href="text/scalc/01/common_func.xhp#IntegerTrunc"/> + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3150696" role="paragraph"> <item type="input">=FDIST(0.8;8;12)</item> yields 0.61.</paragraph> </section> diff --git a/source/text/scalc/01/04060183.xhp b/source/text/scalc/01/04060183.xhp index 43f6940499..48218f3151 100644 --- a/source/text/scalc/01/04060183.xhp +++ b/source/text/scalc/01/04060183.xhp @@ -209,6 +209,7 @@ <emph>SP</emph> is the probability of success for one trial.</paragraph> <paragraph role="paragraph" id="par_id3149726"> <emph>Alpha</emph> is the threshold probability to be reached or exceeded.</paragraph> +<embed href="text/scalc/01/common_func.xhp#IntegerTrunc"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id3148740"> <item type="input">=CRITBINOM(100;0.5;0.1)</item> yields 44.</paragraph> diff --git a/source/text/scalc/01/04060184.xhp b/source/text/scalc/01/04060184.xhp index 9a66e27380..33ecdb5fdf 100644 --- a/source/text/scalc/01/04060184.xhp +++ b/source/text/scalc/01/04060184.xhp @@ -223,6 +223,7 @@ <paragraph id="par_id3153044" role="paragraph"><emph>X</emph> represents the value returned for unsuccessful tests.</paragraph> <paragraph id="par_id3151018" role="paragraph"><emph>R</emph> represents the value returned for successful tests.</paragraph> <paragraph id="par_id3148878" role="paragraph"><emph>SP</emph> is the probability of the success of an attempt.</paragraph> +<embed href="text/scalc/01/common_func.xhp#IntegerTrunc"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3148770" role="paragraph"> <item type="input">=NEGBINOMDIST(1;1;0.5)</item> returns 0.25.</paragraph> diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp index 64666e71b6..b628cdc94b 100644 --- a/source/text/scalc/01/04060185.xhp +++ b/source/text/scalc/01/04060185.xhp @@ -415,6 +415,7 @@ <emph>Number</emph> is the probability associated with the two-tailed t-distribution.</paragraph> <paragraph id="par_id3155315" role="paragraph"> <emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution.</paragraph> + <embed href="text/scalc/01/common_func.xhp#IntegerTrunc"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3156010" role="paragraph"> <item type="input">=TINV(0.1;6)</item> returns 1.94</paragraph> @@ -513,6 +514,7 @@ <emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution.</paragraph> <paragraph id="par_id3149340" role="paragraph"> <emph>Mode</emph> = 1 returns the one-tailed test, <emph>Mode</emph> = 2 returns the two-tailed test.</paragraph> + <embed href="text/scalc/01/common_func.xhp#IntegerTrunc"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3149773" role="paragraph"> <item type="input">=TDIST(12;5;1)</item> @@ -685,8 +687,8 @@ <paragraph id="par_id3148466" role="code">PERMUT(Count1; Count2)</paragraph> <paragraph id="par_id3148656" role="paragraph"> <emph>Count1</emph> is the total number of objects.</paragraph> - <paragraph id="par_id3150826" role="paragraph"> - <emph>Count2</emph> is the number of objects in each permutation.</paragraph> + <paragraph id="par_id3150826" role="paragraph"><emph>Count2</emph> is the number of objects in each permutation.</paragraph> + <embed href="text/scalc/01/common_func.xhp#IntegerTrunc"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3150424" role="paragraph"> <item type="input">=PERMUT(6;3)</item> returns 120. There are 120 different possibilities, to pick a sequence of 3 playing cards out of 6 playing cards.</paragraph> @@ -701,8 +703,8 @@ <paragraph id="par_id3149298" role="code">PERMUTATIONA(Count1; Count2)</paragraph> <paragraph id="par_id3156139" role="paragraph"> <emph>Count1</emph> is the total number of objects.</paragraph> - <paragraph id="par_id3149519" role="paragraph"> - <emph>Count2</emph> is the number of objects in each permutation.</paragraph> + <paragraph id="par_id3149519" role="paragraph"><emph>Count2</emph> is the number of objects in each permutation.</paragraph> + <embed href="text/scalc/01/common_func.xhp#IntegerTrunc"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3153949" role="paragraph">How often can 2 objects be selected from a total of 11 objects?</paragraph> <paragraph id="par_id3149233" role="paragraph">
