Fix for fdo#80450: MS excel F functions help pages

F.DIST, F.DIST.RT, F.INV, F.INV.RT and F.TEST

Change-Id: Ia5cc2984c118f2d85872c80cd2ec6c533c94ff95
Reviewed-on: https://gerrit.libreoffice.org/10424
Reviewed-by: Caolán McNamara <caolanm@redhat.com>
Tested-by: Caolán McNamara <caolanm@redhat.com>

1 files changed, 80 insertions, 0 deletions

diff --git a/source/text/scalc/01/04060182.xhp b/source/text/scalc/01/04060182.xhp
index 26219db087..b444ba3d43 100644
--- a/source/text/scalc/01/04060182.xhp
+++ b/source/text/scalc/01/04060182.xhp
@@ -49,6 +49,40 @@
          <paragraph xml-lang="en-US" id="par_id3145073" role="paragraph" l10n="U" oldref="10">
             <item type="input">=FINV(0.5;5;10)</item> yields 0.93.</paragraph>
       </section>
+<section id="fdotinv">
+    <bookmark xml-lang="en-US" branch="index" id="bm_id2945388">
+        <bookmark_value>F.INV function</bookmark_value>
+        <bookmark_value>Values of the inverse left tail of the F distribution</bookmark_value>
+    </bookmark>
+    <comment>mw added one entry</comment>
+    <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_INV_LT" id="bm_id2946113" localize="false"/>
+    <paragraph xml-lang="en-US" id="hd_id2945388" role="heading" level="2" l10n="U" oldref="2">F.INV</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2955089" role="paragraph" l10n="U" oldref="3"><ahelp hid="HID_FUNC_F_INV_LT">Returns the inverse of the cumulative F distribution.</ahelp> The F distribution is used for F tests in order to set the relation between two differing data sets.</paragraph>
+    <paragraph xml-lang="en-US" id="hd_id2953816" role="heading" level="3" l10n="U" oldref="4">Syntax</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2953068" role="code" l10n="U" oldref="5">F.INV(Number; DegreesFreedom1; DegreesFreedom2)</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2946866" role="paragraph" l10n="U" oldref="6"><emph>Number</emph> is probability value for which the inverse F distribution is to be calculated.</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2953914" role="paragraph" l10n="U" oldref="7"><emph>DegreesFreedom1</emph> is the number of degrees of freedom in the numerator of the F distribution.</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2948607" role="paragraph" l10n="U" oldref="8"><emph>DegreesFreedom2</emph> is the number of degrees of freedom in the denominator of the F distribution.</paragraph>
+    <paragraph xml-lang="en-US" id="hd_id2956021" role="heading" level="3" l10n="U" oldref="9">Example</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2945073" role="paragraph" l10n="U" oldref="10"><item type="input">=F.INV(0.5;5;10)</item> yields 0.9319331609.</paragraph>
+</section>
+<section id="fdotinvdotrt">
+    <bookmark xml-lang="en-US" branch="index" id="bm_id2845388">
+        <bookmark_value>F.INV.RT function</bookmark_value>
+        <bookmark_value>Values of the inverse right tail of the F distribution</bookmark_value>
+    </bookmark>
+    <comment>mw added one entry</comment>
+    <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_INV_RT" id="bm_id2846113" localize="false"/>
+    <paragraph xml-lang="en-US" id="hd_id2845388" role="heading" level="2" l10n="U" oldref="2">F.INV.RT</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2855089" role="paragraph" l10n="U" oldref="3"><ahelp hid="HID_FUNC_F_INV_RT">Returns the inverse right tail of the F distribution.</ahelp></paragraph>
+    <paragraph xml-lang="en-US" id="hd_id2853816" role="heading" level="3" l10n="U" oldref="4">Syntax</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2853068" role="code" l10n="U" oldref="5">F.INV.RT(Number; DegreesFreedom1; DegreesFreedom2)</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2846866" role="paragraph" l10n="U" oldref="6"><emph>Number</emph> is probability value for which the inverse F distribution is to be calculated.</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2853914" role="paragraph" l10n="U" oldref="7"><emph>DegreesFreedom1</emph> is the number of degrees of freedom in the numerator of the F distribution.</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2848607" role="paragraph" l10n="U" oldref="8"><emph>DegreesFreedom2</emph> is the number of degrees of freedom in the denominator of the F distribution.</paragraph>
+    <paragraph xml-lang="en-US" id="hd_id2856021" role="heading" level="3" l10n="U" oldref="9">Example</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2845073" role="paragraph" l10n="U" oldref="10"><item type="input">=F.INV.RT(0.5;5;10)</item> yields 0.9319331609.</paragraph>
+</section>
       <section id="fisher">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3150888"><bookmark_value>FISHER function</bookmark_value>
 </bookmark>
@@ -103,6 +137,20 @@
          <paragraph xml-lang="en-US" id="par_id3159126" role="paragraph" l10n="U" oldref="35">
             <item type="input">=FTEST(A1:A30;B1:B12)</item> calculates whether the two data sets are different in their variance and returns the probability that both sets could have come from the same total population.</paragraph>
       </section>
+<section id="fdottest">
+    <bookmark xml-lang="en-US" branch="index" id="bm_id2951390">
+        <bookmark_value>F.TEST function</bookmark_value>
+    </bookmark>
+    <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_TEST_MS" id="bm_id2959263" localize="false"/>
+    <paragraph xml-lang="en-US" id="hd_id2951390" role="heading" level="2" l10n="U" oldref="28">F.TEST</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2950534" role="paragraph" l10n="U" oldref="29"><ahelp hid="HID_FUNC_F_TEST_MS">Returns the result of an F test.</ahelp></paragraph>
+    <paragraph xml-lang="en-US" id="hd_id2966466" role="heading" level="3" l10n="U" oldref="30">Syntax</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2953024" role="code" l10n="U" oldref="31">F.TEST(Data1; Data2)</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2950032" role="paragraph" l10n="U" oldref="32"><emph>Data1</emph> is the first record array.</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2953018" role="paragraph" l10n="U" oldref="33"><emph>Data2</emph> is the second record array.</paragraph>
+    <paragraph xml-lang="en-US" id="hd_id2953123" role="heading" level="3" l10n="U" oldref="34">Example</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2959126" role="paragraph" l10n="U" oldref="35"><item type="input">=F.TEST(A1:A30;B1:B12)</item> calculates whether the two data sets are different in their variance and returns the probability that both sets could have come from the same total population.</paragraph>
+</section>
       <section id="fdist">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3150372"><bookmark_value>FDIST function</bookmark_value>
 </bookmark>
@@ -124,6 +172,38 @@
          <paragraph xml-lang="en-US" id="par_id3150696" role="paragraph" l10n="U" oldref="45">
             <item type="input">=FDIST(0.8;8;12)</item> yields 0.61.</paragraph>
       </section>
+<section id="fdotdist">
+    <bookmark xml-lang="en-US" branch="index" id="bm_id2950372">
+        <bookmark_value>F.DIST function</bookmark_value>
+    </bookmark>
+    <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_DIST_LT" id="bm_id2949722" localize="false"/>
+    <paragraph xml-lang="en-US" id="hd_id2950372" role="heading" level="2" l10n="U" oldref="37">F.DIST</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2952981" role="paragraph" l10n="U" oldref="38"><ahelp hid="HID_FUNC_F_DIST_LT">Calculates the values of the left tail of the F distribution.</ahelp></paragraph>
+    <paragraph xml-lang="en-US" id="hd_id2950484" role="heading" level="3" l10n="U" oldref="39">Syntax</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2945826" role="code" l10n="U" oldref="40">F.DIST(Number; DegreesFreedom1; DegreesFreedom2; Cumulative)</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2950461" role="paragraph" l10n="U" oldref="41"><emph>Number</emph> is the value for which the F distribution is to be calculated.</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2950029" role="paragraph" l10n="U" oldref="42"><emph>degreesFreedom1</emph> is the degrees of freedom in the numerator in the F distribution.</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2946877" role="paragraph" l10n="U" oldref="43"><emph>degreesFreedom2</emph> is the degrees of freedom in the denominator in the F distribution.</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2946878" role="paragraph" l10n="U" oldref="43"><emph>Cumulative</emph> = 0 or False calculates the density function <emph>Cumulative</emph> = 1 or True calculates the distribution.</paragraph>
+    <paragraph xml-lang="en-US" id="hd_id2947423" role="heading" level="3" l10n="U" oldref="44">Example</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2950696" role="paragraph" l10n="U" oldref="45"><item type="input">=F.DIST(0.8;8;12;0)</item> yields 0.7095282499.</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2950697" role="paragraph" l10n="U" oldref="45"><item type="input">=F.DIST(0.8;8;12;1)</item> yields 0.3856603563.</paragraph>
+</section>
+<section id="fdotdistdotrt">
+    <bookmark xml-lang="en-US" branch="index" id="bm_id2850372">
+        <bookmark_value>F.DIST.RT function</bookmark_value>
+    </bookmark>
+    <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_DIST_RT" id="bm_id289722" localize="false"/>
+    <paragraph xml-lang="en-US" id="hd_id280372" role="heading" level="2" l10n="U" oldref="37">F.DIST.RT</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2852981" role="paragraph" l10n="U" oldref="38"><ahelp hid="HID_FUNC_F_DIST_RT">Calculates the values of the right tail of the F distribution.</ahelp></paragraph>
+    <paragraph xml-lang="en-US" id="hd_id2850484" role="heading" level="3" l10n="U" oldref="39">Syntax</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2845826" role="code" l10n="U" oldref="40">F.DIST.RT(Number; DegreesFreedom1; DegreesFreedom2)</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2850461" role="paragraph" l10n="U" oldref="41"><emph>Number</emph> is the value for which the F distribution is to be calculated.</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2850029" role="paragraph" l10n="U" oldref="42"><emph>degreesFreedom1</emph> is the degrees of freedom in the numerator in the F distribution.</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2846877" role="paragraph" l10n="U" oldref="43"><emph>degreesFreedom2</emph> is the degrees of freedom in the denominator in the F distribution.</paragraph>
+    <paragraph xml-lang="en-US" id="hd_id2847423" role="heading" level="3" l10n="U" oldref="44">Example</paragraph>
+    <paragraph xml-lang="en-US" id="par_id2850696" role="paragraph" l10n="U" oldref="45"><item type="input">=F.DIST.RT(0.8;8;12)</item> yields 0.6143396437.</paragraph>
+</section>
       <section id="gamma">
 <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GAMMA" id="bm_id0119200903221254" localize="false"/>
 <bookmark xml-lang="en-US" branch="index" id="bm_id0119200903223192"><bookmark_value>GAMMA function</bookmark_value>