diff options
| author | Vladimir Glazounov <vg@openoffice.org> | 2008-11-26 15:57:11 +0000 |
|---|---|---|
| committer | Vladimir Glazounov <vg@openoffice.org> | 2008-11-26 15:57:11 +0000 |
| commit | 5ccd1d319b38120437fe69a3b6884e00cf22ee4e (patch) | |
| tree | 3fbc437a38c99a98250c39533659836eeae1c4c9 /helpcontent2/source/text/scalc/01/04060182.xhp | |
| parent | f01f267f5bf6a19106771b39ad3253913efb0001 (diff) | |
CWS-TOOLING: integrate CWS hcshared19
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060182.xhp')
| -rwxr-xr-x | helpcontent2/source/text/scalc/01/04060182.xhp | 67 |
1 files changed, 42 insertions, 25 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060182.xhp b/helpcontent2/source/text/scalc/01/04060182.xhp index d2f93c4c3c..57aa859d47 100755 --- a/helpcontent2/source/text/scalc/01/04060182.xhp +++ b/helpcontent2/source/text/scalc/01/04060182.xhp @@ -1,9 +1,8 @@ <?xml version="1.0" encoding="UTF-8"?> - - - +<helpdocument version="1.0"> + <!-- - *********************************************************************** +*********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * @@ -12,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: 04060182.xhp,v $ - * $Revision: 1.8 $ + * $Revision: 1.8.4.1 $ * * This file is part of OpenOffice.org. * @@ -33,11 +32,10 @@ * ************************************************************************ --> - - - <helpdocument version="1.0"> + + <meta> -<topic id="textscalc0104060182xml" indexer="include" status="PUBLISH"> +<topic id="textscalc0104060182xml" indexer="include"> <title id="tit" xml-lang="en-US">Statistical Functions Part Two</title> <filename>/text/scalc/01/04060182.xhp</filename> </topic> @@ -45,11 +43,13 @@ <body> <paragraph role="heading" id="hd_id3154372" xml-lang="en-US" 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> </variable></paragraph> -<sort order="asc"><section id="finv"> +<sort order="asc"> +<section id="finv"> <bookmark xml-lang="en-US" branch="index" id="bm_id3145388"><bookmark_value>FINV function</bookmark_value> <bookmark_value>inverse F probability distribution</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_FINV" id="bm_id3146113" localize="false"/><paragraph role="heading" id="hd_id3145388" xml-lang="en-US" level="2" l10n="U" oldref="2">FINV</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_FINV" id="bm_id3146113" localize="false"/> +<paragraph role="heading" id="hd_id3145388" xml-lang="en-US" level="2" l10n="U" oldref="2">FINV</paragraph> <paragraph role="paragraph" id="par_id3155089" xml-lang="en-US" 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 role="heading" id="hd_id3153816" xml-lang="en-US" level="3" l10n="U" oldref="4">Syntax</paragraph> <paragraph role="code" id="par_id3153068" xml-lang="en-US" l10n="U" oldref="5">FINV(Number; DegreesFreedom1; DegreesFreedom2)</paragraph> @@ -66,7 +66,8 @@ <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/HID_FUNC_FISHER" id="bm_id3146782" localize="false"/><paragraph role="heading" id="hd_id3150888" xml-lang="en-US" level="2" l10n="U" oldref="12">FISHER</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_FISHER" id="bm_id3146782" localize="false"/> +<paragraph role="heading" id="hd_id3150888" xml-lang="en-US" level="2" l10n="U" oldref="12">FISHER</paragraph> <paragraph role="paragraph" id="par_id3155384" xml-lang="en-US" 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 role="heading" id="hd_id3149898" xml-lang="en-US" level="3" l10n="U" oldref="14">Syntax</paragraph> <paragraph role="code" id="par_id3143220" xml-lang="en-US" l10n="U" oldref="15">FISHER(Number)</paragraph> @@ -80,7 +81,8 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3155758"><bookmark_value>FISHERINV function</bookmark_value> <bookmark_value>inverse of Fisher transformation</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_FISHERINV" id="bm_id3149317" localize="false"/><paragraph role="heading" id="hd_id3155758" xml-lang="en-US" level="2" l10n="U" oldref="20">FISHERINV</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_FISHERINV" id="bm_id3149317" localize="false"/> +<paragraph role="heading" id="hd_id3155758" xml-lang="en-US" level="2" l10n="U" oldref="20">FISHERINV</paragraph> <paragraph role="paragraph" id="par_id3154734" xml-lang="en-US" 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 role="heading" id="hd_id3155755" xml-lang="en-US" level="3" l10n="U" oldref="22">Syntax</paragraph> <paragraph role="code" id="par_id3146108" xml-lang="en-US" l10n="U" oldref="23">FISHERINV(Number)</paragraph> @@ -93,7 +95,8 @@ <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/HID_FUNC_FTEST" id="bm_id3159263" localize="false"/><paragraph role="heading" id="hd_id3151390" xml-lang="en-US" level="2" l10n="U" oldref="28">FTEST</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_FTEST" id="bm_id3159263" localize="false"/> +<paragraph role="heading" id="hd_id3151390" xml-lang="en-US" level="2" l10n="U" oldref="28">FTEST</paragraph> <paragraph role="paragraph" id="par_id3150534" xml-lang="en-US" l10n="U" oldref="29"><ahelp hid="HID_FUNC_FTEST">Returns the result of an F test.</ahelp></paragraph> <paragraph role="heading" id="hd_id3166466" xml-lang="en-US" level="3" l10n="U" oldref="30">Syntax</paragraph> <paragraph role="code" id="par_id3153024" xml-lang="en-US" l10n="U" oldref="31">FTEST(Data1; Data2)</paragraph> @@ -108,7 +111,8 @@ <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/HID_FUNC_FVERT" id="bm_id3149722" localize="false"/><paragraph role="heading" id="hd_id3150372" xml-lang="en-US" level="2" l10n="U" oldref="37">FDIST</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_FVERT" id="bm_id3149722" localize="false"/> +<paragraph role="heading" id="hd_id3150372" xml-lang="en-US" level="2" l10n="U" oldref="37">FDIST</paragraph> <paragraph role="paragraph" id="par_id3152981" xml-lang="en-US" l10n="U" oldref="38"><ahelp hid="HID_FUNC_FVERT">Calculates the values of an F distribution.</ahelp></paragraph> <paragraph role="heading" id="hd_id3150484" xml-lang="en-US" level="3" l10n="U" oldref="39">Syntax</paragraph> <paragraph role="code" id="par_id3145826" xml-lang="en-US" l10n="U" oldref="40">FDIST(Number; DegreesFreedom1; DegreesFreedom2)</paragraph> @@ -125,7 +129,8 @@ <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/HID_FUNC_GAMMAINV" id="bm_id3149249" localize="false"/><paragraph role="heading" id="hd_id3154841" xml-lang="en-US" level="2" l10n="U" oldref="47">GAMMAINV</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_GAMMAINV" id="bm_id3149249" localize="false"/> +<paragraph role="heading" id="hd_id3154841" xml-lang="en-US" level="2" l10n="U" oldref="47">GAMMAINV</paragraph> <paragraph role="paragraph" id="par_id3153932" xml-lang="en-US" l10n="U" oldref="48"><ahelp hid="HID_FUNC_GAMMAINV">Returns the inverse of the Gamma cumulative distribution.</ahelp> This function allows you to search for variables with different distribution.</paragraph> <paragraph role="heading" id="hd_id3149949" xml-lang="en-US" level="3" l10n="U" oldref="49">Syntax</paragraph> <paragraph role="code" id="par_id3155828" xml-lang="en-US" l10n="U" oldref="50">GAMMAINV(Number; Alpha; Beta)</paragraph> @@ -143,7 +148,8 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3154806"><bookmark_value>GAMMALN function</bookmark_value> <bookmark_value>natural logarithm of Gamma function</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_GAMMALN" id="bm_id3149511" localize="false"/><paragraph role="heading" id="hd_id3154806" xml-lang="en-US" level="2" l10n="U" oldref="57">GAMMALN</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_GAMMALN" id="bm_id3149511" localize="false"/> +<paragraph role="heading" id="hd_id3154806" xml-lang="en-US" level="2" l10n="U" oldref="57">GAMMALN</paragraph> <paragraph role="paragraph" id="par_id3148572" xml-lang="en-US" l10n="U" oldref="58"><ahelp hid="HID_FUNC_GAMMALN">Returns the natural logarithm of the Gamma function: G(x).</ahelp></paragraph> <paragraph role="heading" id="hd_id3152999" xml-lang="en-US" level="3" l10n="U" oldref="59">Syntax</paragraph> <paragraph role="code" id="par_id3153112" xml-lang="en-US" l10n="U" oldref="60">GAMMALN(Number)</paragraph> @@ -156,7 +162,8 @@ <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/HID_FUNC_GAMMAVERT" id="bm_id3154330" localize="false"/><paragraph role="heading" id="hd_id3150132" xml-lang="en-US" level="2" l10n="U" oldref="65">GAMMADIST</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_GAMMAVERT" id="bm_id3154330" localize="false"/> +<paragraph role="heading" id="hd_id3150132" xml-lang="en-US" level="2" l10n="U" oldref="65">GAMMADIST</paragraph> <paragraph role="paragraph" id="par_id3155931" xml-lang="en-US" l10n="U" oldref="66"><ahelp hid="HID_FUNC_GAMMAVERT">Returns the values of a Gamma distribution.</ahelp></paragraph> <paragraph role="heading" id="hd_id3147373" xml-lang="en-US" level="3" l10n="U" oldref="67">Syntax</paragraph> <paragraph role="code" id="par_id3155436" xml-lang="en-US" l10n="U" oldref="68">GAMMADIST(Number; Alpha; Beta; C)</paragraph> @@ -176,7 +183,8 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3150272"><bookmark_value>GAUSS function</bookmark_value> <bookmark_value>normal distribution; standard</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_GAUSS" id="bm_id3149388" localize="false"/><paragraph role="heading" id="hd_id3150272" xml-lang="en-US" level="2" l10n="U" oldref="76">GAUSS</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_GAUSS" id="bm_id3149388" localize="false"/> +<paragraph role="heading" id="hd_id3150272" xml-lang="en-US" level="2" l10n="U" oldref="76">GAUSS</paragraph> <paragraph role="paragraph" id="par_id3149030" xml-lang="en-US" l10n="U" oldref="77"><ahelp hid="HID_FUNC_GAUSS">Returns the standard normal cumulative distribution.</ahelp></paragraph> <paragraph role="paragraph" id="par_id2059694" xml-lang="en-US" l10n="NEW">It is GAUSS(x)=NORMSDIST(x)-0.5</paragraph> <paragraph role="heading" id="hd_id3153551" xml-lang="en-US" level="3" l10n="U" oldref="78">Syntax</paragraph> @@ -193,7 +201,8 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3148425"><bookmark_value>GEOMEAN function</bookmark_value> <bookmark_value>means;geometric</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_GEOMITTEL" id="bm_id3149777" localize="false"/><paragraph role="heading" id="hd_id3148425" xml-lang="en-US" level="2" l10n="U" oldref="85">GEOMEAN</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_GEOMITTEL" id="bm_id3149777" localize="false"/> +<paragraph role="heading" id="hd_id3148425" xml-lang="en-US" level="2" l10n="U" oldref="85">GEOMEAN</paragraph> <paragraph role="paragraph" id="par_id3156257" xml-lang="en-US" l10n="U" oldref="86"><ahelp hid="HID_FUNC_GEOMITTEL">Returns the geometric mean of a sample.</ahelp></paragraph> <paragraph role="heading" id="hd_id3147167" xml-lang="en-US" level="3" l10n="U" oldref="87">Syntax</paragraph> <paragraph role="code" id="par_id3153720" xml-lang="en-US" l10n="U" oldref="88">GEOMEAN(Number1; Number2; ...Number30)</paragraph> @@ -207,7 +216,8 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3152966"><bookmark_value>TRIMMEAN function</bookmark_value> <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/HID_FUNC_GESTUTZTMITTEL" id="bm_id3145081" localize="false"/><paragraph role="heading" id="hd_id3152966" xml-lang="en-US" level="2" l10n="U" oldref="94">TRIMMEAN</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_GESTUTZTMITTEL" id="bm_id3145081" localize="false"/> +<paragraph role="heading" id="hd_id3152966" xml-lang="en-US" level="2" l10n="U" oldref="94">TRIMMEAN</paragraph> <paragraph role="paragraph" id="par_id3149716" xml-lang="en-US" 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 role="heading" id="hd_id3149281" xml-lang="en-US" level="3" l10n="U" oldref="96">Syntax</paragraph> <paragraph role="code" id="par_id3154821" xml-lang="en-US" l10n="U" oldref="97">TRIMMEAN(Data; Alpha)</paragraph> @@ -222,7 +232,8 @@ <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/HID_FUNC_GTEST" id="bm_id3147569" localize="false"/><paragraph role="heading" id="hd_id3153216" xml-lang="en-US" level="2" l10n="U" oldref="103">ZTEST</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_GTEST" id="bm_id3147569" localize="false"/> +<paragraph role="heading" id="hd_id3153216" xml-lang="en-US" level="2" l10n="U" oldref="103">ZTEST</paragraph> <paragraph role="paragraph" id="par_id3150758" xml-lang="en-US" l10n="U" oldref="104"><ahelp hid="HID_FUNC_GTEST">Returns the two-tailed P value of a z test with standard distribution.</ahelp></paragraph> <paragraph role="heading" id="hd_id3150872" xml-lang="en-US" level="3" l10n="U" oldref="105">Syntax</paragraph> <paragraph role="code" id="par_id3153274" xml-lang="en-US" l10n="U" oldref="106">ZTEST(Data; Number; Sigma)</paragraph> @@ -240,7 +251,8 @@ <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/HID_FUNC_HARMITTEL" id="bm_id3154052" localize="false"/><paragraph role="heading" id="hd_id3153623" xml-lang="en-US" level="2" l10n="U" oldref="113">HARMEAN</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_HARMITTEL" id="bm_id3154052" localize="false"/> +<paragraph role="heading" id="hd_id3153623" xml-lang="en-US" level="2" l10n="U" oldref="113">HARMEAN</paragraph> <paragraph role="paragraph" id="par_id3155102" xml-lang="en-US" l10n="U" oldref="114"><ahelp hid="HID_FUNC_HARMITTEL">Returns the harmonic mean of a data set.</ahelp></paragraph> <paragraph role="heading" id="hd_id3146900" xml-lang="en-US" level="3" l10n="U" oldref="115">Syntax</paragraph> <paragraph role="code" id="par_id3149287" xml-lang="en-US" l10n="U" oldref="116">HARMEAN(Number1; Number2; ...Number30)</paragraph> @@ -254,7 +266,8 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3152801"><bookmark_value>HYPGEOMDIST function</bookmark_value> <bookmark_value>sampling without replacement</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_HYPGEOMVERT" id="bm_id3153910" localize="false"/><paragraph role="heading" id="hd_id3152801" xml-lang="en-US" level="2" l10n="U" oldref="122">HYPGEOMDIST</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_HYPGEOMVERT" id="bm_id3153910" localize="false"/> +<paragraph role="heading" id="hd_id3152801" xml-lang="en-US" level="2" l10n="U" oldref="122">HYPGEOMDIST</paragraph> <paragraph role="paragraph" id="par_id3159341" xml-lang="en-US" l10n="U" oldref="123"><ahelp hid="HID_FUNC_HYPGEOMVERT">Returns the hypergeometric distribution.</ahelp></paragraph> <paragraph role="heading" id="hd_id3154697" xml-lang="en-US" level="3" l10n="U" oldref="124">Syntax</paragraph> <paragraph role="code" id="par_id3155388" xml-lang="en-US" l10n="U" oldref="125">HYPGEOMDIST(X; NSample; Successes; NPopulation)</paragraph> @@ -270,5 +283,9 @@ <paragraph role="paragraph" id="par_id3154904" xml-lang="en-US" l10n="U" oldref="131"> <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> -</sort></body> +</sort> +<section id="relatedtopics"> +<embed href="text/scalc/01/04060100.xhp#drking"/> +</section> +</body> </helpdocument> |