diff options
Diffstat (limited to 'source/text/scalc/01/04060182.xhp')
| -rw-r--r-- | source/text/scalc/01/04060182.xhp | 452 |
1 files changed, 204 insertions, 248 deletions
diff --git a/source/text/scalc/01/04060182.xhp b/source/text/scalc/01/04060182.xhp index 31ec00552b..c1a7813e89 100644 --- a/source/text/scalc/01/04060182.xhp +++ b/source/text/scalc/01/04060182.xhp @@ -27,7 +27,7 @@ </topic> </meta> <body> - <paragraph xml-lang="en-US" id="hd_id3154372" role="heading" level="1" l10n="U" oldref="1"><variable id="fh"><link href="text/scalc/01/04060182.xhp" name="Statistical Functions Part Two">Statistical Functions Part Two</link> + <paragraph xml-lang="en-US" id="hd_id3154372" role="heading" level="1"><variable id="fh"><link href="text/scalc/01/04060182.xhp" name="Statistical Functions Part Two">Statistical Functions Part Two</link> </variable></paragraph> <sort order="asc"> <section id="finv"> @@ -35,18 +35,18 @@ <bookmark_value>inverse F probability distribution</bookmark_value> </bookmark><comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FINV" id="bm_id3146113" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3145388" role="heading" level="2" l10n="U" oldref="2">FINV</paragraph> - <paragraph xml-lang="en-US" id="par_id3155089" role="paragraph" l10n="U" oldref="3"><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> - <paragraph xml-lang="en-US" id="hd_id3153816" role="heading" level="3" l10n="U" oldref="4">Syntax</paragraph> - <paragraph xml-lang="en-US" id="par_id3153068" role="code" l10n="U" oldref="5">FINV(Number; DegreesFreedom1; DegreesFreedom2)</paragraph> - <paragraph xml-lang="en-US" id="par_id3146866" role="paragraph" l10n="U" oldref="6"> +<paragraph xml-lang="en-US" id="hd_id3145388" role="heading" level="2">FINV</paragraph> + <paragraph xml-lang="en-US" 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> + <paragraph xml-lang="en-US" id="hd_id3153816" role="heading" level="3">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3153068" role="code">FINV(Number; DegreesFreedom1; DegreesFreedom2)</paragraph> + <paragraph xml-lang="en-US" id="par_id3146866" role="paragraph"> <emph>Number</emph> is probability value for which the inverse F distribution is to be calculated.</paragraph> - <paragraph xml-lang="en-US" id="par_id3153914" role="paragraph" l10n="U" oldref="7"> + <paragraph xml-lang="en-US" id="par_id3153914" role="paragraph"> <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_id3148607" role="paragraph" l10n="U" oldref="8"> + <paragraph xml-lang="en-US" id="par_id3148607" role="paragraph"> <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_id3156021" role="heading" level="3" l10n="U" oldref="9">Example</paragraph> - <paragraph xml-lang="en-US" id="par_id3145073" role="paragraph" l10n="U" oldref="10"> + <paragraph xml-lang="en-US" id="hd_id3156021" role="heading" level="3">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3145073" role="paragraph"> <item type="input">=FINV(0.5;5;10)</item> yields 0.93.</paragraph> </section> <section id="fdotinv"> @@ -56,15 +56,15 @@ </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> + <paragraph xml-lang="en-US" id="hd_id2945388" role="heading" level="2">F.INV</paragraph> + <paragraph xml-lang="en-US" id="par_id2955089" role="paragraph"><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">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id2953068" role="code">F.INV(Number; DegreesFreedom1; DegreesFreedom2)</paragraph> + <paragraph xml-lang="en-US" id="par_id2946866" role="paragraph"><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"><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"><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">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id2945073" role="paragraph"><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"> @@ -73,31 +73,28 @@ </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> + <paragraph xml-lang="en-US" id="hd_id2845388" role="heading" level="2">F.INV.RT</paragraph> + <paragraph xml-lang="en-US" id="par_id2855089" role="paragraph"><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">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id2853068" role="code">F.INV.RT(Number; DegreesFreedom1; DegreesFreedom2)</paragraph> + <paragraph xml-lang="en-US" id="par_id2846866" role="paragraph"><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"><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"><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">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id2845073" role="paragraph"><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> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FISHER" id="bm_id3146782" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3150888" role="heading" level="2" l10n="U" - oldref="12">FISHER</paragraph> - <paragraph xml-lang="en-US" id="par_id3155384" role="paragraph" l10n="U" oldref="13"><ahelp hid="HID_FUNC_FISHER">Returns the Fisher transformation for x and creates a function close to a normal distribution.</ahelp></paragraph> - <paragraph xml-lang="en-US" id="hd_id3149898" role="heading" level="3" l10n="U" - oldref="14">Syntax</paragraph> - <paragraph xml-lang="en-US" id="par_id3143220" role="code" l10n="U" oldref="15">FISHER(Number)</paragraph> - <paragraph xml-lang="en-US" id="par_id3159228" role="paragraph" l10n="U" oldref="16"> +<paragraph xml-lang="en-US" id="hd_id3150888" role="heading" level="2" >FISHER</paragraph> + <paragraph xml-lang="en-US" id="par_id3155384" role="paragraph"><ahelp hid="HID_FUNC_FISHER">Returns the Fisher transformation for x and creates a function close to a normal distribution.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3149898" role="heading" level="3" >Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3143220" role="code">FISHER(Number)</paragraph> + <paragraph xml-lang="en-US" id="par_id3159228" role="paragraph"> <emph>Number</emph> is the value to be transformed.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3154763" role="heading" level="3" l10n="U" - oldref="17">Example</paragraph> - <paragraph xml-lang="en-US" id="par_id3149383" role="paragraph" l10n="U" oldref="18"> + <paragraph xml-lang="en-US" id="hd_id3154763" role="heading" level="3" >Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3149383" role="paragraph"> <item type="input">=FISHER(0.5)</item> yields 0.55.</paragraph> </section> <section id="fisherinv"> @@ -105,36 +102,30 @@ <bookmark_value>inverse of Fisher transformation</bookmark_value> </bookmark><comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FISHERINV" id="bm_id3149317" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3155758" role="heading" level="2" l10n="U" - oldref="20">FISHERINV</paragraph> - <paragraph xml-lang="en-US" id="par_id3154734" role="paragraph" l10n="U" oldref="21"><ahelp hid="HID_FUNC_FISHERINV">Returns the inverse of the Fisher transformation for x and creates a function close to a normal distribution.</ahelp></paragraph> - <paragraph xml-lang="en-US" id="hd_id3155755" role="heading" level="3" l10n="U" - oldref="22">Syntax</paragraph> - <paragraph xml-lang="en-US" id="par_id3146108" role="code" l10n="U" oldref="23">FISHERINV(Number)</paragraph> - <paragraph xml-lang="en-US" id="par_id3145115" role="paragraph" l10n="U" oldref="24"> +<paragraph xml-lang="en-US" id="hd_id3155758" role="heading" level="2" >FISHERINV</paragraph> + <paragraph xml-lang="en-US" id="par_id3154734" role="paragraph"><ahelp hid="HID_FUNC_FISHERINV">Returns the inverse of the Fisher transformation for x and creates a function close to a normal distribution.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3155755" role="heading" level="3" >Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3146108" role="code">FISHERINV(Number)</paragraph> + <paragraph xml-lang="en-US" id="par_id3145115" role="paragraph"> <emph>Number</emph> is the value that is to undergo reverse-transformation.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3155744" role="heading" level="3" l10n="U" - oldref="25">Example</paragraph> - <paragraph xml-lang="en-US" id="par_id3150432" role="paragraph" l10n="U" oldref="26"> + <paragraph xml-lang="en-US" id="hd_id3155744" role="heading" level="3" >Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3150432" role="paragraph"> <item type="input">=FISHERINV(0.5)</item> yields 0.46.</paragraph> </section> <section id="ftest"> <bookmark xml-lang="en-US" branch="index" id="bm_id3151390"><bookmark_value>FTEST function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FTEST" id="bm_id3159263" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3151390" role="heading" level="2" l10n="U" - oldref="28">FTEST</paragraph> - <paragraph xml-lang="en-US" id="par_id3150534" role="paragraph" l10n="U" oldref="29"><ahelp hid="HID_FUNC_FTEST">Returns the result of an F test.</ahelp></paragraph> - <paragraph xml-lang="en-US" id="hd_id3166466" role="heading" level="3" l10n="U" - oldref="30">Syntax</paragraph> - <paragraph xml-lang="en-US" id="par_id3153024" role="code" l10n="U" oldref="31">FTEST(Data1; Data2)</paragraph> - <paragraph xml-lang="en-US" id="par_id3150032" role="paragraph" l10n="U" oldref="32"> +<paragraph xml-lang="en-US" id="hd_id3151390" role="heading" level="2" >FTEST</paragraph> + <paragraph xml-lang="en-US" id="par_id3150534" role="paragraph"><ahelp hid="HID_FUNC_FTEST">Returns the result of an F test.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3166466" role="heading" level="3" >Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3153024" role="code">FTEST(Data1; Data2)</paragraph> + <paragraph xml-lang="en-US" id="par_id3150032" role="paragraph"> <emph>Data1</emph> is the first record array.</paragraph> - <paragraph xml-lang="en-US" id="par_id3153018" role="paragraph" l10n="U" oldref="33"> + <paragraph xml-lang="en-US" id="par_id3153018" role="paragraph"> <emph>Data2</emph> is the second record array.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3153123" role="heading" level="3" l10n="U" - oldref="34">Example</paragraph> - <paragraph xml-lang="en-US" id="par_id3159126" role="paragraph" l10n="U" oldref="35"> + <paragraph xml-lang="en-US" id="hd_id3153123" role="heading" level="3" >Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3159126" role="paragraph"> <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"> @@ -142,34 +133,31 @@ <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> + <paragraph xml-lang="en-US" id="hd_id2951390" role="heading" level="2">F.TEST</paragraph> + <paragraph xml-lang="en-US" id="par_id2950534" role="paragraph"><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">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id2953024" role="code">F.TEST(Data1; Data2)</paragraph> + <paragraph xml-lang="en-US" id="par_id2950032" role="paragraph"><emph>Data1</emph> is the first record array.</paragraph> + <paragraph xml-lang="en-US" id="par_id2953018" role="paragraph"><emph>Data2</emph> is the second record array.</paragraph> + <paragraph xml-lang="en-US" id="hd_id2953123" role="heading" level="3">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id2959126" role="paragraph"><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> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FVERT" id="bm_id3149722" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3150372" role="heading" level="2" l10n="U" - oldref="37">FDIST</paragraph> - <paragraph xml-lang="en-US" id="par_id3152981" role="paragraph" l10n="U" oldref="38"><ahelp hid="HID_FUNC_FVERT">Calculates the values of an F distribution.</ahelp></paragraph> - <paragraph xml-lang="en-US" id="hd_id3150484" role="heading" level="3" l10n="U" - oldref="39">Syntax</paragraph> - <paragraph xml-lang="en-US" id="par_id3145826" role="code" l10n="U" oldref="40">FDIST(Number; DegreesFreedom1; DegreesFreedom2)</paragraph> - <paragraph xml-lang="en-US" id="par_id3150461" role="paragraph" l10n="U" oldref="41"> +<paragraph xml-lang="en-US" id="hd_id3150372" role="heading" level="2" >FDIST</paragraph> + <paragraph xml-lang="en-US" id="par_id3152981" role="paragraph"><ahelp hid="HID_FUNC_FVERT">Calculates the values of an F distribution.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3150484" role="heading" level="3" >Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3145826" role="code">FDIST(Number; DegreesFreedom1; DegreesFreedom2)</paragraph> + <paragraph xml-lang="en-US" id="par_id3150461" role="paragraph"> <emph>Number</emph> is the value for which the F distribution is to be calculated.</paragraph> - <paragraph xml-lang="en-US" id="par_id3150029" role="paragraph" l10n="U" oldref="42"> + <paragraph xml-lang="en-US" id="par_id3150029" role="paragraph"> <emph>degreesFreedom1</emph> is the degrees of freedom in the numerator in the F distribution.</paragraph> - <paragraph xml-lang="en-US" id="par_id3146877" role="paragraph" l10n="U" oldref="43"> + <paragraph xml-lang="en-US" id="par_id3146877" role="paragraph"> <emph>degreesFreedom2</emph> is the degrees of freedom in the denominator in the F distribution.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3147423" role="heading" level="3" l10n="U" - oldref="44">Example</paragraph> - <paragraph xml-lang="en-US" id="par_id3150696" role="paragraph" l10n="U" oldref="45"> + <paragraph xml-lang="en-US" id="hd_id3147423" role="heading" level="3" >Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3150696" role="paragraph"> <item type="input">=FDIST(0.8;8;12)</item> yields 0.61.</paragraph> </section> <section id="fdotdist"> @@ -177,84 +165,78 @@ <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> + <paragraph xml-lang="en-US" id="hd_id2950372" role="heading" level="2">F.DIST</paragraph> + <paragraph xml-lang="en-US" id="par_id2952981" role="paragraph"><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">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id2945826" role="code">F.DIST(Number; DegreesFreedom1; DegreesFreedom2; Cumulative)</paragraph> + <paragraph xml-lang="en-US" id="par_id2950461" role="paragraph"><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"><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"><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"><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">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id2950696" role="paragraph"><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"><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> + <paragraph xml-lang="en-US" id="hd_id280372" role="heading" level="2">F.DIST.RT</paragraph> + <paragraph xml-lang="en-US" id="par_id2852981" role="paragraph"><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">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id2845826" role="code">F.DIST.RT(Number; DegreesFreedom1; DegreesFreedom2)</paragraph> + <paragraph xml-lang="en-US" id="par_id2850461" role="paragraph"><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"><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"><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">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id2850696" role="paragraph"><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> </bookmark> -<paragraph xml-lang="en-US" id="hd_id0119200903205393" role="heading" level="2" l10n="NEW">GAMMA</paragraph> - <paragraph xml-lang="en-US" id="par_id0119200903205379" role="paragraph" l10n="NEW"><ahelp hid=".">Returns the Gamma function value.</ahelp> Note that GAMMAINV is not the inverse of GAMMA, but of GAMMADIST.</paragraph> - <paragraph xml-lang="en-US" id="hd_id0119200903271613" role="heading" level="3" l10n="NEW">Syntax</paragraph> - <paragraph xml-lang="en-US" id="par_id0119200903271614" role="paragraph" l10n="NEW"> +<paragraph xml-lang="en-US" id="hd_id0119200903205393" role="heading" level="2">GAMMA</paragraph> + <paragraph xml-lang="en-US" id="par_id0119200903205379" role="paragraph"><ahelp hid=".">Returns the Gamma function value.</ahelp> Note that GAMMAINV is not the inverse of GAMMA, but of GAMMADIST.</paragraph> + <paragraph xml-lang="en-US" id="hd_id0119200903271613" role="heading" level="3">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id0119200903271614" role="paragraph"> <emph>Number</emph> is the number for which the Gamma function value is to be calculated.</paragraph> </section> <section id="gammainv"> <bookmark xml-lang="en-US" branch="index" id="bm_id3154841"><bookmark_value>GAMMAINV function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GAMMAINV" id="bm_id3149249" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3154841" role="heading" level="2" l10n="U" - oldref="47">GAMMAINV</paragraph> - <paragraph xml-lang="en-US" id="par_id3153932" role="paragraph" l10n="U" oldref="48"><ahelp hid="HID_FUNC_GAMMAINV">Returns the inverse of the Gamma cumulative distribution GAMMADIST.</ahelp> This function allows you to search for variables with different distribution.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3149949" role="heading" level="3" l10n="U" - oldref="49">Syntax</paragraph> - <paragraph xml-lang="en-US" id="par_id3155828" role="code" l10n="U" oldref="50">GAMMAINV(Number; Alpha; Beta)</paragraph> - <paragraph xml-lang="en-US" id="par_id3145138" role="paragraph" l10n="U" oldref="51"> +<paragraph xml-lang="en-US" id="hd_id3154841" role="heading" level="2" >GAMMAINV</paragraph> + <paragraph xml-lang="en-US" id="par_id3153932" role="paragraph"><ahelp hid="HID_FUNC_GAMMAINV">Returns the inverse of the Gamma cumulative distribution GAMMADIST.</ahelp> This function allows you to search for variables with different distribution.</paragraph> + <paragraph xml-lang="en-US" id="hd_id3149949" role="heading" level="3" >Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3155828" role="code">GAMMAINV(Number; Alpha; Beta)</paragraph> + <paragraph xml-lang="en-US" id="par_id3145138" role="paragraph"> <emph>Number</emph> is the probability value for which the inverse Gamma distribution is to be calculated.</paragraph> - <paragraph xml-lang="en-US" id="par_id3152785" role="paragraph" l10n="U" oldref="52"> + <paragraph xml-lang="en-US" id="par_id3152785" role="paragraph"> <emph>Alpha</emph> is the parameter Alpha of the Gamma distribution.</paragraph> - <paragraph xml-lang="en-US" id="par_id3154561" role="paragraph" l10n="U" oldref="53"> + <paragraph xml-lang="en-US" id="par_id3154561" role="paragraph"> <emph>Beta</emph> is the parameter Beta of the Gamma distribution.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3148734" role="heading" level="3" l10n="U" - oldref="54">Example</paragraph> - <paragraph xml-lang="en-US" id="par_id3153331" role="paragraph" l10n="U" oldref="55"> + <paragraph xml-lang="en-US" id="hd_id3148734" role="heading" level="3" >Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3153331" role="paragraph"> <item type="input">=GAMMAINV(0.8;1;1)</item> yields 1.61.</paragraph> </section> <section id="gammadotinv"> <bookmark xml-lang="en-US" branch="index" id="bm_id2914841"><bookmark_value>GAMMA.INV function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GAMMAINV_MS" id="bm_id2919249" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id2914841" role="heading" level="2" l10n="U" - oldref="47">GAMMA.INV</paragraph> - <paragraph xml-lang="en-US" id="par_id2913932" role="paragraph" l10n="U" oldref="48"><ahelp hid="HID_FUNC_GAMMAINV_MS">Returns the inverse of the Gamma cumulative distribution GAMMADIST.</ahelp> This function allows you to search for variables with different distribution.</paragraph> +<paragraph xml-lang="en-US" id="hd_id2914841" role="heading" level="2" >GAMMA.INV</paragraph> + <paragraph xml-lang="en-US" id="par_id2913932" role="paragraph"><ahelp hid="HID_FUNC_GAMMAINV_MS">Returns the inverse of the Gamma cumulative distribution GAMMADIST.</ahelp> This function allows you to search for variables with different distribution.</paragraph> <paragraph id="par_id291422405814" role="paragraph" xml-lang="en-US">This function is identical to GAMMAINV and was introduced for interoperability with other office suites.</paragraph> - <paragraph xml-lang="en-US" id="hd_id2919949" role="heading" level="3" l10n="U" - oldref="49">Syntax</paragraph> - <paragraph xml-lang="en-US" id="par_id2915828" role="code" l10n="U" oldref="50">GAMMA.INV(Number; Alpha; Beta)</paragraph> - <paragraph xml-lang="en-US" id="par_id2915138" role="paragraph" l10n="U" oldref="51"> + <paragraph xml-lang="en-US" id="hd_id2919949" role="heading" level="3" >Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id2915828" role="code">GAMMA.INV(Number; Alpha; Beta)</paragraph> + <paragraph xml-lang="en-US" id="par_id2915138" role="paragraph"> <emph>Number</emph> is the probability value for which the inverse Gamma distribution is to be calculated.</paragraph> - <paragraph xml-lang="en-US" id="par_id2912785" role="paragraph" l10n="U" oldref="52"> + <paragraph xml-lang="en-US" id="par_id2912785" role="paragraph"> <emph>Alpha</emph> is the parameter Alpha of the Gamma distribution.</paragraph> - <paragraph xml-lang="en-US" id="par_id2914561" role="paragraph" l10n="U" oldref="53"> + <paragraph xml-lang="en-US" id="par_id2914561" role="paragraph"> <emph>Beta</emph> is the parameter Beta of the Gamma distribution.</paragraph> - <paragraph xml-lang="en-US" id="hd_id2918734" role="heading" level="3" l10n="U" - oldref="54">Example</paragraph> - <paragraph xml-lang="en-US" id="par_id2913331" role="paragraph" l10n="U" oldref="55"> + <paragraph xml-lang="en-US" id="hd_id2918734" role="heading" level="3" >Example</paragraph> + <paragraph xml-lang="en-US" id="par_id2913331" role="paragraph"> <item type="input">=GAMMA.INV(0.8;1;1)</item> yields 1.61.</paragraph> </section> <section id="gammaln"> @@ -262,17 +244,14 @@ <bookmark_value>natural logarithm of Gamma function</bookmark_value> </bookmark><comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GAMMALN" id="bm_id3149511" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3154806" role="heading" level="2" l10n="U" - oldref="57">GAMMALN</paragraph> - <paragraph xml-lang="en-US" id="par_id3148572" role="paragraph" l10n="U" oldref="58"><ahelp hid="HID_FUNC_GAMMALN">Returns the natural logarithm of the Gamma function: G(x).</ahelp></paragraph> - <paragraph xml-lang="en-US" id="hd_id3152999" role="heading" level="3" l10n="U" - oldref="59">Syntax</paragraph> - <paragraph xml-lang="en-US" id="par_id3153112" role="code" l10n="U" oldref="60">GAMMALN(Number)</paragraph> - <paragraph xml-lang="en-US" id="par_id3154502" role="paragraph" l10n="U" oldref="61"> +<paragraph xml-lang="en-US" id="hd_id3154806" role="heading" level="2" >GAMMALN</paragraph> + <paragraph xml-lang="en-US" id="par_id3148572" role="paragraph"><ahelp hid="HID_FUNC_GAMMALN">Returns the natural logarithm of the Gamma function: G(x).</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3152999" role="heading" level="3" >Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3153112" role="code">GAMMALN(Number)</paragraph> + <paragraph xml-lang="en-US" id="par_id3154502" role="paragraph"> <emph>Number</emph> is the value for which the natural logarithm of the Gamma function is to be calculated.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3153568" role="heading" level="3" l10n="U" - oldref="62">Example</paragraph> - <paragraph xml-lang="en-US" id="par_id3153730" role="paragraph" l10n="U" oldref="63"> + <paragraph xml-lang="en-US" id="hd_id3153568" role="heading" level="3" >Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3153730" role="paragraph"> <item type="input">=GAMMALN(2)</item> yields 0.</paragraph> </section> <section id="gammalnprecise"> @@ -280,41 +259,35 @@ <bookmark_value>natural logarithm of Gamma function</bookmark_value> </bookmark><comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GAMMALN_MS" id="bm_id2919511" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id2914806" role="heading" level="2" l10n="U" - oldref="57">GAMMALN.PRECISE</paragraph> - <paragraph xml-lang="en-US" id="par_id2918572" role="paragraph" l10n="U" oldref="58"><ahelp hid="HID_FUNC_GAMMALN_MS">Returns the natural logarithm of the Gamma function: G(x).</ahelp></paragraph> - <paragraph xml-lang="en-US" id="hd_id2912999" role="heading" level="3" l10n="U" - oldref="59">Syntax</paragraph> - <paragraph xml-lang="en-US" id="par_id2913112" role="code" l10n="U" oldref="60">GAMMALN.PRECISE(Number)</paragraph> - <paragraph xml-lang="en-US" id="par_id2914502" role="paragraph" l10n="U" oldref="61"> +<paragraph xml-lang="en-US" id="hd_id2914806" role="heading" level="2" >GAMMALN.PRECISE</paragraph> + <paragraph xml-lang="en-US" id="par_id2918572" role="paragraph"><ahelp hid="HID_FUNC_GAMMALN_MS">Returns the natural logarithm of the Gamma function: G(x).</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id2912999" role="heading" level="3" >Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id2913112" role="code">GAMMALN.PRECISE(Number)</paragraph> + <paragraph xml-lang="en-US" id="par_id2914502" role="paragraph"> <emph>Number</emph> is the value for which the natural logarithm of the Gamma function is to be calculated.</paragraph> - <paragraph xml-lang="en-US" id="hd_id2913568" role="heading" level="3" l10n="U" - oldref="62">Example</paragraph> - <paragraph xml-lang="en-US" id="par_id2913730" role="paragraph" l10n="U" oldref="63"> + <paragraph xml-lang="en-US" id="hd_id2913568" role="heading" level="3" >Example</paragraph> + <paragraph xml-lang="en-US" id="par_id2913730" role="paragraph"> <item type="input">=GAMMALN.PRECISE(2)</item> yields 0.</paragraph> </section> <section id="gammadist"> <bookmark xml-lang="en-US" branch="index" id="bm_id3150132"><bookmark_value>GAMMADIST function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GAMMAVERT" id="bm_id3154330" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3150132" role="heading" level="2" l10n="U" - oldref="65">GAMMADIST</paragraph> - <paragraph xml-lang="en-US" id="par_id3155931" role="paragraph" l10n="U" oldref="66"><ahelp hid="HID_FUNC_GAMMAVERT">Returns the values of a Gamma distribution.</ahelp></paragraph> - <paragraph xml-lang="en-US" id="par_id0119200903333675" role="paragraph" l10n="NEW">The inverse function is GAMMAINV.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3147373" role="heading" level="3" l10n="U" - oldref="67">Syntax</paragraph> - <paragraph xml-lang="en-US" id="par_id3155436" role="code" l10n="U" oldref="68">GAMMADIST(Number; Alpha; Beta; C)</paragraph> - <paragraph xml-lang="en-US" id="par_id3150571" role="paragraph" l10n="U" oldref="69"> +<paragraph xml-lang="en-US" id="hd_id3150132" role="heading" level="2" >GAMMADIST</paragraph> + <paragraph xml-lang="en-US" id="par_id3155931" role="paragraph"><ahelp hid="HID_FUNC_GAMMAVERT">Returns the values of a Gamma distribution.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="par_id0119200903333675" role="paragraph">The inverse function is GAMMAINV.</paragraph> + <paragraph xml-lang="en-US" id="hd_id3147373" role="heading" level="3" >Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3155436" role="code">GAMMADIST(Number; Alpha; Beta; C)</paragraph> + <paragraph xml-lang="en-US" id="par_id3150571" role="paragraph"> <emph>Number</emph> is the value for which the Gamma distribution is to be calculated.</paragraph> - <paragraph xml-lang="en-US" id="par_id3145295" role="paragraph" l10n="U" oldref="70"> + <paragraph xml-lang="en-US" id="par_id3145295" role="paragraph"> <emph>Alpha</emph> is the parameter Alpha of the Gamma distribution.</paragraph> - <paragraph xml-lang="en-US" id="par_id3151015" role="paragraph" l10n="U" oldref="71"> + <paragraph xml-lang="en-US" id="par_id3151015" role="paragraph"> <emph>Beta</emph> is the parameter Beta of the Gamma distribution</paragraph> - <paragraph xml-lang="en-US" id="par_id3157972" role="paragraph" l10n="CHG" oldref="72"> + <paragraph xml-lang="en-US" id="par_id3157972" role="paragraph"> <emph>C</emph> (optional) = 0 or False calculates the density function <emph>C</emph> = 1 or True calculates the distribution.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3149535" role="heading" level="3" l10n="U" - oldref="73">Example</paragraph> - <paragraph xml-lang="en-US" id="par_id3145354" role="paragraph" l10n="U" oldref="74"> + <paragraph xml-lang="en-US" id="hd_id3149535" role="heading" level="3" >Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3145354" role="paragraph"> <item type="input">=GAMMADIST(2;1;1;1)</item> yields 0.86.</paragraph> </section> <section id="gammadotdist"> @@ -340,20 +313,17 @@ <bookmark_value>normal distribution; standard</bookmark_value> </bookmark><comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GAUSS" id="bm_id3149388" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3150272" role="heading" level="2" l10n="U" - oldref="76">GAUSS</paragraph> - <paragraph xml-lang="en-US" id="par_id3149030" role="paragraph" l10n="U" oldref="77"><ahelp hid="HID_FUNC_GAUSS">Returns the standard normal cumulative distribution.</ahelp></paragraph> - <paragraph xml-lang="en-US" id="par_id2059694" role="paragraph" l10n="NEW">It is GAUSS(x)=NORMSDIST(x)-0.5</paragraph> - <paragraph xml-lang="en-US" id="hd_id3153551" role="heading" level="3" l10n="U" - oldref="78">Syntax</paragraph> - <paragraph xml-lang="en-US" id="par_id3155368" role="code" l10n="U" oldref="79">GAUSS(Number)</paragraph> - <paragraph xml-lang="en-US" id="par_id3153228" role="paragraph" l10n="CHG" oldref="80"> +<paragraph xml-lang="en-US" id="hd_id3150272" role="heading" level="2" >GAUSS</paragraph> + <paragraph xml-lang="en-US" id="par_id3149030" role="paragraph"><ahelp hid="HID_FUNC_GAUSS">Returns the standard normal cumulative distribution.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="par_id2059694" role="paragraph">It is GAUSS(x)=NORMSDIST(x)-0.5</paragraph> + <paragraph xml-lang="en-US" id="hd_id3153551" role="heading" level="3" >Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3155368" role="code">GAUSS(Number)</paragraph> + <paragraph xml-lang="en-US" id="par_id3153228" role="paragraph"> <emph>Number</emph> is the value for which the value of the standard normal distribution is to be calculated.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3150691" role="heading" level="3" l10n="U" - oldref="81">Example</paragraph> - <paragraph xml-lang="en-US" id="par_id3154867" role="paragraph" l10n="U" oldref="82"> + <paragraph xml-lang="en-US" id="hd_id3150691" role="heading" level="3" >Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3154867" role="paragraph"> <item type="input">=GAUSS(0.19)</item> = 0.08</paragraph> - <paragraph xml-lang="en-US" id="par_id3148594" role="paragraph" l10n="U" oldref="83"> + <paragraph xml-lang="en-US" id="par_id3148594" role="paragraph"> <item type="input">=GAUSS(0.0375)</item> = 0.01</paragraph> </section> <section id="geomean"> @@ -361,17 +331,14 @@ <bookmark_value>means;geometric</bookmark_value> </bookmark><comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GEOMITTEL" id="bm_id3149777" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3148425" role="heading" level="2" l10n="U" - oldref="85">GEOMEAN</paragraph> - <paragraph xml-lang="en-US" id="par_id3156257" role="paragraph" l10n="U" oldref="86"><ahelp hid="HID_FUNC_GEOMITTEL">Returns the geometric mean of a sample.</ahelp></paragraph> - <paragraph xml-lang="en-US" id="hd_id3147167" role="heading" level="3" l10n="U" - oldref="87">Syntax</paragraph> - <paragraph xml-lang="en-US" id="par_id3153720" role="code" l10n="U" oldref="88">GEOMEAN(Number1; Number2; ...Number30)</paragraph> - <paragraph xml-lang="en-US" id="par_id3152585" role="paragraph" l10n="CHG" oldref="89"> +<paragraph xml-lang="en-US" id="hd_id3148425" role="heading" level="2" >GEOMEAN</paragraph> + <paragraph xml-lang="en-US" id="par_id3156257" role="paragraph"><ahelp hid="HID_FUNC_GEOMITTEL">Returns the geometric mean of a sample.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3147167" role="heading" level="3" >Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3153720" role="code">GEOMEAN(Number1; Number2; ...Number30)</paragraph> + <paragraph xml-lang="en-US" id="par_id3152585" role="paragraph"> <emph>Number1, Number2,...Number30</emph> are numeric arguments or ranges that represent a random sample.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3146146" role="heading" level="3" l10n="U" - oldref="90">Example</paragraph> - <paragraph xml-lang="en-US" id="par_id3149819" role="paragraph" l10n="U" oldref="92"> + <paragraph xml-lang="en-US" id="hd_id3146146" role="heading" level="3" >Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3149819" role="paragraph"> <item type="input">=GEOMEAN(23;46;69)</item> = 41.79. The geometric mean value of this random sample is therefore 41.79.</paragraph> </section> <section id="trimmean"> @@ -379,69 +346,61 @@ <bookmark_value>means;of data set without margin data</bookmark_value> </bookmark><comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GESTUTZTMITTEL" id="bm_id3145081" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3152966" role="heading" level="2" l10n="U" - oldref="94">TRIMMEAN</paragraph> - <paragraph xml-lang="en-US" id="par_id3149716" role="paragraph" l10n="U" oldref="95"><ahelp hid="HID_FUNC_GESTUTZTMITTEL">Returns the mean of a data set without the Alpha percent of data at the margins.</ahelp></paragraph> - <paragraph xml-lang="en-US" id="hd_id3149281" role="heading" level="3" l10n="U" - oldref="96">Syntax</paragraph> - <paragraph xml-lang="en-US" id="par_id3154821" role="code" l10n="U" oldref="97">TRIMMEAN(Data; Alpha)</paragraph> - <paragraph xml-lang="en-US" id="par_id3155834" role="paragraph" l10n="U" oldref="98"> +<paragraph xml-lang="en-US" id="hd_id3152966" role="heading" level="2" >TRIMMEAN</paragraph> + <paragraph xml-lang="en-US" id="par_id3149716" role="paragraph"><ahelp hid="HID_FUNC_GESTUTZTMITTEL">Returns the mean of a data set without the Alpha percent of data at the margins.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3149281" role="heading" level="3" >Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3154821" role="code">TRIMMEAN(Data; Alpha)</paragraph> + <paragraph xml-lang="en-US" id="par_id3155834" role="paragraph"> <emph>Data</emph> is the array of data in the sample.</paragraph> - <paragraph xml-lang="en-US" id="par_id3156304" role="paragraph" l10n="U" oldref="99"> + <paragraph xml-lang="en-US" id="par_id3156304" role="paragraph"> <emph>Alpha</emph> is the percentage of the marginal data that will not be taken into consideration.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3151180" role="heading" level="3" l10n="U" - oldref="100">Example</paragraph> - <paragraph xml-lang="en-US" id="par_id3156130" role="paragraph" l10n="U" oldref="101"> + <paragraph xml-lang="en-US" id="hd_id3151180" role="heading" level="3" >Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3156130" role="paragraph"> <item type="input">=TRIMMEAN(A1:A50; 0.1)</item> calculates the mean value of numbers in A1:A50, without taking into consideration the 5 percent of the values representing the highest values and the 5 percent of the values representing the lowest ones. The percentage numbers refer to the amount of the untrimmed mean value, not to the number of summands.</paragraph> </section> <section id="ztest"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153216"><bookmark_value>ZTEST function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GTEST" id="bm_id3147569" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3153216" role="heading" level="2" l10n="U" - oldref="103">ZTEST</paragraph> - <paragraph xml-lang="en-US" id="par_id3150758" role="paragraph" l10n="CHG" oldref="104"><ahelp hid="HID_FUNC_GTEST">Calculates the probability of observing a z-statistic greater than the one computed based on a sample.</ahelp></paragraph> - <paragraph xml-lang="en-US" id="hd_id3150872" role="heading" level="3" l10n="U" - oldref="105">Syntax</paragraph> - <paragraph xml-lang="en-US" id="par_id3153274" role="code" l10n="CHG" oldref="106">ZTEST(Data; mu; Sigma)</paragraph> - <paragraph xml-lang="en-US" id="par_id3156109" role="paragraph" l10n="CHG" oldref="107"> +<paragraph xml-lang="en-US" id="hd_id3153216" role="heading" level="2" >ZTEST</paragraph> + <paragraph xml-lang="en-US" id="par_id3150758" role="paragraph"><ahelp hid="HID_FUNC_GTEST">Calculates the probability of observing a z-statistic greater than the one computed based on a sample.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3150872" role="heading" level="3" >Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3153274" role="code">ZTEST(Data; mu; Sigma)</paragraph> + <paragraph xml-lang="en-US" id="par_id3156109" role="paragraph"> <emph>Data</emph> is the given sample, drawn from a normally distributed population.</paragraph> - <paragraph xml-lang="en-US" id="par_id3149977" role="paragraph" l10n="CHG" oldref="108"> + <paragraph xml-lang="en-US" id="par_id3149977" role="paragraph"> <emph>mu</emph> is the known mean of the population.</paragraph> - <paragraph xml-lang="en-US" id="par_id3154740" role="paragraph" l10n="CHG" oldref="109"> + <paragraph xml-lang="en-US" id="par_id3154740" role="paragraph"> <emph>Sigma</emph> (optional) is the known standard deviation of the population. If omitted, the standard deviation of the given sample is used.</paragraph> - <paragraph xml-lang="en-US" id="par_id0305200911372999" role="paragraph" l10n="NEW">See also the <link href="http://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_ZTEST_function">Wiki page</link>.</paragraph> + <paragraph xml-lang="en-US" id="par_id0305200911372999" role="paragraph">See also the <link href="http://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_ZTEST_function">Wiki page</link>.</paragraph> </section> <section id="zdottest"> <bookmark xml-lang="en-US" branch="index" id="bm_id2953216"><bookmark_value>Z.TEST function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_Z_TEST_MS" id="bm_id2947569" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id2953216" role="heading" level="2" l10n="U" oldref="103">Z.TEST</paragraph> -<paragraph xml-lang="en-US" id="par_id2950758" role="paragraph" l10n="CHG" oldref="104"><ahelp hid="HID_FUNC_Z_TEST_MS">Calculates the probability of observing a z-statistic greater than the one computed based on a sample.</ahelp></paragraph> -<paragraph xml-lang="en-US" id="hd_id2950872" role="heading" level="3" l10n="U" oldref="105">Syntax</paragraph> -<paragraph xml-lang="en-US" id="par_id2953274" role="code" l10n="CHG" oldref="106">Z.TEST(Data; mu; Sigma)</paragraph> -<paragraph xml-lang="en-US" id="par_id2956109" role="paragraph" l10n="CHG" oldref="107"><emph>Data</emph> is the given sample, drawn from a normally distributed population.</paragraph> -<paragraph xml-lang="en-US" id="par_id2949977" role="paragraph" l10n="CHG" oldref="108"><emph>mu</emph> is the known mean of the population.</paragraph> -<paragraph xml-lang="en-US" id="par_id2954740" role="paragraph" l10n="CHG" oldref="109"><emph>Sigma</emph> (optional) is the known standard deviation of the population. If omitted, the standard deviation of the given sample is used.</paragraph> -<paragraph xml-lang="en-US" id="hd_id2949539" role="heading" level="3" l10n="U" oldref="58">Example</paragraph> -<paragraph xml-lang="en-US" id="par_id2948770" role="paragraph" l10n="U" oldref="59"><item type="input">=Z.TEST(A2:A20; 9; 2)</item> returns the result of a z-test on a sample A2:A20 drawn from a population with known mean 9 and known standard deviation 2.</paragraph> +<paragraph xml-lang="en-US" id="hd_id2953216" role="heading" level="2">Z.TEST</paragraph> +<paragraph xml-lang="en-US" id="par_id2950758" role="paragraph"><ahelp hid="HID_FUNC_Z_TEST_MS">Calculates the probability of observing a z-statistic greater than the one computed based on a sample.</ahelp></paragraph> +<paragraph xml-lang="en-US" id="hd_id2950872" role="heading" level="3">Syntax</paragraph> +<paragraph xml-lang="en-US" id="par_id2953274" role="code">Z.TEST(Data; mu; Sigma)</paragraph> +<paragraph xml-lang="en-US" id="par_id2956109" role="paragraph"><emph>Data</emph> is the given sample, drawn from a normally distributed population.</paragraph> +<paragraph xml-lang="en-US" id="par_id2949977" role="paragraph"><emph>mu</emph> is the known mean of the population.</paragraph> +<paragraph xml-lang="en-US" id="par_id2954740" role="paragraph"><emph>Sigma</emph> (optional) is the known standard deviation of the population. If omitted, the standard deviation of the given sample is used.</paragraph> +<paragraph xml-lang="en-US" id="hd_id2949539" role="heading" level="3">Example</paragraph> +<paragraph xml-lang="en-US" id="par_id2948770" role="paragraph"><item type="input">=Z.TEST(A2:A20; 9; 2)</item> returns the result of a z-test on a sample A2:A20 drawn from a population with known mean 9 and known standard deviation 2.</paragraph> </section> <section id="harmean"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153623"><bookmark_value>HARMEAN function</bookmark_value> <bookmark_value>means;harmonic</bookmark_value> </bookmark><comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_HARMITTEL" id="bm_id3154052" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3153623" role="heading" level="2" l10n="U" - oldref="113">HARMEAN</paragraph> - <paragraph xml-lang="en-US" id="par_id3155102" role="paragraph" l10n="U" oldref="114"><ahelp hid="HID_FUNC_HARMITTEL">Returns the harmonic mean of a data set.</ahelp></paragraph> - <paragraph xml-lang="en-US" id="hd_id3146900" role="heading" level="3" l10n="U" - oldref="115">Syntax</paragraph> - <paragraph xml-lang="en-US" id="par_id3149287" role="code" l10n="U" oldref="116">HARMEAN(Number1; Number2; ...Number30)</paragraph> - <paragraph xml-lang="en-US" id="par_id3154303" role="paragraph" l10n="CHG" oldref="117"> +<paragraph xml-lang="en-US" id="hd_id3153623" role="heading" level="2" >HARMEAN</paragraph> + <paragraph xml-lang="en-US" id="par_id3155102" role="paragraph"><ahelp hid="HID_FUNC_HARMITTEL">Returns the harmonic mean of a data set.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3146900" role="heading" level="3" >Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3149287" role="code">HARMEAN(Number1; Number2; ...Number30)</paragraph> + <paragraph xml-lang="en-US" id="par_id3154303" role="paragraph"> <emph>Number1,Number2,...Number30</emph> are up to 30 values or ranges, that can be used to calculate the harmonic mean.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3159179" role="heading" level="3" l10n="U" - oldref="118">Example</paragraph> - <paragraph xml-lang="en-US" id="par_id3146093" role="paragraph" l10n="U" oldref="120"> + <paragraph xml-lang="en-US" id="hd_id3159179" role="heading" level="3" >Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3146093" role="paragraph"> <item type="input">=HARMEAN(23;46;69)</item> = 37.64. The harmonic mean of this random sample is thus 37.64</paragraph> </section> <section id="hypgeomdist"> @@ -449,23 +408,20 @@ <bookmark_value>sampling without replacement</bookmark_value> </bookmark><comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_HYPGEOMVERT" id="bm_id3153910" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3152801" role="heading" level="2" l10n="U" - oldref="122">HYPGEOMDIST</paragraph> - <paragraph xml-lang="en-US" id="par_id3159341" role="paragraph" l10n="U" oldref="123"><ahelp hid="HID_FUNC_HYPGEOMVERT">Returns the hypergeometric distribution.</ahelp></paragraph> - <paragraph xml-lang="en-US" id="hd_id3154697" role="heading" level="3" l10n="U" - oldref="124">Syntax</paragraph> - <paragraph xml-lang="en-US" id="par_id3155388" role="code" l10n="U" oldref="125">HYPGEOMDIST(X; NSample; Successes; NPopulation)</paragraph> - <paragraph xml-lang="en-US" id="par_id3154933" role="paragraph" l10n="U" oldref="126"> +<paragraph xml-lang="en-US" id="hd_id3152801" role="heading" level="2" >HYPGEOMDIST</paragraph> + <paragraph xml-lang="en-US" id="par_id3159341" role="paragraph"><ahelp hid="HID_FUNC_HYPGEOMVERT">Returns the hypergeometric distribution.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3154697" role="heading" level="3" >Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3155388" role="code">HYPGEOMDIST(X; NSample; Successes; NPopulation)</paragraph> + <paragraph xml-lang="en-US" id="par_id3154933" role="paragraph"> <emph>X</emph> is the number of results achieved in the random sample.</paragraph> - <paragraph xml-lang="en-US" id="par_id3153106" role="paragraph" l10n="U" oldref="127"> + <paragraph xml-lang="en-US" id="par_id3153106" role="paragraph"> <emph>NSample</emph> is the size of the random sample.</paragraph> - <paragraph xml-lang="en-US" id="par_id3146992" role="paragraph" l10n="U" oldref="128"> + <paragraph xml-lang="en-US" id="par_id3146992" role="paragraph"> <emph>Successes</emph> is the number of possible results in the total population.</paragraph> - <paragraph xml-lang="en-US" id="par_id3148826" role="paragraph" l10n="U" oldref="129"> + <paragraph xml-lang="en-US" id="par_id3148826" role="paragraph"> <emph>NPopulation </emph>is the size of the total population.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3150529" role="heading" level="3" l10n="U" - oldref="130">Example</paragraph> - <paragraph xml-lang="en-US" id="par_id3154904" role="paragraph" l10n="U" oldref="131"> + <paragraph xml-lang="en-US" id="hd_id3150529" role="heading" level="3" >Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3154904" role="paragraph"> <item type="input">=HYPGEOMDIST(2;2;90;100)</item> yields 0.81. If 90 out of 100 pieces of buttered toast fall from the table and hit the floor with the buttered side first, then if 2 pieces of buttered toast are dropped from the table, the probability is 81%, that both will strike buttered side first.</paragraph> </section> <section id="hypgeomdotdist"> @@ -475,18 +431,18 @@ </bookmark> <comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_HYP_GEOM_DIST_MS" id="bm_id2953910" localize="false"/> - <paragraph xml-lang="en-US" id="hd_id2952801" role="heading" level="2" l10n="U" oldref="122">HYPGEOM.DIST</paragraph> - <paragraph xml-lang="en-US" id="par_id2959341" role="paragraph" l10n="U" oldref="123"><ahelp hid="HID_FUNC_HYP_GEOM_DIST_MS">Returns the hypergeometric distribution.</ahelp></paragraph> - <paragraph xml-lang="en-US" id="hd_id2954697" role="heading" level="3" l10n="U" oldref="124">Syntax</paragraph> - <paragraph xml-lang="en-US" id="par_id2955388" role="code" l10n="U" oldref="125">HYPGEOM.DIST(X; NSample; Successes; NPopulation; Cumulative)</paragraph> - <paragraph xml-lang="en-US" id="par_id2954933" role="paragraph" l10n="U" oldref="126"><emph>X</emph> is the number of results achieved in the random sample.</paragraph> - <paragraph xml-lang="en-US" id="par_id2953106" role="paragraph" l10n="U" oldref="127"><emph>NSample</emph> is the size of the random sample.</paragraph> - <paragraph xml-lang="en-US" id="par_id2946992" role="paragraph" l10n="U" oldref="128"><emph>Successes</emph> is the number of possible results in the total population.</paragraph> - <paragraph xml-lang="en-US" id="par_id2948826" role="paragraph" l10n="U" oldref="129"><emph>NPopulation </emph>is the size of the total population.</paragraph> - <paragraph xml-lang="en-US" id="par_id2948827" role="paragraph" l10n="U" oldref="129"><emph>Cumulative </emph>: 0 or False calculates the probability density function. Other values or True calculates the cumulative distribution function.</paragraph> - <paragraph xml-lang="en-US" id="hd_id2950529" role="heading" level="3" l10n="U" oldref="130">Examples</paragraph> - <paragraph xml-lang="en-US" id="par_id2954904" role="paragraph" l10n="U" oldref="131"><item type="input">=HYPGEOM.DIST(2;2;90;100;0)</item> yields 0.8090909091. If 90 out of 100 pieces of buttered toast fall from the table and hit the floor with the buttered side first, then if 2 pieces of buttered toast are dropped from the table, the probability is 81%, that both will strike buttered side first.</paragraph> - <paragraph xml-lang="en-US" id="par_id2954905" role="paragraph" l10n="U" oldref="131"><item type="input">=HYPGEOM.DIST(2;2;90;100;1)</item> yields 1.</paragraph> + <paragraph xml-lang="en-US" id="hd_id2952801" role="heading" level="2">HYPGEOM.DIST</paragraph> + <paragraph xml-lang="en-US" id="par_id2959341" role="paragraph"><ahelp hid="HID_FUNC_HYP_GEOM_DIST_MS">Returns the hypergeometric distribution.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id2954697" role="heading" level="3">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id2955388" role="code">HYPGEOM.DIST(X; NSample; Successes; NPopulation; Cumulative)</paragraph> + <paragraph xml-lang="en-US" id="par_id2954933" role="paragraph"><emph>X</emph> is the number of results achieved in the random sample.</paragraph> + <paragraph xml-lang="en-US" id="par_id2953106" role="paragraph"><emph>NSample</emph> is the size of the random sample.</paragraph> + <paragraph xml-lang="en-US" id="par_id2946992" role="paragraph"><emph>Successes</emph> is the number of possible results in the total population.</paragraph> + <paragraph xml-lang="en-US" id="par_id2948826" role="paragraph"><emph>NPopulation </emph>is the size of the total population.</paragraph> + <paragraph xml-lang="en-US" id="par_id2948827" role="paragraph"><emph>Cumulative </emph>: 0 or False calculates the probability density function. Other values or True calculates the cumulative distribution function.</paragraph> + <paragraph xml-lang="en-US" id="hd_id2950529" role="heading" level="3">Examples</paragraph> + <paragraph xml-lang="en-US" id="par_id2954904" role="paragraph"><item type="input">=HYPGEOM.DIST(2;2;90;100;0)</item> yields 0.8090909091. If 90 out of 100 pieces of buttered toast fall from the table and hit the floor with the buttered side first, then if 2 pieces of buttered toast are dropped from the table, the probability is 81%, that both will strike buttered side first.</paragraph> + <paragraph xml-lang="en-US" id="par_id2954905" role="paragraph"><item type="input">=HYPGEOM.DIST(2;2;90;100;1)</item> yields 1.</paragraph> </section> </sort> <section id="relatedtopics"> |