diff options
Diffstat (limited to 'source/text/scalc/01/04060182.xhp')
| -rw-r--r-- | source/text/scalc/01/04060182.xhp | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/source/text/scalc/01/04060182.xhp b/source/text/scalc/01/04060182.xhp index 7c7c25bb1d..8411b77664 100644 --- a/source/text/scalc/01/04060182.xhp +++ b/source/text/scalc/01/04060182.xhp @@ -58,6 +58,7 @@ <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">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> + <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> @@ -75,6 +76,7 @@ <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">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> + <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> @@ -135,6 +137,7 @@ <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">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> + <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> @@ -167,6 +170,7 @@ <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">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> + <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> @@ -184,6 +188,7 @@ <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">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> + <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> @@ -227,6 +232,7 @@ <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> + <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"> @@ -261,6 +267,7 @@ <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">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> + <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"> @@ -299,6 +306,7 @@ <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 identical 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; C)</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> @@ -380,6 +388,7 @@ <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">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> +<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> @@ -433,6 +442,7 @@ <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">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> + <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> |