summaryrefslogtreecommitdiff
path: root/helpcontent2/source/text/scalc/01/04060182.xhp
diff options
context:
space:
mode:
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060182.xhp')
-rw-r--r--[-rwxr-xr-x]helpcontent2/source/text/scalc/01/04060182.xhp30
1 files changed, 15 insertions, 15 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060182.xhp b/helpcontent2/source/text/scalc/01/04060182.xhp
index c895f6e288..ea6384c170 100755..100644
--- a/helpcontent2/source/text/scalc/01/04060182.xhp
+++ b/helpcontent2/source/text/scalc/01/04060182.xhp
@@ -45,7 +45,7 @@
<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"/>
+<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>
@@ -63,7 +63,7 @@
<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"/>
+<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>
@@ -81,7 +81,7 @@
<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"/>
+<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>
@@ -98,7 +98,7 @@
<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"/>
+<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>
@@ -117,7 +117,7 @@
<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"/>
+<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>
@@ -136,7 +136,7 @@
<item type="input">=FDIST(0.8;8;12)</item> yields 0.61.</paragraph>
</section>
<section id="gamma">
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_GAMMA" id="bm_id0119200903221254" localize="false"/>
+<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>
@@ -148,7 +148,7 @@
<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"/>
+<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>
@@ -170,7 +170,7 @@
<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"/>
+<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>
@@ -187,7 +187,7 @@
<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"/>
+<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>
@@ -212,7 +212,7 @@
<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"/>
+<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>
@@ -233,7 +233,7 @@
<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"/>
+<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>
@@ -251,7 +251,7 @@
<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"/>
+<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>
@@ -270,7 +270,7 @@
<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"/>
+<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>
@@ -289,7 +289,7 @@
<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"/>
+<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>
@@ -307,7 +307,7 @@
<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"/>
+<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>