diff options
Diffstat (limited to 'source/text/scalc/01/04060182.xhp')
| -rw-r--r-- | source/text/scalc/01/04060182.xhp | 50 |
1 files changed, 40 insertions, 10 deletions
diff --git a/source/text/scalc/01/04060182.xhp b/source/text/scalc/01/04060182.xhp index df82688b33..8591243a9f 100644 --- a/source/text/scalc/01/04060182.xhp +++ b/source/text/scalc/01/04060182.xhp @@ -56,7 +56,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_INV_LT" id="bm_id2946113" localize="false"/> <h2 id="hd_id2945388">F.INV</h2> <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> - <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <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> @@ -64,6 +63,10 @@ <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> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2945073" role="paragraph"><item type="input">=F.INV(0.5;5;10)</item> yields 0.9319331609.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873984703" localize="false"><literal>COM.MICROSOFT.F.INV</literal></paragraph> </section> <section id="fdotinvdotrt"> <bookmark xml-lang="en-US" branch="index" id="bm_id2845388"> @@ -74,7 +77,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_INV_RT" id="bm_id2846113" localize="false"/> <h2 id="hd_id2845388">F.INV.RT</h2> <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> - <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <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> @@ -82,6 +84,10 @@ <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> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <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> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341660873986703" localize="false"><literal>COM.MICROSOFT.F.INV.RT</literal></paragraph> </section> <section id="fisher"> <bookmark xml-lang="en-US" branch="index" id="bm_id3150888"><bookmark_value>FISHER function</bookmark_value> @@ -136,13 +142,16 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_TEST_MS" id="bm_id2959263" localize="false"/> <h2 id="hd_id2951390">F.TEST</h2> <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> - <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <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> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <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> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640273986703" localize="false"><literal>COM.MICROSOFT.F.TEST</literal></paragraph> </section> <section id="fdist"> <bookmark xml-lang="en-US" branch="index" id="bm_id3150372"><bookmark_value>FDIST function</bookmark_value> @@ -169,7 +178,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_DIST_LT" id="bm_id2949722" localize="false"/> <h2 id="hd_id2950372">F.DIST</h2> <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> - <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <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> @@ -179,6 +187,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <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> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873986707" localize="false"><literal>COM.MICROSOFT.F.DIST</literal></paragraph> </section> <section id="fdotdistdotrt"> <bookmark xml-lang="en-US" branch="index" id="bm_id2850372"> @@ -187,7 +199,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_DIST_RT" id="bm_id289722" localize="false"/> <h2 id="hd_id280372">F.DIST.RT</h2> <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> - <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <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> @@ -195,6 +206,10 @@ <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> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <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> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873986763" localize="false"><literal>COM.MICROSOFT.F.DIST.RT</literal></paragraph> </section> <section id="gamma"> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GAMMA" id="bm_id0119200903221254" localize="false"/> @@ -232,7 +247,6 @@ <h2 id="hd_id2914841">GAMMA.INV</h2> <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> - <embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <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"> @@ -244,6 +258,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2913331" role="paragraph"> <item type="input">=GAMMA.INV(0.8;1;1)</item> yields 1.61.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.3"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341630873986703" localize="false"><literal>COM.MICROSOFT.GAMMA.INV</literal></paragraph> </section> <section id="gammaln"> <bookmark xml-lang="en-US" branch="index" id="bm_id3154806"><bookmark_value>GAMMALN function</bookmark_value> @@ -267,7 +285,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GAMMALN_MS" id="bm_id2919511" localize="false"/> <h2 id="hd_id2914806">GAMMALN.PRECISE</h2> <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> - <embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id2913112" role="code">GAMMALN.PRECISE(Number)</paragraph> <paragraph xml-lang="en-US" id="par_id2914502" role="paragraph"> @@ -275,6 +292,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2913730" role="paragraph"> <item type="input">=GAMMALN.PRECISE(2)</item> yields 0.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.3"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id541640873986703" localize="false"><literal>COM.MICROSOFT.GAMMALN.PRECISE</literal></paragraph> </section> <section id="gammadist"> <bookmark xml-lang="en-US" branch="index" id="bm_id3150132"><bookmark_value>GAMMADIST function</bookmark_value> @@ -306,7 +327,6 @@ <paragraph id="par_id2406201422414690" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_GAMMADIST_MS">Returns the values of a Gamma distribution.</ahelp></paragraph> <paragraph id="par_id24061422414690" role="paragraph" xml-lang="en-US">The inverse function is GAMMAINV or GAMMA.INV.</paragraph> <paragraph id="par_id2406201422405814" role="paragraph" xml-lang="en-US">This function is similar to GAMMADIST and was introduced for interoperability with other office suites.</paragraph> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id240620142238475" role="code" xml-lang="en-US">GAMMA.DIST(Number; Alpha; Beta; Cumulative)</paragraph> <paragraph id="par_id2406201422385134" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the value for which the Gamma distribution is to be calculated.</paragraph> @@ -315,6 +335,10 @@ <paragraph id="par_id2406201422391058" role="paragraph" xml-lang="en-US"><emph>Cumulative</emph> = 0 or False calculates the probability density function; <emph>Cumulative</emph> = 1, True, or any other value calculates the cumulative distribution function.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id2406201422392251" role="paragraph" xml-lang="en-US"><item type="input">=GAMMA.DIST(2;1;1;1)</item> yields 0.86.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640273086703" localize="false"><literal>COM.MICROSOFT.GAMMA.DIST</literal></paragraph> </section> <section id="gauss"> <bookmark xml-lang="en-US" branch="index" id="bm_id3150272"><bookmark_value>GAUSS function</bookmark_value> @@ -390,7 +414,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_Z_TEST_MS" id="bm_id2947569" localize="false"/> <h2 id="hd_id2953216">Z.TEST</h2> <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> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <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> @@ -398,6 +421,10 @@ <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> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <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> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640873986700" localize="false"><literal>COM.MICROSOFT.Z.TEST</literal></paragraph> </section> <section id="harmean"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153623"><bookmark_value>HARMEAN function</bookmark_value> @@ -446,7 +473,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_HYP_GEOM_DIST_MS" id="bm_id2953910" localize="false"/> <h2 id="hd_id2952801">HYPGEOM.DIST</h2> <paragraph xml-lang="en-US" id="par_id2959341" role="paragraph"><ahelp hid="HID_FUNC_HYP_GEOM_DIST_MS">Returns the hypergeometric distribution.</ahelp></paragraph> - <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <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> @@ -457,6 +483,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <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> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873986704" localize="false"><literal>COM.MICROSOFT.HYPGEOM.DIST</literal></paragraph> </section> </sort> <section id="relatedtopics"> |