source/text/scalc/01/04060181.xhp | 27 ++++++++++++--------------- source/text/scalc/01/04060182.xhp | 22 ++++++++++++++-------- source/text/scalc/01/04060185.xhp | 31 ++++++++++++++++++++----------- 3 files changed, 46 insertions(+), 34 deletions(-)
New commits: commit bd106491ceefddc54dc031b673ef01e9b49480ee Author: Olivier Hallot <[email protected]> AuthorDate: Tue Jul 21 10:53:52 2026 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Tue Jul 21 16:01:01 2026 +0200 TDF#172634 and more. Document "LEGACY." ODFF names. tdf#172641, tdf#172640, tdf#172639, tdf#172638, tdf#172637, tdf#172635 Change-Id: I34087ffd1406f7d1b70cd75aad357737e6f22991 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/208400 Reviewed-by: Olivier Hallot <[email protected]> Tested-by: Jenkins diff --git a/source/text/scalc/01/04060181.xhp b/source/text/scalc/01/04060181.xhp index ec51ffdb31..9c86d4e925 100644 --- a/source/text/scalc/01/04060181.xhp +++ b/source/text/scalc/01/04060181.xhp @@ -399,15 +399,14 @@ </section> <section id="chiinv"> +<bookmark branch="hid/SC_HID_FUNC_CHIINV" id="bm_id3148823" localize="false"/> <bookmark branch="index" id="bm_id3148835"> - <bookmark_value>CHIINV function</bookmark_value> +<bookmark_value>CHIINV function</bookmark_value> +<bookmark_value>LEGACY.CHIINV function</bookmark_value> </bookmark> - -<bookmark branch="hid/SC_HID_FUNC_CHIINV" id="bm_id3148823" localize="false"/> - <h2 id="hd_id3148835">CHIINV</h2> <paragraph id="par_id3149906" role="paragraph"><ahelp hid="HID_FUNC_CHIINV">Returns the inverse of the one-tailed probability of the chi-squared distribution.</ahelp></paragraph> - +<note id="par_id851784638034843">Function CHIINV implements the ODF function LEGACY.CHIINV.</note> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <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> @@ -450,16 +449,15 @@ </section> <section id="chitest"> +<bookmark branch="hid/SC_HID_FUNC_CHITEST" id="bm_id3155355" localize="false"/> <bookmark branch="index" id="bm_id3154260"> - <bookmark_value>CHITEST function</bookmark_value> +<bookmark_value>CHITEST function</bookmark_value> +<bookmark_value>LEGACY.CHITEST function</bookmark_value> </bookmark> - -<bookmark branch="hid/SC_HID_FUNC_CHITEST" id="bm_id3155355" localize="false"/> - <h2 id="hd_id3154260">CHITEST</h2> <paragraph id="par_id3151052" role="paragraph"><ahelp hid="HID_FUNC_CHITEST">Returns the probability of a deviance from a random distribution of two test series based on the chi-squared test for independence.</ahelp> CHITEST returns the chi-squared distribution of the data.</paragraph> <paragraph id="par_id3148925" role="paragraph">The probability determined by CHITEST can also be determined with CHIDIST, in which case the Chi square of the random sample must then be passed as a parameter instead of the data row.</paragraph> - +<note id="par_id851784638724624">Function CHITEST implements the ODF function LEGACY.CHITEST.</note> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3149162" role="code">CHITEST(DataB; DataE)</paragraph> <paragraph id="par_id3158421" role="paragraph"><emph>DataB</emph> is the array of the observations.</paragraph> @@ -576,16 +574,15 @@ </section> <section id="chidist"> +<bookmark branch="hid/SC_HID_FUNC_CHIVERT" id="bm_id3147521" localize="false"/> <bookmark branch="index" id="bm_id3148690"> - <bookmark_value>CHIDIST function</bookmark_value> +<bookmark_value>CHIDIST function</bookmark_value> +<bookmark_value>LEGACY.CHIDIST function</bookmark_value> </bookmark> - -<bookmark branch="hid/SC_HID_FUNC_CHIVERT" id="bm_id3147521" localize="false"/> - <h2 id="hd_id3148690">CHIDIST</h2> <paragraph id="par_id3156338" role="paragraph"><ahelp hid="HID_FUNC_CHIVERT">Returns the probability value from the indicated Chi square that a hypothesis is confirmed.</ahelp> CHIDIST compares the Chi square value to be given for a random sample that is calculated from the sum of (observed value-expected value)^2/expected value for all values with the theoretical Chi square distribution and determines from this the probability of error for the hypothesis to be tested.</paragraph> <paragraph id="par_id3151316" role="paragraph">The probability determined by CHIDIST can also be determined by CHITEST.</paragraph> - +<note id="par_id91784637709989">Function CHIDIST implements the ODF function LEGACY.CHIDIST.</note> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <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> diff --git a/source/text/scalc/01/04060182.xhp b/source/text/scalc/01/04060182.xhp index e86e39cb52..08293d7199 100644 --- a/source/text/scalc/01/04060182.xhp +++ b/source/text/scalc/01/04060182.xhp @@ -29,13 +29,16 @@ </variable></h1> <sort order="asc" descendant="h2"> <section id="finv"> -<bookmark branch="index" id="bm_id3145388"><bookmark_value>FINV function</bookmark_value> - <bookmark_value>inverse F probability distribution</bookmark_value> +<bookmark branch="index" id="bm_id3145388"> +<bookmark_value>FINV function</bookmark_value> +<bookmark_value>LEGACY.FINV function</bookmark_value> +<bookmark_value>inverse F probability distribution</bookmark_value> </bookmark><comment>mw added one entry</comment> <bookmark branch="hid/SC_HID_FUNC_FINV" id="bm_id3146113" localize="false"/> <h2 id="hd_id3145388">FINV</h2> - <paragraph id="par_id3155089" role="paragraph"><ahelp hid="HID_FUNC_FINV">Returns the inverse of the F probability distribution.</ahelp> The F distribution is used for F tests in order to set the relation between two differing data sets.</paragraph> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<paragraph id="par_id3155089" role="paragraph"><ahelp hid="HID_FUNC_FINV">Returns the inverse of the F probability distribution.</ahelp> The F distribution is used for F tests in order to set the relation between two differing data sets.</paragraph> +<note id="par_id581784639525767">Function FINV implements the ODF function LEGACY.FINV.</note> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3153068" role="code">FINV(Number; DegreesFreedom1; DegreesFreedom2)</paragraph> <paragraph id="par_id3146866" role="paragraph"> <emph>Number</emph> is probability value for which the inverse F distribution is to be calculated.</paragraph> @@ -154,12 +157,15 @@ <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640273986703" localize="false"><literal>COM.MICROSOFT.F.TEST</literal></paragraph> </section> - <section id="fdist"> -<bookmark branch="index" id="bm_id3150372"><bookmark_value>FDIST function</bookmark_value> +<section id="fdist"> +<bookmark branch="index" id="bm_id3150372"> +<bookmark_value>FDIST function</bookmark_value> +<bookmark_value>LEGACY.FDIST function</bookmark_value> </bookmark> <bookmark branch="hid/SC_HID_FUNC_FVERT" id="bm_id3149722" localize="false"/> <h2 id="hd_id3150372">FDIST</h2> - <paragraph id="par_id3152981" role="paragraph"><ahelp hid="HID_FUNC_FVERT">Calculates the values of an F distribution.</ahelp></paragraph> +<paragraph id="par_id3152981" role="paragraph"><ahelp hid="HID_FUNC_FVERT">Calculates the values of an F distribution.</ahelp></paragraph> +<note id="par_id951784639377506">Function FDIST implements the ODF function LEGACY.FDIST.</note> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3145826" role="code">FDIST(Number; DegreesFreedom1; DegreesFreedom2)</paragraph> <paragraph id="par_id3150461" role="paragraph"> @@ -172,7 +178,7 @@ <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> +</section> <section id="fdotdist"> <bookmark branch="index" id="bm_id2950372"> <bookmark_value>F.DIST function</bookmark_value> diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp index b628cdc94b..3248133eb7 100644 --- a/source/text/scalc/01/04060185.xhp +++ b/source/text/scalc/01/04060185.xhp @@ -279,12 +279,15 @@ <item type="input">=STANDARDIZE(11;10;1)</item> returns 1. The value 11 in a normal distribution with a mean of 10 and a standard deviation of 1 is as much above the mean of 10, as the value 1 is above the mean of the standard normal distribution.</paragraph> </section> <section id="normsinv"> -<bookmark branch="index" id="bm_id3157986"><bookmark_value>NORMSINV function</bookmark_value> - <bookmark_value>normal distribution;inverse of standard</bookmark_value> +<bookmark branch="index" id="bm_id3157986"> +<bookmark_value>NORMSINV function</bookmark_value> +<bookmark_value>LEGACY.NORMSINV function</bookmark_value> +<bookmark_value>normal distribution;inverse of standard</bookmark_value> </bookmark> <bookmark branch="hid/SC_HID_FUNC_STANDNORMINV" id="bm_id3148389" localize="false"/> <h2 id="hd_id3157986">NORMSINV</h2> - <paragraph id="par_id3151282" role="paragraph"><ahelp hid="HID_FUNC_STANDNORMINV">Returns the inverse of the standard normal cumulative distribution.</ahelp></paragraph> +<paragraph id="par_id3151282" role="paragraph"><ahelp hid="HID_FUNC_STANDNORMINV">Returns the inverse of the standard normal cumulative distribution.</ahelp></paragraph> +<note id="par_id121784640129958">Function NORMSINV implements the ODF function LEGACY.NORMSINV.</note> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3154195" role="code">NORMSINV(Number)</paragraph> <paragraph id="par_id3148772" role="paragraph"> @@ -313,13 +316,16 @@ <paragraph role="paragraph" id="par_id341000873986703" localize="false"><literal>COM.MICROSOFT.NORM.S.INV</literal></paragraph> </section> <section id="normsdist"> -<bookmark branch="index" id="bm_id3147538"><bookmark_value>NORMSDIST function</bookmark_value> - <bookmark_value>normal distribution;statistics</bookmark_value> +<bookmark branch="index" id="bm_id3147538"> +<bookmark_value>NORMSDIST function</bookmark_value> +<bookmark_value>LEGACY.NORMSDIST function</bookmark_value> +<bookmark_value>normal distribution;statistics</bookmark_value> </bookmark> <bookmark branch="hid/SC_HID_FUNC_STANDNORMVERT" id="bm_id3145269" localize="false"/> <h2 id="hd_id3147538">NORMSDIST</h2> - <paragraph id="par_id3150474" role="paragraph"><ahelp hid="HID_FUNC_STANDNORMVERT">Returns the standard normal cumulative distribution function. The distribution has a mean of zero and a standard deviation of one.</ahelp></paragraph> - <paragraph id="par_id8652302" role="paragraph">It is GAUSS(x)=NORMSDIST(x)-0.5</paragraph> +<paragraph id="par_id3150474" role="paragraph"><ahelp hid="HID_FUNC_STANDNORMVERT">Returns the standard normal cumulative distribution function. The distribution has a mean of zero and a standard deviation of one.</ahelp></paragraph> +<paragraph id="par_id8652302" role="paragraph">It is GAUSS(x)=NORMSDIST(x)-0.5</paragraph> +<note id="par_id991784639990181">Function NORMSDIST implements the ODF function LEGACY.NORMSDIST.</note> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3158411" role="code">NORMSDIST(Number)</paragraph> <paragraph id="par_id3154950" role="paragraph"> @@ -499,13 +505,16 @@ <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640844986703" localize="false"><literal>COM.MICROSOFT.T.TEST</literal></paragraph> </section> - <section id="tdist"> -<bookmark branch="index" id="bm_id3154930"><bookmark_value>TDIST function</bookmark_value> - <bookmark_value>t-distribution</bookmark_value> +<section id="tdist"> +<bookmark branch="index" id="bm_id3154930"> +<bookmark_value>TDIST function</bookmark_value> +<bookmark_value>LEGACY.TDIST function</bookmark_value> +<bookmark_value>t-distribution</bookmark_value> </bookmark> <bookmark branch="hid/SC_HID_FUNC_TVERT" id="bm_id3153095" localize="false"/> <h2 id="hd_id3154930">TDIST</h2> - <paragraph id="par_id3153372" role="paragraph"><ahelp hid="HID_FUNC_TVERT">Returns the t-distribution.</ahelp></paragraph> +<paragraph id="par_id3153372" role="paragraph"><ahelp hid="HID_FUNC_TVERT">Returns the t-distribution.</ahelp></paragraph> +<note id="par_id221784640312410">Function TDIST implements the ODF function LEGACY.TDIST.</note> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3150521" role="code">TDIST(Number; DegreesFreedom; Mode)</paragraph> <paragraph id="par_id3146991" role="paragraph">
