summaryrefslogtreecommitdiff
path: root/helpcontent2/source/text/scalc/01/04060183.xhp
diff options
context:
space:
mode:
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060183.xhp')
-rwxr-xr-xhelpcontent2/source/text/scalc/01/04060183.xhp300
1 files changed, 150 insertions, 150 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060183.xhp b/helpcontent2/source/text/scalc/01/04060183.xhp
index 82ea359db4..9a7fedef02 100755
--- a/helpcontent2/source/text/scalc/01/04060183.xhp
+++ b/helpcontent2/source/text/scalc/01/04060183.xhp
@@ -1,4 +1,4 @@
-<?xml version="1.0" encoding="UTF-8"?>
+<?xml version="1.0" encoding="UTF-8"?>
<!--***********************************************************************
*
* The Contents of this file are made available subject to the terms of
@@ -52,182 +52,182 @@
* Contributor(s): _______________________________________
*
*
- ************************************************************************-->
-
-<helpdocument version="1.0">
-<meta>
-<topic id="textscalc0104060183xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Statistical Functions Part Three</title>
-<filename>/text/scalc/01/04060183.xhp</filename>
-</topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-<lastedited date="2004-07-20T16:16:12">converted from old format - fpe</lastedited>
-</history>
-</meta>
-<body>
+ ************************************************************************-->
+
+<helpdocument version="1.0">
+<meta>
+<topic id="textscalc0104060183xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Statistical Functions Part Three</title>
+<filename>/text/scalc/01/04060183.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+<lastedited date="2004-07-20T16:16:12">converted from old format - fpe</lastedited>
+</history>
+</meta>
+<body>
<paragraph role="heading" id="hd_id3166425" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="kl"><link href="text/scalc/01/04060183.xhp" name="Statistical Functions Part Three">Statistical Functions Part Three</link>
</variable></paragraph>
-<sort order="asc">
+<sort order="asc">
<section id="large">
<bookmark xml-lang="en-US" branch="index" id="bm_id3149530"><bookmark_value>LARGE function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_KGROESSTE" id="bm_id3150883" localize="false"/>
-<paragraph role="heading" id="hd_id3149530" xml-lang="en-US" level="2" l10n="U" oldref="2">LARGE</paragraph>
-<paragraph role="paragraph" id="par_id3150518" xml-lang="en-US" l10n="U" oldref="3"><ahelp hid="HID_FUNC_KGROESSTE">Returns the Rank_c-th largest value in a data set.</ahelp></paragraph>
-<paragraph role="heading" id="hd_id3152990" xml-lang="en-US" level="3" l10n="U" oldref="4">Syntax</paragraph>
-<paragraph role="paragraph" id="par_id3154372" xml-lang="en-US" l10n="U" oldref="5">LARGE(Data; Rank_c)</paragraph>
-<paragraph role="paragraph" id="par_id3152986" xml-lang="en-US" l10n="U" oldref="6">
-<emph>Data</emph> is the cell range of data.</paragraph>
-<paragraph role="paragraph" id="par_id3156448" xml-lang="en-US" l10n="U" oldref="7">
-<emph>Rank_c</emph> is the ranking of the value.</paragraph>
-<paragraph role="heading" id="hd_id3152889" xml-lang="en-US" level="3" l10n="U" oldref="8">Example</paragraph>
-<paragraph role="paragraph" id="par_id3148702" xml-lang="en-US" l10n="U" oldref="9">=LARGE(A1:C50; 2) gives the second largest value in A1:C50.</paragraph>
-<embed href="text/shared/00/00000001.xhp#siehe"/>
-<paragraph role="paragraph" id="par_id3152900" xml-lang="en-US" l10n="U" oldref="10"><link href="text/scalc/01/04060183.xhp" name="SMALL">SMALL</link>, <link href="text/scalc/01/04060184.xhp" name="MAX">MAX</link>, <link href="text/scalc/01/04060184.xhp" name="MEDIAN">MEDIAN</link>, <link href="text/scalc/01/04060184.xhp" name="PERCENTILE">PERCENTILE</link>, <link href="text/scalc/01/04060184.xhp" name="PERCENTRANK">PERCENTRANK</link>, <link href="text/scalc/01/04060184.xhp" name="QUARTILE">QUARTILE</link></paragraph>
-</section>
+<bookmark xml-lang="en-US" branch="hid/HID_FUNC_KGROESSTE" id="bm_id3150883" localize="false"/>
+<paragraph role="heading" id="hd_id3149530" xml-lang="en-US" level="2" l10n="U" oldref="2">LARGE</paragraph>
+<paragraph role="paragraph" id="par_id3150518" xml-lang="en-US" l10n="U" oldref="3"><ahelp hid="HID_FUNC_KGROESSTE">Returns the Rank_c-th largest value in a data set.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3152990" xml-lang="en-US" level="3" l10n="U" oldref="4">Syntax</paragraph>
+<paragraph role="paragraph" id="par_id3154372" xml-lang="en-US" l10n="U" oldref="5">LARGE(Data; Rank_c)</paragraph>
+<paragraph role="paragraph" id="par_id3152986" xml-lang="en-US" l10n="U" oldref="6">
+<emph>Data</emph> is the cell range of data.</paragraph>
+<paragraph role="paragraph" id="par_id3156448" xml-lang="en-US" l10n="U" oldref="7">
+<emph>Rank_c</emph> is the ranking of the value.</paragraph>
+<paragraph role="heading" id="hd_id3152889" xml-lang="en-US" level="3" l10n="U" oldref="8">Example</paragraph>
+<paragraph role="paragraph" id="par_id3148702" xml-lang="en-US" l10n="U" oldref="9">=LARGE(A1:C50; 2) gives the second largest value in A1:C50.</paragraph>
+<embed href="text/shared/00/00000001.xhp#siehe"/>
+<paragraph role="paragraph" id="par_id3152900" xml-lang="en-US" l10n="U" oldref="10"><link href="text/scalc/01/04060183.xhp" name="SMALL">SMALL</link>, <link href="text/scalc/01/04060184.xhp" name="MAX">MAX</link>, <link href="text/scalc/01/04060184.xhp" name="MEDIAN">MEDIAN</link>, <link href="text/scalc/01/04060184.xhp" name="PERCENTILE">PERCENTILE</link>, <link href="text/scalc/01/04060184.xhp" name="PERCENTRANK">PERCENTRANK</link>, <link href="text/scalc/01/04060184.xhp" name="QUARTILE">QUARTILE</link></paragraph>
+</section>
<section id="small">
<bookmark xml-lang="en-US" branch="index" id="bm_id3154532"><bookmark_value>SMALL function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_KKLEINSTE" id="bm_id3148609" localize="false"/>
-<paragraph role="heading" id="hd_id3154532" xml-lang="en-US" level="2" l10n="U" oldref="11">SMALL</paragraph>
-<paragraph role="paragraph" id="par_id3157981" xml-lang="en-US" l10n="U" oldref="12"><ahelp hid="HID_FUNC_KKLEINSTE">Returns the Rank_c-th smallest value in a data set.</ahelp></paragraph>
-<paragraph role="heading" id="hd_id3154957" xml-lang="en-US" level="3" l10n="U" oldref="13">Syntax</paragraph>
-<paragraph role="paragraph" id="par_id3153974" xml-lang="en-US" l10n="U" oldref="14">SMALL(Data; Rank_c)</paragraph>
-<paragraph role="paragraph" id="par_id3154540" xml-lang="en-US" l10n="U" oldref="15">
-<emph>Data</emph> is the cell range of data.</paragraph>
-<paragraph role="paragraph" id="par_id3155094" xml-lang="en-US" l10n="U" oldref="16">
-<emph>Rank_c</emph> is the rank of the value.</paragraph>
-<paragraph role="heading" id="hd_id3153247" xml-lang="en-US" level="3" l10n="U" oldref="17">Example</paragraph>
-<paragraph role="paragraph" id="par_id3149897" xml-lang="en-US" l10n="U" oldref="18">=SMALL(A1:C50; 2) gives the second smallest value in A1:C50.</paragraph>
-<embed href="text/shared/00/00000001.xhp#siehe"/>
-<paragraph role="paragraph" id="par_id3149692" xml-lang="en-US" l10n="U" oldref="19"><link href="text/scalc/01/04060183.xhp" name="LARGE">LARGE</link>, <link href="text/scalc/01/04060184.xhp" name="MEDIAN">MEDIAN</link>, <link href="text/scalc/01/04060184.xhp" name="MIN">MIN</link>, <link href="text/scalc/01/04060184.xhp" name="PERCENTILE">PERCENTILE</link>, <link href="text/scalc/01/04060184.xhp" name="PERCENTRANK">PERCENTRANK</link>, <link href="text/scalc/01/04060184.xhp" name="QUARTILE">QUARTILE</link></paragraph>
-</section>
+<bookmark xml-lang="en-US" branch="hid/HID_FUNC_KKLEINSTE" id="bm_id3148609" localize="false"/>
+<paragraph role="heading" id="hd_id3154532" xml-lang="en-US" level="2" l10n="U" oldref="11">SMALL</paragraph>
+<paragraph role="paragraph" id="par_id3157981" xml-lang="en-US" l10n="U" oldref="12"><ahelp hid="HID_FUNC_KKLEINSTE">Returns the Rank_c-th smallest value in a data set.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3154957" xml-lang="en-US" level="3" l10n="U" oldref="13">Syntax</paragraph>
+<paragraph role="paragraph" id="par_id3153974" xml-lang="en-US" l10n="U" oldref="14">SMALL(Data; Rank_c)</paragraph>
+<paragraph role="paragraph" id="par_id3154540" xml-lang="en-US" l10n="U" oldref="15">
+<emph>Data</emph> is the cell range of data.</paragraph>
+<paragraph role="paragraph" id="par_id3155094" xml-lang="en-US" l10n="U" oldref="16">
+<emph>Rank_c</emph> is the rank of the value.</paragraph>
+<paragraph role="heading" id="hd_id3153247" xml-lang="en-US" level="3" l10n="U" oldref="17">Example</paragraph>
+<paragraph role="paragraph" id="par_id3149897" xml-lang="en-US" l10n="U" oldref="18">=SMALL(A1:C50; 2) gives the second smallest value in A1:C50.</paragraph>
+<embed href="text/shared/00/00000001.xhp#siehe"/>
+<paragraph role="paragraph" id="par_id3149692" xml-lang="en-US" l10n="U" oldref="19"><link href="text/scalc/01/04060183.xhp" name="LARGE">LARGE</link>, <link href="text/scalc/01/04060184.xhp" name="MEDIAN">MEDIAN</link>, <link href="text/scalc/01/04060184.xhp" name="MIN">MIN</link>, <link href="text/scalc/01/04060184.xhp" name="PERCENTILE">PERCENTILE</link>, <link href="text/scalc/01/04060184.xhp" name="PERCENTRANK">PERCENTRANK</link>, <link href="text/scalc/01/04060184.xhp" name="QUARTILE">QUARTILE</link></paragraph>
+</section>
<section id="confidence">
<bookmark xml-lang="en-US" branch="index" id="bm_id3153559"><bookmark_value>CONFIDENCE function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_KONFIDENZ" id="bm_id3153803" localize="false"/>
-<paragraph role="heading" id="hd_id3153559" xml-lang="en-US" level="2" l10n="U" oldref="20">CONFIDENCE</paragraph>
-<paragraph role="paragraph" id="par_id3153814" xml-lang="en-US" l10n="U" oldref="21"><ahelp hid="HID_FUNC_KONFIDENZ">Returns the (1-alpha) confidence interval for a normal distribution.</ahelp></paragraph>
-<paragraph role="heading" id="hd_id3149315" xml-lang="en-US" level="3" l10n="U" oldref="22">Syntax</paragraph>
-<paragraph role="paragraph" id="par_id3147501" xml-lang="en-US" l10n="U" oldref="23">CONFIDENCE(Alpha; STDEV; Size)</paragraph>
-<paragraph role="paragraph" id="par_id3149872" xml-lang="en-US" l10n="U" oldref="24">
-<emph>Alpha</emph> is the level of the confidence interval.</paragraph>
-<paragraph role="paragraph" id="par_id3145324" xml-lang="en-US" l10n="U" oldref="25">
-<emph>STDEV</emph> is the standard deviation for the total population.</paragraph>
-<paragraph role="paragraph" id="par_id3153075" xml-lang="en-US" l10n="U" oldref="26">
-<emph>Size</emph> is the size of the total population.</paragraph>
-<paragraph role="heading" id="hd_id3150435" xml-lang="en-US" level="3" l10n="U" oldref="27">Example</paragraph>
-<paragraph role="paragraph" id="par_id3153335" xml-lang="en-US" l10n="U" oldref="28">=CONFIDENCE(0.05; 1.5; 100) gives 0.29.</paragraph>
-<embed href="text/shared/00/00000001.xhp#siehe"/>
-<paragraph role="paragraph" id="par_id3151339" xml-lang="en-US" l10n="U" oldref="29"><link href="text/scalc/01/04060182.xhp" name="ZTEST">ZTEST</link></paragraph>
-</section>
+<bookmark xml-lang="en-US" branch="hid/HID_FUNC_KONFIDENZ" id="bm_id3153803" localize="false"/>
+<paragraph role="heading" id="hd_id3153559" xml-lang="en-US" level="2" l10n="U" oldref="20">CONFIDENCE</paragraph>
+<paragraph role="paragraph" id="par_id3153814" xml-lang="en-US" l10n="U" oldref="21"><ahelp hid="HID_FUNC_KONFIDENZ">Returns the (1-alpha) confidence interval for a normal distribution.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3149315" xml-lang="en-US" level="3" l10n="U" oldref="22">Syntax</paragraph>
+<paragraph role="paragraph" id="par_id3147501" xml-lang="en-US" l10n="U" oldref="23">CONFIDENCE(Alpha; STDEV; Size)</paragraph>
+<paragraph role="paragraph" id="par_id3149872" xml-lang="en-US" l10n="U" oldref="24">
+<emph>Alpha</emph> is the level of the confidence interval.</paragraph>
+<paragraph role="paragraph" id="par_id3145324" xml-lang="en-US" l10n="U" oldref="25">
+<emph>STDEV</emph> is the standard deviation for the total population.</paragraph>
+<paragraph role="paragraph" id="par_id3153075" xml-lang="en-US" l10n="U" oldref="26">
+<emph>Size</emph> is the size of the total population.</paragraph>
+<paragraph role="heading" id="hd_id3150435" xml-lang="en-US" level="3" l10n="U" oldref="27">Example</paragraph>
+<paragraph role="paragraph" id="par_id3153335" xml-lang="en-US" l10n="U" oldref="28">=CONFIDENCE(0.05; 1.5; 100) gives 0.29.</paragraph>
+<embed href="text/shared/00/00000001.xhp#siehe"/>
+<paragraph role="paragraph" id="par_id3151339" xml-lang="en-US" l10n="U" oldref="29"><link href="text/scalc/01/04060182.xhp" name="ZTEST">ZTEST</link></paragraph>
+</section>
<section id="correl">
<bookmark xml-lang="en-US" branch="index" id="bm_id3148746"><bookmark_value>CORREL function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_KORREL" id="bm_id3147403" localize="false"/>
-<paragraph role="heading" id="hd_id3148746" xml-lang="en-US" level="2" l10n="U" oldref="30">CORREL</paragraph>
-<paragraph role="paragraph" id="par_id3147299" xml-lang="en-US" l10n="U" oldref="31"><ahelp hid="HID_FUNC_KORREL">Returns the correlation coefficient between two data sets.</ahelp></paragraph>
-<paragraph role="heading" id="hd_id3156397" xml-lang="en-US" level="3" l10n="U" oldref="32">Syntax</paragraph>
-<paragraph role="paragraph" id="par_id3153023" xml-lang="en-US" l10n="U" oldref="33">CORREL(Data_1; Data_2)</paragraph>
-<paragraph role="paragraph" id="par_id3150036" xml-lang="en-US" l10n="U" oldref="34">
-<emph>Data_1</emph> is the first data set.</paragraph>
-<paragraph role="paragraph" id="par_id3153021" xml-lang="en-US" l10n="U" oldref="35">
-<emph>Data_2</emph> is the second data set.</paragraph>
-<paragraph role="heading" id="hd_id3149720" xml-lang="en-US" level="3" l10n="U" oldref="36">Example</paragraph>
-<paragraph role="paragraph" id="par_id3149941" xml-lang="en-US" l10n="U" oldref="37">=CORREL(A1:A50; B1:B50) calculates the correlation coefficient as a measure of the linear correlation of the two data sets.</paragraph>
-<embed href="text/shared/00/00000001.xhp#siehe"/>
-<paragraph role="paragraph" id="par_id3153119" xml-lang="en-US" l10n="U" oldref="38"><link href="text/scalc/01/04060182.xhp" name="FISHER">FISHER</link>, <link href="text/scalc/01/04060182.xhp" name="FISHERINV">FISHERINV</link>, <link href="text/scalc/01/04060183.xhp" name="COVAR">COVAR</link></paragraph>
-</section>
+<bookmark xml-lang="en-US" branch="hid/HID_FUNC_KORREL" id="bm_id3147403" localize="false"/>
+<paragraph role="heading" id="hd_id3148746" xml-lang="en-US" level="2" l10n="U" oldref="30">CORREL</paragraph>
+<paragraph role="paragraph" id="par_id3147299" xml-lang="en-US" l10n="U" oldref="31"><ahelp hid="HID_FUNC_KORREL">Returns the correlation coefficient between two data sets.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3156397" xml-lang="en-US" level="3" l10n="U" oldref="32">Syntax</paragraph>
+<paragraph role="paragraph" id="par_id3153023" xml-lang="en-US" l10n="U" oldref="33">CORREL(Data_1; Data_2)</paragraph>
+<paragraph role="paragraph" id="par_id3150036" xml-lang="en-US" l10n="U" oldref="34">
+<emph>Data_1</emph> is the first data set.</paragraph>
+<paragraph role="paragraph" id="par_id3153021" xml-lang="en-US" l10n="U" oldref="35">
+<emph>Data_2</emph> is the second data set.</paragraph>
+<paragraph role="heading" id="hd_id3149720" xml-lang="en-US" level="3" l10n="U" oldref="36">Example</paragraph>
+<paragraph role="paragraph" id="par_id3149941" xml-lang="en-US" l10n="U" oldref="37">=CORREL(A1:A50; B1:B50) calculates the correlation coefficient as a measure of the linear correlation of the two data sets.</paragraph>
+<embed href="text/shared/00/00000001.xhp#siehe"/>
+<paragraph role="paragraph" id="par_id3153119" xml-lang="en-US" l10n="U" oldref="38"><link href="text/scalc/01/04060182.xhp" name="FISHER">FISHER</link>, <link href="text/scalc/01/04060182.xhp" name="FISHERINV">FISHERINV</link>, <link href="text/scalc/01/04060183.xhp" name="COVAR">COVAR</link></paragraph>
+</section>
<section id="covar">
<bookmark xml-lang="en-US" branch="index" id="bm_id3150652"><bookmark_value>COVAR function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_KOVAR" id="bm_id3152983" localize="false"/>
-<paragraph role="heading" id="hd_id3150652" xml-lang="en-US" level="2" l10n="U" oldref="39">COVAR</paragraph>
-<paragraph role="paragraph" id="par_id3146875" xml-lang="en-US" l10n="U" oldref="40"><ahelp hid="HID_FUNC_KOVAR">Returns the covariance of the product of paired deviations.</ahelp></paragraph>
-<paragraph role="heading" id="hd_id3149013" xml-lang="en-US" level="3" l10n="U" oldref="41">Syntax</paragraph>
-<paragraph role="paragraph" id="par_id3150740" xml-lang="en-US" l10n="U" oldref="42">COVAR(Data_1; Data_2)</paragraph>
-<paragraph role="paragraph" id="par_id3145827" xml-lang="en-US" l10n="U" oldref="43">
-<emph>Data_1</emph> is the first data set.</paragraph>
-<paragraph role="paragraph" id="par_id3150465" xml-lang="en-US" l10n="U" oldref="44">
-<emph>Data_2</emph> is the second data set.</paragraph>
-<paragraph role="heading" id="hd_id3154677" xml-lang="en-US" level="3" l10n="U" oldref="45">Example</paragraph>
-<paragraph role="paragraph" id="par_id3144748" xml-lang="en-US" l10n="U" oldref="46">=COVAR(A1:A30; B1:B30)</paragraph>
-<embed href="text/shared/00/00000001.xhp#siehe"/>
-<paragraph role="paragraph" id="par_id3148438" xml-lang="en-US" l10n="U" oldref="47"><link href="text/scalc/01/04060182.xhp" name="FISHER">FISHER</link>, <link href="text/scalc/01/04060182.xhp" name="FISHERINV">FISHERINV</link>, <link href="text/scalc/01/04060183.xhp" name="CORREL">CORREL</link></paragraph>
-</section>
+<bookmark xml-lang="en-US" branch="hid/HID_FUNC_KOVAR" id="bm_id3152983" localize="false"/>
+<paragraph role="heading" id="hd_id3150652" xml-lang="en-US" level="2" l10n="U" oldref="39">COVAR</paragraph>
+<paragraph role="paragraph" id="par_id3146875" xml-lang="en-US" l10n="U" oldref="40"><ahelp hid="HID_FUNC_KOVAR">Returns the covariance of the product of paired deviations.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3149013" xml-lang="en-US" level="3" l10n="U" oldref="41">Syntax</paragraph>
+<paragraph role="paragraph" id="par_id3150740" xml-lang="en-US" l10n="U" oldref="42">COVAR(Data_1; Data_2)</paragraph>
+<paragraph role="paragraph" id="par_id3145827" xml-lang="en-US" l10n="U" oldref="43">
+<emph>Data_1</emph> is the first data set.</paragraph>
+<paragraph role="paragraph" id="par_id3150465" xml-lang="en-US" l10n="U" oldref="44">
+<emph>Data_2</emph> is the second data set.</paragraph>
+<paragraph role="heading" id="hd_id3154677" xml-lang="en-US" level="3" l10n="U" oldref="45">Example</paragraph>
+<paragraph role="paragraph" id="par_id3144748" xml-lang="en-US" l10n="U" oldref="46">=COVAR(A1:A30; B1:B30)</paragraph>
+<embed href="text/shared/00/00000001.xhp#siehe"/>
+<paragraph role="paragraph" id="par_id3148438" xml-lang="en-US" l10n="U" oldref="47"><link href="text/scalc/01/04060182.xhp" name="FISHER">FISHER</link>, <link href="text/scalc/01/04060182.xhp" name="FISHERINV">FISHERINV</link>, <link href="text/scalc/01/04060183.xhp" name="CORREL">CORREL</link></paragraph>
+</section>
<section id="critbinom">
<bookmark xml-lang="en-US" branch="index" id="bm_id3147472"><bookmark_value>CRITBINOM function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_KRITBINOM" id="bm_id3154848" localize="false"/>
-<paragraph role="heading" id="hd_id3147472" xml-lang="en-US" level="2" l10n="U" oldref="48">CRITBINOM</paragraph>
-<paragraph role="paragraph" id="par_id3149254" xml-lang="en-US" l10n="U" oldref="49"><ahelp hid="HID_FUNC_KRITBINOM">Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.</ahelp></paragraph>
-<paragraph role="heading" id="hd_id3153930" xml-lang="en-US" level="3" l10n="U" oldref="50">Syntax</paragraph>
-<paragraph role="paragraph" id="par_id3148586" xml-lang="en-US" l10n="U" oldref="51">CRITBINOM(Trials; SP; Alpha)</paragraph>
-<paragraph role="paragraph" id="par_id3145593" xml-lang="en-US" l10n="U" oldref="52">
-<emph>Trials</emph> is the total number of trials.</paragraph>
-<paragraph role="paragraph" id="par_id3153084" xml-lang="en-US" l10n="U" oldref="53">
-<emph>SP</emph> is the probability of success for one trial.</paragraph>
-<paragraph role="paragraph" id="par_id3149726" xml-lang="en-US" l10n="U" oldref="54">
-<emph>Alpha</emph> is the threshold probability to be reached or exceeded.</paragraph>
-<paragraph role="heading" id="hd_id3148752" xml-lang="en-US" level="3" l10n="U" oldref="55">Example</paragraph>
-<paragraph role="paragraph" id="par_id3148740" xml-lang="en-US" l10n="U" oldref="56">=CRITBINOM(100; 0.5; 0.1) yields 44.</paragraph>
-<embed href="text/shared/00/00000001.xhp#siehe"/>
-<paragraph role="paragraph" id="par_id3150143" xml-lang="en-US" l10n="U" oldref="57"><link href="text/scalc/01/04060181.xhp" name="BINOMDIST">BINOMDIST</link>, <link href="text/scalc/01/04060106.xhp" name="FACT">FACT</link>, <link href="text/scalc/01/04060182.xhp" name="HYPGEOMDIST">HYPGEOMDIST</link>, <link href="text/scalc/01/04060106.xhp" name="COMBIN">COMBIN</link>, <link href="text/scalc/01/04060184.xhp" name="NEGBINOMDIST">NEGBINOMDIST</link>, <link href="text/scalc/01/04060185.xhp" name="PERMUT">PERMUT</link>, <link href="text/scalc/01/04060185.xhp" name="PROB">PROB</link></paragraph>
-</section>
+<bookmark xml-lang="en-US" branch="hid/HID_FUNC_KRITBINOM" id="bm_id3154848" localize="false"/>
+<paragraph role="heading" id="hd_id3147472" xml-lang="en-US" level="2" l10n="U" oldref="48">CRITBINOM</paragraph>
+<paragraph role="paragraph" id="par_id3149254" xml-lang="en-US" l10n="U" oldref="49"><ahelp hid="HID_FUNC_KRITBINOM">Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3153930" xml-lang="en-US" level="3" l10n="U" oldref="50">Syntax</paragraph>
+<paragraph role="paragraph" id="par_id3148586" xml-lang="en-US" l10n="U" oldref="51">CRITBINOM(Trials; SP; Alpha)</paragraph>
+<paragraph role="paragraph" id="par_id3145593" xml-lang="en-US" l10n="U" oldref="52">
+<emph>Trials</emph> is the total number of trials.</paragraph>
+<paragraph role="paragraph" id="par_id3153084" xml-lang="en-US" l10n="U" oldref="53">
+<emph>SP</emph> is the probability of success for one trial.</paragraph>
+<paragraph role="paragraph" id="par_id3149726" xml-lang="en-US" l10n="U" oldref="54">
+<emph>Alpha</emph> is the threshold probability to be reached or exceeded.</paragraph>
+<paragraph role="heading" id="hd_id3148752" xml-lang="en-US" level="3" l10n="U" oldref="55">Example</paragraph>
+<paragraph role="paragraph" id="par_id3148740" xml-lang="en-US" l10n="U" oldref="56">=CRITBINOM(100; 0.5; 0.1) yields 44.</paragraph>
+<embed href="text/shared/00/00000001.xhp#siehe"/>
+<paragraph role="paragraph" id="par_id3150143" xml-lang="en-US" l10n="U" oldref="57"><link href="text/scalc/01/04060181.xhp" name="BINOMDIST">BINOMDIST</link>, <link href="text/scalc/01/04060106.xhp" name="FACT">FACT</link>, <link href="text/scalc/01/04060182.xhp" name="HYPGEOMDIST">HYPGEOMDIST</link>, <link href="text/scalc/01/04060106.xhp" name="COMBIN">COMBIN</link>, <link href="text/scalc/01/04060184.xhp" name="NEGBINOMDIST">NEGBINOMDIST</link>, <link href="text/scalc/01/04060185.xhp" name="PERMUT">PERMUT</link>, <link href="text/scalc/01/04060185.xhp" name="PROB">PROB</link></paragraph>
+</section>
<section id="kurt">
<bookmark xml-lang="en-US" branch="index" id="bm_id3155956"><bookmark_value>KURT function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_KURT" id="bm_id3146847" localize="false"/>
-<paragraph role="heading" id="hd_id3155956" xml-lang="en-US" level="2" l10n="U" oldref="58">KURT</paragraph>
-<paragraph role="paragraph" id="par_id3153108" xml-lang="en-US" l10n="U" oldref="59"><ahelp hid="HID_FUNC_KURT">Returns the kurtosis of a data set (at least 4 values required).</ahelp></paragraph>
-<paragraph role="heading" id="hd_id3150334" xml-lang="en-US" level="3" l10n="U" oldref="60">Syntax</paragraph>
-<paragraph role="paragraph" id="par_id3154508" xml-lang="en-US" l10n="U" oldref="61">KURT(Number 1; Number 2; ...Number 30)</paragraph>
-<paragraph role="paragraph" id="par_id3145167" xml-lang="en-US" l10n="CHG" oldref="62">
-<emph>Number 1,Number 2,...Number 30</emph> are numeric arguments or ranges representing a random sample of distribution.</paragraph>
-<paragraph role="heading" id="hd_id3158000" xml-lang="en-US" level="3" l10n="U" oldref="63">Example</paragraph>
-<paragraph role="paragraph" id="par_id3150016" xml-lang="en-US" l10n="U" oldref="64">=KURT(A1;A2;A3;A4;A5;A6)</paragraph>
-<embed href="text/shared/00/00000001.xhp#siehe"/>
-<paragraph role="paragraph" id="par_id3150135" xml-lang="en-US" l10n="U" oldref="65"><link href="text/scalc/01/04060185.xhp" name="SKEW">SKEW</link>, <link href="text/scalc/01/04060185.xhp" name="STDEV">STDEV</link>, <link href="text/scalc/01/04060185.xhp" name="STDEVP">STDEVP</link>, <link href="text/scalc/01/04060185.xhp" name="VAR">VAR</link>, <link href="text/scalc/01/04060185.xhp" name="VARP">VARP</link></paragraph>
-</section>
+<bookmark xml-lang="en-US" branch="hid/HID_FUNC_KURT" id="bm_id3146847" localize="false"/>
+<paragraph role="heading" id="hd_id3155956" xml-lang="en-US" level="2" l10n="U" oldref="58">KURT</paragraph>
+<paragraph role="paragraph" id="par_id3153108" xml-lang="en-US" l10n="U" oldref="59"><ahelp hid="HID_FUNC_KURT">Returns the kurtosis of a data set (at least 4 values required).</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3150334" xml-lang="en-US" level="3" l10n="U" oldref="60">Syntax</paragraph>
+<paragraph role="paragraph" id="par_id3154508" xml-lang="en-US" l10n="U" oldref="61">KURT(Number 1; Number 2; ...Number 30)</paragraph>
+<paragraph role="paragraph" id="par_id3145167" xml-lang="en-US" l10n="CHG" oldref="62">
+<emph>Number 1,Number 2,...Number 30</emph> are numeric arguments or ranges representing a random sample of distribution.</paragraph>
+<paragraph role="heading" id="hd_id3158000" xml-lang="en-US" level="3" l10n="U" oldref="63">Example</paragraph>
+<paragraph role="paragraph" id="par_id3150016" xml-lang="en-US" l10n="U" oldref="64">=KURT(A1;A2;A3;A4;A5;A6)</paragraph>
+<embed href="text/shared/00/00000001.xhp#siehe"/>
+<paragraph role="paragraph" id="par_id3150135" xml-lang="en-US" l10n="U" oldref="65"><link href="text/scalc/01/04060185.xhp" name="SKEW">SKEW</link>, <link href="text/scalc/01/04060185.xhp" name="STDEV">STDEV</link>, <link href="text/scalc/01/04060185.xhp" name="STDEVP">STDEVP</link>, <link href="text/scalc/01/04060185.xhp" name="VAR">VAR</link>, <link href="text/scalc/01/04060185.xhp" name="VARP">VARP</link></paragraph>
+</section>
<section id="loginv">
<bookmark xml-lang="en-US" branch="index" id="bm_id3150928"><bookmark_value>LOGINV function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_LOGINV" id="bm_id3156062" localize="false"/>
-<paragraph role="heading" id="hd_id3150928" xml-lang="en-US" level="2" l10n="U" oldref="66">LOGINV</paragraph>
-<paragraph role="paragraph" id="par_id3145297" xml-lang="en-US" l10n="U" oldref="67"><ahelp hid="HID_FUNC_LOGINV">Returns the inverse of the lognormal distribution.</ahelp></paragraph>
-<paragraph role="heading" id="hd_id3151016" xml-lang="en-US" level="3" l10n="U" oldref="68">Syntax</paragraph>
-<paragraph role="paragraph" id="par_id3153049" xml-lang="en-US" l10n="U" oldref="69">LOGINV(Number; Mean; STDEV)</paragraph>
-<paragraph role="paragraph" id="par_id3148390" xml-lang="en-US" l10n="U" oldref="70">
-<emph>Number</emph> is the probability value for which the inverse standard logarithmic distribution is to be calculated.</paragraph>
-<paragraph role="paragraph" id="par_id3149538" xml-lang="en-US" l10n="U" oldref="71">
-<emph>Mean</emph> is the arithmetic mean of the standard logarithmic distribution.</paragraph>
-<paragraph role="paragraph" id="par_id3145355" xml-lang="en-US" l10n="U" oldref="72">
-<emph>STDEV</emph> is the standard deviation of the standard logarithmic distribution.</paragraph>
-<paragraph role="heading" id="hd_id3148768" xml-lang="en-US" level="3" l10n="U" oldref="73">Example</paragraph>
-<paragraph role="paragraph" id="par_id3155623" xml-lang="en-US" l10n="U" oldref="74">=LOGINV(0.05; 0; 1) returns 0.19.</paragraph>
-<embed href="text/shared/00/00000001.xhp#siehe"/>
-<paragraph role="paragraph" id="par_id3153551" xml-lang="en-US" l10n="U" oldref="75"><link href="text/scalc/01/04060106.xhp" name="EXP">EXP</link>, <link href="text/scalc/01/04060106.xhp" name="LN">LN</link>, <link href="text/scalc/01/04060106.xhp" name="LOG">LOG</link>, <link href="text/scalc/01/04060106.xhp" name="LOG10">LOG10</link>, <link href="text/scalc/01/04060183.xhp" name="LOGNORMDIST">LOGNORMDIST</link></paragraph>
-</section>
+<bookmark xml-lang="en-US" branch="hid/HID_FUNC_LOGINV" id="bm_id3156062" localize="false"/>
+<paragraph role="heading" id="hd_id3150928" xml-lang="en-US" level="2" l10n="U" oldref="66">LOGINV</paragraph>
+<paragraph role="paragraph" id="par_id3145297" xml-lang="en-US" l10n="U" oldref="67"><ahelp hid="HID_FUNC_LOGINV">Returns the inverse of the lognormal distribution.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3151016" xml-lang="en-US" level="3" l10n="U" oldref="68">Syntax</paragraph>
+<paragraph role="paragraph" id="par_id3153049" xml-lang="en-US" l10n="U" oldref="69">LOGINV(Number; Mean; STDEV)</paragraph>
+<paragraph role="paragraph" id="par_id3148390" xml-lang="en-US" l10n="U" oldref="70">
+<emph>Number</emph> is the probability value for which the inverse standard logarithmic distribution is to be calculated.</paragraph>
+<paragraph role="paragraph" id="par_id3149538" xml-lang="en-US" l10n="U" oldref="71">
+<emph>Mean</emph> is the arithmetic mean of the standard logarithmic distribution.</paragraph>
+<paragraph role="paragraph" id="par_id3145355" xml-lang="en-US" l10n="U" oldref="72">
+<emph>STDEV</emph> is the standard deviation of the standard logarithmic distribution.</paragraph>
+<paragraph role="heading" id="hd_id3148768" xml-lang="en-US" level="3" l10n="U" oldref="73">Example</paragraph>
+<paragraph role="paragraph" id="par_id3155623" xml-lang="en-US" l10n="U" oldref="74">=LOGINV(0.05; 0; 1) returns 0.19.</paragraph>
+<embed href="text/shared/00/00000001.xhp#siehe"/>
+<paragraph role="paragraph" id="par_id3153551" xml-lang="en-US" l10n="U" oldref="75"><link href="text/scalc/01/04060106.xhp" name="EXP">EXP</link>, <link href="text/scalc/01/04060106.xhp" name="LN">LN</link>, <link href="text/scalc/01/04060106.xhp" name="LOG">LOG</link>, <link href="text/scalc/01/04060106.xhp" name="LOG10">LOG10</link>, <link href="text/scalc/01/04060183.xhp" name="LOGNORMDIST">LOGNORMDIST</link></paragraph>
+</section>
<section id="lognormdist">
<bookmark xml-lang="en-US" branch="index" id="bm_id3158417"><bookmark_value>LOGNORMDIST function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_LOGNORMVERT" id="bm_id3155366" localize="false"/>
-<paragraph role="heading" id="hd_id3158417" xml-lang="en-US" level="2" l10n="U" oldref="76">LOGNORMDIST</paragraph>
-<paragraph role="paragraph" id="par_id3154953" xml-lang="en-US" l10n="U" oldref="77"><ahelp hid="HID_FUNC_LOGNORMVERT">Returns the cumulative lognormal distribution.</ahelp></paragraph>
-<paragraph role="heading" id="hd_id3150474" xml-lang="en-US" level="3" l10n="U" oldref="78">Syntax</paragraph>
-<paragraph role="paragraph" id="par_id3150686" xml-lang="en-US" l10n="U" oldref="79">LOGNORMDIST(Number; Mean; STDEV)</paragraph>
-<paragraph role="paragraph" id="par_id3154871" xml-lang="en-US" l10n="U" oldref="80">
-<emph>Number</emph> is the probability value for which the standard logarithmic distribution is to be calculated.</paragraph>
-<paragraph role="paragraph" id="par_id3155820" xml-lang="en-US" l10n="U" oldref="81">
-<emph>Mean</emph> is the mean value of the standard logarithmic distribution.</paragraph>
-<paragraph role="paragraph" id="par_id3155991" xml-lang="en-US" l10n="U" oldref="82">
-<emph>STDEV</emph> is the standard deviation of the standard logarithmic distribution.</paragraph>
-<paragraph role="heading" id="hd_id3153178" xml-lang="en-US" level="3" l10n="U" oldref="83">Example</paragraph>
-<paragraph role="paragraph" id="par_id3149778" xml-lang="en-US" l10n="U" oldref="84">=LOGNORMDIST(0.1; 0; 1) returns 0.01.</paragraph>
-<embed href="text/shared/00/00000001.xhp#siehe"/>
-<paragraph role="paragraph" id="par_id3153722" xml-lang="en-US" l10n="U" oldref="85"><link href="text/scalc/01/04060106.xhp" name="EXP">EXP</link>, <link href="text/scalc/01/04060106.xhp" name="LN">LN</link>, <link href="text/scalc/01/04060106.xhp" name="LOG">LOG</link>, <link href="text/scalc/01/04060106.xhp" name="LOG10">LOG10</link>, <link href="text/scalc/01/04060183.xhp" name="LOGINV">LOGINV</link></paragraph>
+<bookmark xml-lang="en-US" branch="hid/HID_FUNC_LOGNORMVERT" id="bm_id3155366" localize="false"/>
+<paragraph role="heading" id="hd_id3158417" xml-lang="en-US" level="2" l10n="U" oldref="76">LOGNORMDIST</paragraph>
+<paragraph role="paragraph" id="par_id3154953" xml-lang="en-US" l10n="U" oldref="77"><ahelp hid="HID_FUNC_LOGNORMVERT">Returns the cumulative lognormal distribution.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3150474" xml-lang="en-US" level="3" l10n="U" oldref="78">Syntax</paragraph>
+<paragraph role="paragraph" id="par_id3150686" xml-lang="en-US" l10n="U" oldref="79">LOGNORMDIST(Number; Mean; STDEV)</paragraph>
+<paragraph role="paragraph" id="par_id3154871" xml-lang="en-US" l10n="U" oldref="80">
+<emph>Number</emph> is the probability value for which the standard logarithmic distribution is to be calculated.</paragraph>
+<paragraph role="paragraph" id="par_id3155820" xml-lang="en-US" l10n="U" oldref="81">
+<emph>Mean</emph> is the mean value of the standard logarithmic distribution.</paragraph>
+<paragraph role="paragraph" id="par_id3155991" xml-lang="en-US" l10n="U" oldref="82">
+<emph>STDEV</emph> is the standard deviation of the standard logarithmic distribution.</paragraph>
+<paragraph role="heading" id="hd_id3153178" xml-lang="en-US" level="3" l10n="U" oldref="83">Example</paragraph>
+<paragraph role="paragraph" id="par_id3149778" xml-lang="en-US" l10n="U" oldref="84">=LOGNORMDIST(0.1; 0; 1) returns 0.01.</paragraph>
+<embed href="text/shared/00/00000001.xhp#siehe"/>
+<paragraph role="paragraph" id="par_id3153722" xml-lang="en-US" l10n="U" oldref="85"><link href="text/scalc/01/04060106.xhp" name="EXP">EXP</link>, <link href="text/scalc/01/04060106.xhp" name="LN">LN</link>, <link href="text/scalc/01/04060106.xhp" name="LOG">LOG</link>, <link href="text/scalc/01/04060106.xhp" name="LOG10">LOG10</link>, <link href="text/scalc/01/04060183.xhp" name="LOGINV">LOGINV</link></paragraph>
</section>
-</sort>
-</body>
-</helpdocument>
+</sort>
+</body>
+</helpdocument>