diff options
| author | Rüdiger Timm <rt@openoffice.org> | 2004-11-26 15:04:44 +0000 |
|---|---|---|
| committer | Rüdiger Timm <rt@openoffice.org> | 2004-11-26 15:04:44 +0000 |
| commit | 775e11b22f2922a790f2d87094365eb5b6fe8c0b (patch) | |
| tree | 7b6db894fcb3616fe238bc3637c8ab2ade2d8354 /helpcontent2/source/text/scalc/01 | |
| parent | INTEGRATION: CWS helpcontentbeta (1.1.2); FILE MERGED (diff) | |
| download | help-775e11b22f2922a790f2d87094365eb5b6fe8c0b.tar.gz help-775e11b22f2922a790f2d87094365eb5b6fe8c0b.zip | |
INTEGRATION: CWS helpcontentbeta (1.2.2); FILE MERGED
2004/10/14 13:43:57 fpe 1.2.2.1: Regular Update
Diffstat (limited to 'helpcontent2/source/text/scalc/01')
| -rwxr-xr-x | helpcontent2/source/text/scalc/01/04060183.xhp | 38 | ||||
| -rwxr-xr-x | helpcontent2/source/text/scalc/01/04060184.xhp | 38 | ||||
| -rwxr-xr-x | helpcontent2/source/text/scalc/01/04060185.xhp | 98 |
3 files changed, 54 insertions, 120 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060183.xhp b/helpcontent2/source/text/scalc/01/04060183.xhp index 9a7fedef02..8fefb98747 100755 --- a/helpcontent2/source/text/scalc/01/04060183.xhp +++ b/helpcontent2/source/text/scalc/01/04060183.xhp @@ -62,7 +62,7 @@ </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> +<lastedited date="2004-10-12T13:07:00">converted from old format - fpe</lastedited> </history> </meta> <body> @@ -76,15 +76,13 @@ <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="code" 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> @@ -93,15 +91,13 @@ <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="code" 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> @@ -110,7 +106,7 @@ <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="code" 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"> @@ -119,8 +115,6 @@ <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> @@ -129,15 +123,13 @@ <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="code" 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> @@ -146,15 +138,13 @@ <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="code" 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> @@ -163,7 +153,7 @@ <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="code" 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"> @@ -172,8 +162,6 @@ <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> @@ -182,13 +170,11 @@ <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="code" 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> @@ -197,7 +183,7 @@ <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="code" 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"> @@ -206,8 +192,6 @@ <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> @@ -216,7 +200,7 @@ <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="code" 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"> @@ -225,8 +209,6 @@ <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> diff --git a/helpcontent2/source/text/scalc/01/04060184.xhp b/helpcontent2/source/text/scalc/01/04060184.xhp index 8cea6f2c82..d045f929dd 100755 --- a/helpcontent2/source/text/scalc/01/04060184.xhp +++ b/helpcontent2/source/text/scalc/01/04060184.xhp @@ -62,7 +62,7 @@ </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2004-07-20T16:27:22">FPE: Inserted sections, added sort element</lastedited> +<lastedited date="2004-10-12T12:56:34">FPE: Inserted sections, added sort element</lastedited> </history> </meta> <body> @@ -76,7 +76,7 @@ <paragraph role="heading" id="hd_id3154511" xml-lang="en-US" level="2" l10n="U" oldref="2">MAX</paragraph> <paragraph role="paragraph" id="par_id3153709" xml-lang="en-US" l10n="U" oldref="3"><ahelp hid="HID_FUNC_MAX">Returns the maximum value in a list of arguments.</ahelp></paragraph> <paragraph role="heading" id="hd_id3154256" xml-lang="en-US" level="3" l10n="U" oldref="4">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3147340" xml-lang="en-US" l10n="U" oldref="5">MAX(Number 1; Number 2; ...Number 30)</paragraph> +<paragraph role="code" id="par_id3147340" xml-lang="en-US" l10n="U" oldref="5">MAX(Number 1; Number 2; ...Number 30)</paragraph> <paragraph role="paragraph" id="par_id3149568" xml-lang="en-US" l10n="CHG" oldref="6"> <emph>Number 1; Number 2;...Number 30</emph> are numerical values or ranges. </paragraph> <paragraph role="heading" id="hd_id3153963" xml-lang="en-US" level="3" l10n="U" oldref="7">Example</paragraph> @@ -90,7 +90,7 @@ <paragraph role="heading" id="hd_id3166426" xml-lang="en-US" level="2" l10n="U" oldref="139">MAXA</paragraph> <paragraph role="paragraph" id="par_id3150363" xml-lang="en-US" l10n="U" oldref="140"><ahelp hid="HID_FUNC_MAXA">Returns the maximum value in a list of arguments. In opposite to MAX, here you can enter text. The value of the text is 0.</ahelp></paragraph> <paragraph role="heading" id="hd_id3150516" xml-lang="en-US" level="3" l10n="U" oldref="141">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3166431" xml-lang="en-US" l10n="U" oldref="142">MAXA(Value 1; Value 2; ... Value 30)</paragraph> +<paragraph role="code" id="par_id3166431" xml-lang="en-US" l10n="U" oldref="142">MAXA(Value 1; Value 2; ... Value 30)</paragraph> <paragraph role="paragraph" id="par_id3150202" xml-lang="en-US" l10n="CHG" oldref="143"> <emph>Value 1; Value 2;...Value 30</emph> are values or ranges. Text has the value of 0.</paragraph> <paragraph role="heading" id="hd_id3156290" xml-lang="en-US" level="3" l10n="U" oldref="144">Example</paragraph> @@ -104,7 +104,7 @@ <paragraph role="heading" id="hd_id3153820" xml-lang="en-US" level="2" l10n="U" oldref="11">MEDIAN</paragraph> <paragraph role="paragraph" id="par_id3151241" xml-lang="en-US" l10n="U" oldref="12"><ahelp hid="HID_FUNC_MEDIAN">Returns the median of a set of numbers. In a set containing an uneven number of values, the median will be the number in the middle of the set and in a set containing an even number of values, it will be the mean of the two values in the middle of the set.</ahelp></paragraph> <paragraph role="heading" id="hd_id3148871" xml-lang="en-US" level="3" l10n="U" oldref="13">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3155264" xml-lang="en-US" l10n="U" oldref="14">MEDIAN(Number 1; Number 2; ...Number 30)</paragraph> +<paragraph role="code" id="par_id3155264" xml-lang="en-US" l10n="U" oldref="14">MEDIAN(Number 1; Number 2; ...Number 30)</paragraph> <paragraph role="paragraph" id="par_id3150109" xml-lang="en-US" l10n="CHG" oldref="15"> <emph>Number 1; Number 2;...Number 30</emph> are values or ranges, which represent a sample. Each number can also be replaced by a reference.</paragraph> <paragraph role="heading" id="hd_id3144506" xml-lang="en-US" level="3" l10n="U" oldref="16">Example</paragraph> @@ -118,7 +118,7 @@ <paragraph role="heading" id="hd_id3154541" xml-lang="en-US" level="2" l10n="U" oldref="19">MIN</paragraph> <paragraph role="paragraph" id="par_id3143222" xml-lang="en-US" l10n="U" oldref="20"><ahelp hid="HID_FUNC_MIN">Returns the minimum value in a list of arguments.</ahelp></paragraph> <paragraph role="heading" id="hd_id3154651" xml-lang="en-US" level="3" l10n="U" oldref="21">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3146964" xml-lang="en-US" l10n="U" oldref="22">MIN(Number 1; Number 2; ...Number 30)</paragraph> +<paragraph role="code" id="par_id3146964" xml-lang="en-US" l10n="U" oldref="22">MIN(Number 1; Number 2; ...Number 30)</paragraph> <paragraph role="paragraph" id="par_id3153486" xml-lang="en-US" l10n="CHG" oldref="23"> <emph>Number 1; Number 2;...Number 30</emph> are numerical values or ranges.</paragraph> <paragraph role="heading" id="hd_id3155523" xml-lang="en-US" level="3" l10n="U" oldref="24">Example</paragraph> @@ -131,7 +131,7 @@ <paragraph role="heading" id="hd_id3147504" xml-lang="en-US" level="2" l10n="U" oldref="148">MINA</paragraph> <paragraph role="paragraph" id="par_id3147249" xml-lang="en-US" l10n="U" oldref="149"><ahelp hid="HID_FUNC_MINA">Returns the minimum value in a list of arguments. Here you can also enter text. The value of the text is 0.</ahelp></paragraph> <paragraph role="heading" id="hd_id3150435" xml-lang="en-US" level="3" l10n="U" oldref="150">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3153336" xml-lang="en-US" l10n="U" oldref="151">MINA(Value 1; Value 2; ... Value 30)</paragraph> +<paragraph role="code" id="par_id3153336" xml-lang="en-US" l10n="U" oldref="151">MINA(Value 1; Value 2; ... Value 30)</paragraph> <paragraph role="paragraph" id="par_id3146098" xml-lang="en-US" l10n="CHG" oldref="152"> <emph>Value 1; Value 2;...Value 30</emph> are values or ranges. Text has the value of 0.</paragraph> <paragraph role="heading" id="hd_id3148743" xml-lang="en-US" level="3" l10n="U" oldref="153">Example</paragraph> @@ -145,7 +145,7 @@ <paragraph role="heading" id="hd_id3166465" xml-lang="en-US" level="2" l10n="U" oldref="27">AVEDEV</paragraph> <paragraph role="paragraph" id="par_id3150373" xml-lang="en-US" l10n="U" oldref="28"><ahelp hid="HID_FUNC_MITTELABW">Returns the average of the absolute deviations of data points from their mean.</ahelp> Displays the diffusion in a data set.</paragraph> <paragraph role="heading" id="hd_id3150038" xml-lang="en-US" level="3" l10n="U" oldref="29">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3145636" xml-lang="en-US" l10n="U" oldref="30">AVEDEV(Number 1; Number 2; ...Number 30)</paragraph> +<paragraph role="code" id="par_id3145636" xml-lang="en-US" l10n="U" oldref="30">AVEDEV(Number 1; Number 2; ...Number 30)</paragraph> <paragraph role="paragraph" id="par_id3157871" xml-lang="en-US" l10n="U" oldref="31"> <emph>Number 1, Number 2,...Number 30</emph> are values or ranges that represent a sample. Each number can also be replaced by a reference.</paragraph> <paragraph role="heading" id="hd_id3149725" xml-lang="en-US" level="3" l10n="U" oldref="32">Example</paragraph> @@ -158,7 +158,7 @@ <paragraph role="heading" id="hd_id3145824" xml-lang="en-US" level="2" l10n="U" oldref="35">AVERAGE</paragraph> <paragraph role="paragraph" id="par_id3150482" xml-lang="en-US" l10n="U" oldref="36"><ahelp hid="HID_FUNC_MITTELWERT">Returns the average of the arguments.</ahelp></paragraph> <paragraph role="heading" id="hd_id3146943" xml-lang="en-US" level="3" l10n="U" oldref="37">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3154679" xml-lang="en-US" l10n="U" oldref="38">AVERAGE(Number 1; Number 2; ...Number 30)</paragraph> +<paragraph role="code" id="par_id3154679" xml-lang="en-US" l10n="U" oldref="38">AVERAGE(Number 1; Number 2; ...Number 30)</paragraph> <paragraph role="paragraph" id="par_id3150741" xml-lang="en-US" l10n="CHG" oldref="39"> <emph>Number 1; Number 2;...Number 30</emph> are numerical values or ranges.</paragraph> <paragraph role="heading" id="hd_id3153039" xml-lang="en-US" level="3" l10n="U" oldref="40">Example</paragraph> @@ -171,7 +171,7 @@ <paragraph role="heading" id="hd_id3148754" xml-lang="en-US" level="2" l10n="U" oldref="157">AVERAGEA</paragraph> <paragraph role="paragraph" id="par_id3145138" xml-lang="en-US" l10n="U" oldref="158"><ahelp hid="HID_FUNC_MITTELWERTA">Returns the average of the arguments. The value of a text is 0.</ahelp></paragraph> <paragraph role="heading" id="hd_id3153326" xml-lang="en-US" level="3" l10n="U" oldref="159">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3149734" xml-lang="en-US" l10n="U" oldref="160">AVERAGEA(Value 1; Value 2; ... Value 30)</paragraph> +<paragraph role="code" id="par_id3149734" xml-lang="en-US" l10n="U" oldref="160">AVERAGEA(Value 1; Value 2; ... Value 30)</paragraph> <paragraph role="paragraph" id="par_id3155260" xml-lang="en-US" l10n="CHG" oldref="161"> <emph>Value 1; Value 2;...Value 30</emph> are values or ranges. Text has the value of 0.</paragraph> <paragraph role="heading" id="hd_id3149504" xml-lang="en-US" level="3" l10n="U" oldref="162">Example</paragraph> @@ -184,7 +184,7 @@ <paragraph role="heading" id="hd_id3153933" xml-lang="en-US" level="2" l10n="U" oldref="43">MODE</paragraph> <paragraph role="paragraph" id="par_id3153085" xml-lang="en-US" l10n="U" oldref="44"><ahelp hid="HID_FUNC_MODALWERT">Returns the most common value in a data set.</ahelp> If there are several values with the same frequency, it returns the smallest value. An error occurs when a value doesn't appear twice.</paragraph> <paragraph role="heading" id="hd_id3153003" xml-lang="en-US" level="3" l10n="U" oldref="45">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3155950" xml-lang="en-US" l10n="U" oldref="46">MODE(Number 1; Number 2; ...Number 30)</paragraph> +<paragraph role="code" id="par_id3155950" xml-lang="en-US" l10n="U" oldref="46">MODE(Number 1; Number 2; ...Number 30)</paragraph> <paragraph role="paragraph" id="par_id3150337" xml-lang="en-US" l10n="CHG" oldref="47"> <emph>Number 1; Number 2;...Number 30</emph> are numerical values or ranges.</paragraph> <paragraph role="heading" id="hd_id3153571" xml-lang="en-US" level="3" l10n="U" oldref="48">Example</paragraph> @@ -197,7 +197,7 @@ <paragraph role="heading" id="hd_id3149879" xml-lang="en-US" level="2" l10n="U" oldref="51">NEGBINOMDIST</paragraph> <paragraph role="paragraph" id="par_id3155437" xml-lang="en-US" l10n="U" oldref="52"><ahelp hid="HID_FUNC_NEGBINOMVERT">Returns the negative binomial distribution.</ahelp></paragraph> <paragraph role="heading" id="hd_id3145351" xml-lang="en-US" level="3" l10n="U" oldref="53">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3150935" xml-lang="en-US" l10n="U" oldref="54">NEGBINOMDIST(X; R; SP)</paragraph> +<paragraph role="code" id="par_id3150935" xml-lang="en-US" l10n="U" oldref="54">NEGBINOMDIST(X; R; SP)</paragraph> <paragraph role="paragraph" id="par_id3153044" xml-lang="en-US" l10n="U" oldref="55"> <emph>X</emph> represents the value returned for unsuccessful tests.</paragraph> <paragraph role="paragraph" id="par_id3151018" xml-lang="en-US" l10n="U" oldref="56"> @@ -214,7 +214,7 @@ <paragraph role="heading" id="hd_id3155516" xml-lang="en-US" level="2" l10n="U" oldref="61">NORMINV</paragraph> <paragraph role="paragraph" id="par_id3154634" xml-lang="en-US" l10n="U" oldref="62"><ahelp hid="HID_FUNC_NORMINV">Returns the inverse of the normal cumulative distribution.</ahelp></paragraph> <paragraph role="heading" id="hd_id3153227" xml-lang="en-US" level="3" l10n="U" oldref="63">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3147534" xml-lang="en-US" l10n="U" oldref="64">NORMINV(Number; Mean; STDEV)</paragraph> +<paragraph role="code" id="par_id3147534" xml-lang="en-US" l10n="U" oldref="64">NORMINV(Number; Mean; STDEV)</paragraph> <paragraph role="paragraph" id="par_id3154950" xml-lang="en-US" l10n="U" oldref="65"> <emph>Number</emph> represents the probability value used to determine the inverse normal distribution.</paragraph> <paragraph role="paragraph" id="par_id3150690" xml-lang="en-US" l10n="U" oldref="66"> @@ -231,7 +231,7 @@ <paragraph role="heading" id="hd_id3153722" xml-lang="en-US" level="2" l10n="U" oldref="71">NORMDIST</paragraph> <paragraph role="paragraph" id="par_id3150386" xml-lang="en-US" l10n="U" oldref="72"><ahelp hid="HID_FUNC_NORMVERT">Returns the standard normal cumulative distribution.</ahelp></paragraph> <paragraph role="heading" id="hd_id3083282" xml-lang="en-US" level="3" l10n="U" oldref="73">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3150613" xml-lang="en-US" l10n="U" oldref="74">NORMDIST(Number; Mean; STDEV; C)</paragraph> +<paragraph role="code" id="par_id3150613" xml-lang="en-US" l10n="U" oldref="74">NORMDIST(Number; Mean; STDEV; C)</paragraph> <paragraph role="paragraph" id="par_id3149820" xml-lang="en-US" l10n="U" oldref="75"> <emph>Number</emph> is the value of the distribution based on which the normal distribution is to be calculated.</paragraph> <paragraph role="paragraph" id="par_id3146063" xml-lang="en-US" l10n="U" oldref="76"> @@ -251,7 +251,7 @@ <paragraph role="heading" id="hd_id3152934" xml-lang="en-US" level="2" l10n="U" oldref="83">PEARSON</paragraph> <paragraph role="paragraph" id="par_id3153216" xml-lang="en-US" l10n="U" oldref="84"><ahelp hid="HID_FUNC_PEARSON">Returns the Pearson product moment correlation coefficient r.</ahelp></paragraph> <paragraph role="heading" id="hd_id3147081" xml-lang="en-US" level="3" l10n="U" oldref="85">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3156133" xml-lang="en-US" l10n="U" oldref="86">PEARSON(Data_1; Data_2)</paragraph> +<paragraph role="code" id="par_id3156133" xml-lang="en-US" l10n="U" oldref="86">PEARSON(Data_1; Data_2)</paragraph> <paragraph role="paragraph" id="par_id3151272" xml-lang="en-US" l10n="U" oldref="87"> <emph>Data_1</emph> represents the array of the first data set.</paragraph> <paragraph role="paragraph" id="par_id3153279" xml-lang="en-US" l10n="U" oldref="88"> @@ -266,7 +266,7 @@ <paragraph role="heading" id="hd_id3152806" xml-lang="en-US" level="2" l10n="U" oldref="92">PHI</paragraph> <paragraph role="paragraph" id="par_id3150254" xml-lang="en-US" l10n="U" oldref="93"><ahelp hid="HID_FUNC_PHI">Returns the values of the distribution function for a standard normal distribution.</ahelp></paragraph> <paragraph role="heading" id="hd_id3154748" xml-lang="en-US" level="3" l10n="U" oldref="94">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3149976" xml-lang="en-US" l10n="U" oldref="95">PHI(Number)</paragraph> +<paragraph role="code" id="par_id3149976" xml-lang="en-US" l10n="U" oldref="95">PHI(Number)</paragraph> <paragraph role="paragraph" id="par_id3156108" xml-lang="en-US" l10n="U" oldref="96"> <emph>Number</emph> represents the value based on which the standard normal distribution is calculated.</paragraph> <paragraph role="heading" id="hd_id3153621" xml-lang="en-US" level="3" l10n="U" oldref="97">Example</paragraph> @@ -281,7 +281,7 @@ <paragraph role="heading" id="hd_id3153985" xml-lang="en-US" level="2" oldref="102">POISSON</paragraph> <paragraph role="paragraph" id="par_id3154298" xml-lang="en-US" l10n="U" oldref="103"><ahelp hid="HID_FUNC_POISSON">Returns the Poisson distribution.</ahelp></paragraph> <paragraph role="heading" id="hd_id3159183" xml-lang="en-US" level="3" l10n="U" oldref="104">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3146093" xml-lang="en-US" l10n="U" oldref="105">POISSON(Number; Mean; C)</paragraph> +<paragraph role="code" id="par_id3146093" xml-lang="en-US" l10n="U" oldref="105">POISSON(Number; Mean; C)</paragraph> <paragraph role="paragraph" id="par_id3147253" xml-lang="en-US" l10n="U" oldref="106"> <emph>Number</emph> represents the value based on which the Poisson distribution is calculated.</paragraph> <paragraph role="paragraph" id="par_id3151177" xml-lang="en-US" l10n="U" oldref="107"> @@ -298,7 +298,7 @@ <paragraph role="heading" id="hd_id3153100" xml-lang="en-US" level="2" l10n="U" oldref="112">PERCENTILE</paragraph> <paragraph role="paragraph" id="par_id3154940" xml-lang="en-US" l10n="U" oldref="113"><ahelp hid="HID_FUNC_QUANTIL">Returns the alpha-percentile of data values in an array.</ahelp> A percentile returns the scale value for a data series which goes from the smallest (Alpha=0) to the largest value (alpha=1) of a data series. For <emph>Alpha</emph> = 25%, the percentile means the first quartile; <emph>Alpha</emph> = 50% is the MEDIAN.</paragraph> <paragraph role="heading" id="hd_id3150531" xml-lang="en-US" level="3" l10n="U" oldref="114">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3148813" xml-lang="en-US" l10n="U" oldref="115">PERCENTILE(Data;Alpha)</paragraph> +<paragraph role="code" id="par_id3148813" xml-lang="en-US" l10n="U" oldref="115">PERCENTILE(Data;Alpha)</paragraph> <paragraph role="paragraph" id="par_id3153054" xml-lang="en-US" l10n="U" oldref="116"> <emph>Data</emph> represents the array of data.</paragraph> <paragraph role="paragraph" id="par_id3154212" xml-lang="en-US" l10n="U" oldref="117"> @@ -313,7 +313,7 @@ <paragraph role="heading" id="hd_id3148807" xml-lang="en-US" level="2" l10n="U" oldref="121">PERCENTRANK</paragraph> <paragraph role="paragraph" id="par_id3153573" xml-lang="en-US" l10n="U" oldref="122"><ahelp hid="HID_FUNC_QUANTILSRANG">Returns the percentage rank of a value in a sample.</ahelp></paragraph> <paragraph role="heading" id="hd_id3147512" xml-lang="en-US" level="3" l10n="U" oldref="123">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3147238" xml-lang="en-US" l10n="U" oldref="124">PERCENTRANK(Data; Value)</paragraph> +<paragraph role="code" id="par_id3147238" xml-lang="en-US" l10n="U" oldref="124">PERCENTRANK(Data; Value)</paragraph> <paragraph role="paragraph" id="par_id3154266" xml-lang="en-US" l10n="U" oldref="125"> <emph>Data</emph> represents the array of data in the sample.</paragraph> <paragraph role="paragraph" id="par_id3148475" xml-lang="en-US" l10n="U" oldref="126"> @@ -328,7 +328,7 @@ <paragraph role="heading" id="hd_id3166442" xml-lang="en-US" level="2" l10n="U" oldref="130">QUARTILE</paragraph> <paragraph role="paragraph" id="par_id3146958" xml-lang="en-US" l10n="U" oldref="131"><ahelp hid="HID_FUNC_QUARTILE">Returns the quartile of a data set.</ahelp></paragraph> <paragraph role="heading" id="hd_id3152942" xml-lang="en-US" level="3" l10n="U" oldref="132">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3153684" xml-lang="en-US" l10n="U" oldref="133">QUARTILE(Data; Type)</paragraph> +<paragraph role="code" id="par_id3153684" xml-lang="en-US" l10n="U" oldref="133">QUARTILE(Data; Type)</paragraph> <paragraph role="paragraph" id="par_id3153387" xml-lang="en-US" l10n="U" oldref="134"> <emph>Data</emph> represents the array of data in the sample.</paragraph> <paragraph role="paragraph" id="par_id3155589" xml-lang="en-US" l10n="U" oldref="135"> diff --git a/helpcontent2/source/text/scalc/01/04060185.xhp b/helpcontent2/source/text/scalc/01/04060185.xhp index ac71fd29cb..7c136ea614 100755 --- a/helpcontent2/source/text/scalc/01/04060185.xhp +++ b/helpcontent2/source/text/scalc/01/04060185.xhp @@ -62,7 +62,7 @@ </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2004-07-20T16:39:18">converted from old format - fpe</lastedited> +<lastedited date="2004-10-12T12:37:37">converted from old format - fpe</lastedited> </history> </meta> <body> @@ -76,7 +76,7 @@ <paragraph role="heading" id="hd_id3155071" xml-lang="en-US" level="2" l10n="U" oldref="2">RANK</paragraph> <paragraph role="paragraph" id="par_id3153976" xml-lang="en-US" l10n="U" oldref="3"><ahelp hid="HID_FUNC_RANG">Returns the rank of a number in a sample.</ahelp></paragraph> <paragraph role="heading" id="hd_id3159206" xml-lang="en-US" level="3" l10n="U" oldref="4">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3153250" xml-lang="en-US" l10n="U" oldref="5">RANK(Value; Data; Type)</paragraph> +<paragraph role="code" id="par_id3153250" xml-lang="en-US" l10n="U" oldref="5">RANK(Value; Data; Type)</paragraph> <paragraph role="paragraph" id="par_id3154543" xml-lang="en-US" l10n="U" oldref="6"> <emph>Value</emph> is the value, whose rank is to be determined.</paragraph> <paragraph role="paragraph" id="par_id3149130" xml-lang="en-US" l10n="U" oldref="7"> @@ -85,8 +85,6 @@ <emph>Type</emph> (optional) is the sequence order. = 0 means ascending, = 1 means descending.</paragraph> <paragraph role="heading" id="hd_id3143223" xml-lang="en-US" level="3" l10n="U" oldref="9">Example</paragraph> <paragraph role="paragraph" id="par_id3155919" xml-lang="en-US" l10n="U" oldref="10">=RANK(A10; A1:A50) returns the ranking of the value in A10 in value range A1:A50. If <emph>Value</emph> does not exist within the range an error message is displayed.</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3154652" xml-lang="en-US" l10n="U" oldref="11"><link href="text/scalc/01/04060184.xhp" name="PERCENTRANK">PERCENTRANK</link></paragraph> </section> <section id="skew"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153556"><bookmark_value>SKEW function</bookmark_value> @@ -95,13 +93,11 @@ <paragraph role="heading" id="hd_id3153556" xml-lang="en-US" level="2" l10n="U" oldref="12">SKEW</paragraph> <paragraph role="paragraph" id="par_id3153485" xml-lang="en-US" l10n="U" oldref="13"><ahelp hid="HID_FUNC_SCHIEFE">Returns the skewness of a distribution.</ahelp></paragraph> <paragraph role="heading" id="hd_id3154733" xml-lang="en-US" level="3" l10n="U" oldref="14">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3151191" xml-lang="en-US" l10n="U" oldref="15">SKEW(Number 1; number 2; ...number 30)</paragraph> +<paragraph role="code" id="par_id3151191" xml-lang="en-US" l10n="U" oldref="15">SKEW(Number 1; number 2; ...number 30)</paragraph> <paragraph role="paragraph" id="par_id3155757" xml-lang="en-US" l10n="CHG" oldref="16"> <emph>Number 1, number 2...number 30</emph> are numerical values or ranges.</paragraph> <paragraph role="heading" id="hd_id3153297" xml-lang="en-US" level="3" l10n="U" oldref="17">Example</paragraph> <paragraph role="paragraph" id="par_id3145118" xml-lang="en-US" l10n="U" oldref="18">=SKEW(A1:A50) calculates the value of skew for the data referenced.</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3146103" xml-lang="en-US" l10n="U" oldref="19"><link href="text/scalc/01/04060183.xhp" name="KURT">KURT</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="forecast"> <bookmark xml-lang="en-US" branch="index" id="bm_id3149051"><bookmark_value>regression lines</bookmark_value> @@ -111,7 +107,7 @@ <paragraph role="heading" id="hd_id3149051" xml-lang="en-US" level="2" l10n="U" oldref="20">FORECAST</paragraph> <paragraph role="paragraph" id="par_id3153290" xml-lang="en-US" l10n="U" oldref="21"><ahelp hid="HID_FUNC_SCHAETZER">Extrapolates future values based on existing x and y values.</ahelp></paragraph> <paragraph role="heading" id="hd_id3151343" xml-lang="en-US" level="3" l10n="U" oldref="22">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3147404" xml-lang="en-US" l10n="U" oldref="23">FORECAST(Value; data_Y; data_X)</paragraph> +<paragraph role="code" id="par_id3147404" xml-lang="en-US" l10n="U" oldref="23">FORECAST(Value; data_Y; data_X)</paragraph> <paragraph role="paragraph" id="par_id3148743" xml-lang="en-US" l10n="U" oldref="24"> <emph>Value</emph> is the x value, for which the y value on the linear regression is to be returned.</paragraph> <paragraph role="paragraph" id="par_id3146325" xml-lang="en-US" l10n="U" oldref="25"> @@ -120,8 +116,6 @@ <emph>Data_X</emph> is the array or range of known x's.</paragraph> <paragraph role="heading" id="hd_id3147416" xml-lang="en-US" level="3" l10n="U" oldref="27">Example</paragraph> <paragraph role="paragraph" id="par_id3157874" xml-lang="en-US" l10n="U" oldref="28">=FORECAST(50; A1:A50; B1;B50) returns the Y value expected for the X value of 50 if the X and Y values in both references are linked by a linear trend.</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3148897" xml-lang="en-US" l10n="U" oldref="29"><link href="text/scalc/01/04060107.xhp" name="LINEST">LINEST</link>, <link href="text/scalc/01/04060107.xhp" name="LOGEST">LOGEST</link>, <link href="text/scalc/01/04060107.xhp" name="TREND">TREND</link>, <link href="text/scalc/01/04060107.xhp" name="GROWTH">GROWTH</link></paragraph> </section> <section id="stdev"> <bookmark xml-lang="en-US" branch="index" id="bm_id3149143"><bookmark_value>STDEV function</bookmark_value> @@ -130,13 +124,11 @@ <paragraph role="heading" id="hd_id3149143" xml-lang="en-US" level="2" l10n="U" oldref="30">STDEV</paragraph> <paragraph role="paragraph" id="par_id3146888" xml-lang="en-US" l10n="U" oldref="31"><ahelp hid="HID_FUNC_STABW">Estimates the standard deviation based on a sample.</ahelp></paragraph> <paragraph role="heading" id="hd_id3146815" xml-lang="en-US" level="3" l10n="U" oldref="32">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3149946" xml-lang="en-US" l10n="U" oldref="33">STDEV(Number 1;number 2;...number 30)</paragraph> +<paragraph role="code" id="par_id3149946" xml-lang="en-US" l10n="U" oldref="33">STDEV(Number 1;number 2;...number 30)</paragraph> <paragraph role="paragraph" id="par_id3157904" xml-lang="en-US" l10n="CHG" oldref="34"> <emph>Number 1, number 2, ... number 30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph> <paragraph role="heading" id="hd_id3150650" xml-lang="en-US" level="3" l10n="U" oldref="35">Example</paragraph> <paragraph role="paragraph" id="par_id3149434" xml-lang="en-US" l10n="U" oldref="36">=STDEV(A1:A50) returns the estimated standard deviation based on the data referenced.</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3154681" xml-lang="en-US" l10n="U" oldref="37"><link href="text/scalc/01/04060184.xhp" name="AVEDEV">AVEDEV</link>, <link href="text/scalc/01/04060184.xhp" name="AVERAGE">AVERAGE</link>, <link href="text/scalc/01/04060184.xhp" name="MODE">MODE</link>, <link href="text/scalc/01/04060185.xhp" name="STDEVP">STDEVP</link>, <link href="text/scalc/01/04060185.xhp" name="VAR">VAR</link></paragraph> </section> <section id="stdeva"> <bookmark xml-lang="en-US" branch="index" id="bm_id3144745"><bookmark_value>STDEVA function</bookmark_value> @@ -145,13 +137,11 @@ <paragraph role="heading" id="hd_id3144745" xml-lang="en-US" level="2" l10n="U" oldref="186">STDEVA</paragraph> <paragraph role="paragraph" id="par_id3151234" xml-lang="en-US" l10n="U" oldref="187"><ahelp hid="HID_FUNC_STABWA">Calculates the standard deviation of an estimation based on a sample.</ahelp></paragraph> <paragraph role="heading" id="hd_id3148884" xml-lang="en-US" level="3" l10n="U" oldref="188">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3147422" xml-lang="en-US" l10n="U" oldref="189">STDEVA(Value 1;value 2;...value 30)</paragraph> +<paragraph role="code" id="par_id3147422" xml-lang="en-US" l10n="U" oldref="189">STDEVA(Value 1;value 2;...value 30)</paragraph> <paragraph role="paragraph" id="par_id3154547" xml-lang="en-US" l10n="CHG" oldref="190"> <emph>Value 1,value 2,...value 30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0.</paragraph> <paragraph role="heading" id="hd_id3155829" xml-lang="en-US" level="3" l10n="U" oldref="191">Example</paragraph> <paragraph role="paragraph" id="par_id3148581" xml-lang="en-US" l10n="U" oldref="192">=STDEVA(A1:A50) returns the estimated standard deviation based on the data referenced.</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3149949" xml-lang="en-US" l10n="U" oldref="193"><link href="text/scalc/01/04060185.xhp" name="STDEV">STDEV</link>, <link href="text/scalc/01/04060185.xhp" name="STDEVP">STDEVP</link> and <link href="text/scalc/01/04060185.xhp" name="STDEVPA">STDEVPA</link></paragraph> </section> <section id="stdevp"> <bookmark xml-lang="en-US" branch="index" id="bm_id3149734"><bookmark_value>STDEVP function</bookmark_value> @@ -160,13 +150,11 @@ <paragraph role="heading" id="hd_id3149734" xml-lang="en-US" level="2" l10n="U" oldref="38">STDEVP</paragraph> <paragraph role="paragraph" id="par_id3149187" xml-lang="en-US" l10n="U" oldref="39"><ahelp hid="HID_FUNC_STABWN">Calculates the standard deviation based on the entire population.</ahelp></paragraph> <paragraph role="heading" id="hd_id3154387" xml-lang="en-US" level="3" l10n="U" oldref="40">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3154392" xml-lang="en-US" l10n="U" oldref="41">STDEVP(Number 1;number 2;...number 30)</paragraph> +<paragraph role="code" id="par_id3154392" xml-lang="en-US" l10n="U" oldref="41">STDEVP(Number 1;number 2;...number 30)</paragraph> <paragraph role="paragraph" id="par_id3155261" xml-lang="en-US" l10n="CHG" oldref="42"> <emph>Number 1,number 2,...number 30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph> <paragraph role="heading" id="hd_id3145591" xml-lang="en-US" level="3" l10n="U" oldref="43">Example</paragraph> <paragraph role="paragraph" id="par_id3153933" xml-lang="en-US" l10n="U" oldref="44">=STDEVP(A1:A50) returns a standard deviation of the data referenced.</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3145126" xml-lang="en-US" l10n="U" oldref="45"><link href="text/scalc/01/04060184.xhp" name="AVEDEV">AVEDEV</link>, <link href="text/scalc/01/04060184.xhp" name="AVERAGE">AVERAGE</link>, <link href="text/scalc/01/04060184.xhp" name="MODE">MODE</link>, <link href="text/scalc/01/04060185.xhp" name="STDEV">STDEV</link>, <link href="text/scalc/01/04060185.xhp" name="VARP">VARP</link></paragraph> </section> <section id="stdevpa"> <bookmark xml-lang="en-US" branch="index" id="bm_id3154522"><bookmark_value>STDEVPA function</bookmark_value> @@ -175,13 +163,11 @@ <paragraph role="heading" id="hd_id3154522" xml-lang="en-US" level="2" l10n="U" oldref="194">STDEVPA</paragraph> <paragraph role="paragraph" id="par_id3149549" xml-lang="en-US" l10n="U" oldref="195"><ahelp hid="HID_FUNC_STABWNA">Calculates the standard deviation based on the entire population.</ahelp></paragraph> <paragraph role="heading" id="hd_id3155950" xml-lang="en-US" level="3" l10n="U" oldref="196">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3146851" xml-lang="en-US" l10n="U" oldref="197">STDEVPA(Value 1;value 2;...value 30)</paragraph> +<paragraph role="code" id="par_id3146851" xml-lang="en-US" l10n="U" oldref="197">STDEVPA(Value 1;value 2;...value 30)</paragraph> <paragraph role="paragraph" id="par_id3153109" xml-lang="en-US" l10n="CHG" oldref="198"> <emph>Value 1,value 2,...value 30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0.</paragraph> <paragraph role="heading" id="hd_id3154506" xml-lang="en-US" level="3" l10n="U" oldref="199">Example</paragraph> <paragraph role="paragraph" id="par_id3145163" xml-lang="en-US" l10n="U" oldref="200">=STDEVPA(A1:A50) returns the standard deviation of the data referenced.</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3153571" xml-lang="en-US" l10n="U" oldref="201"><link href="text/scalc/01/04060185.xhp" name="STDEVP">STDEVP</link> and <link href="text/scalc/01/04060185.xhp" name="STDEV">STDEV</link></paragraph> </section> <section id="standardize"> <bookmark xml-lang="en-US" branch="index" id="bm_id3155928"><bookmark_value>STANDARDIZE function</bookmark_value> @@ -190,7 +176,7 @@ <paragraph role="heading" id="hd_id3155928" xml-lang="en-US" level="2" l10n="U" oldref="46">STANDARDIZE</paragraph> <paragraph role="paragraph" id="par_id3149883" xml-lang="en-US" l10n="U" oldref="47"><ahelp hid="HID_FUNC_STANDARDISIERUNG">Converts a random variable to a normalized value.</ahelp></paragraph> <paragraph role="heading" id="hd_id3154330" xml-lang="en-US" level="3" l10n="U" oldref="48">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3150132" xml-lang="en-US" l10n="U" oldref="49">STANDARDIZE(Number; mean; STDEV)</paragraph> +<paragraph role="code" id="par_id3150132" xml-lang="en-US" l10n="U" oldref="49">STANDARDIZE(Number; mean; STDEV)</paragraph> <paragraph role="paragraph" id="par_id3159139" xml-lang="en-US" l10n="U" oldref="50"> <emph>Number</emph> is the value to be standardized.</paragraph> <paragraph role="paragraph" id="par_id3145241" xml-lang="en-US" l10n="U" oldref="51"> @@ -199,8 +185,6 @@ <emph>STDEV</emph> is the standard deviation of the distribution.</paragraph> <paragraph role="heading" id="hd_id3145351" xml-lang="en-US" level="3" l10n="U" oldref="53">Example</paragraph> <paragraph role="paragraph" id="par_id3156067" xml-lang="en-US" l10n="U" oldref="54">=STANDARDIZE(11; 10; 1) returns 1. The value 11 in a normal distribution with a mean of 10 and a standard deviation of 1 is as much above the mean of 10, as the value 1 is above the mean of the standard normal distribution.</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3151019" xml-lang="en-US" l10n="U" oldref="55"><link href="text/scalc/01/04060182.xhp" name="ZTEST">ZTEST</link>, <link href="text/scalc/01/04060184.xhp" name="NORMINV">NORMINV</link>, <link href="text/scalc/01/04060184.xhp" name="NORMDIST,">NORMDIST,</link><link href="text/scalc/01/04060185.xhp" name="NORMSINV">NORMSINV</link>, <link href="text/scalc/01/04060185.xhp" name="NORMSDIST">NORMSDIST</link></paragraph> </section> <section id="normsinv"> <bookmark xml-lang="en-US" branch="index" id="bm_id3157986"><bookmark_value>NORMSINV function</bookmark_value> @@ -209,13 +193,11 @@ <paragraph role="heading" id="hd_id3157986" xml-lang="en-US" level="2" l10n="U" oldref="56">NORMSINV</paragraph> <paragraph role="paragraph" id="par_id3151282" xml-lang="en-US" l10n="U" oldref="57"><ahelp hid="HID_FUNC_STANDNORMINV">Returns the inverse of the standard normal cumulative distribution.</ahelp></paragraph> <paragraph role="heading" id="hd_id3153261" xml-lang="en-US" level="3" l10n="U" oldref="58">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3154195" xml-lang="en-US" l10n="U" oldref="59">NORMINV(Number)</paragraph> +<paragraph role="code" id="par_id3154195" xml-lang="en-US" l10n="U" oldref="59">NORMINV(Number)</paragraph> <paragraph role="paragraph" id="par_id3148772" xml-lang="en-US" l10n="U" oldref="60"> <emph>Number</emph> is the probability to which the inverse standard normal distribution is calculated.</paragraph> <paragraph role="heading" id="hd_id3150934" xml-lang="en-US" level="3" l10n="U" oldref="61">Example</paragraph> <paragraph role="paragraph" id="par_id3149030" xml-lang="en-US" l10n="U" oldref="62">NORMSINV(0.908789) returns 1.3333.</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3154631" xml-lang="en-US" l10n="U" oldref="63"><link href="text/scalc/01/04060182.xhp" name="ZTEST">ZTEST</link>, <link href="text/scalc/01/04060184.xhp" name="NORMINV">NORMINV</link>, <link href="text/scalc/01/04060184.xhp" name="NORMDIST">NORMDIST</link>, <link href="text/scalc/01/04060185.xhp" name="STANDARDIZE">STANDARDIZE</link>, <link href="text/scalc/01/04060185.xhp" name="NORMSDIST">NORMSDIST</link></paragraph> </section> <section id="normsdist"> <bookmark xml-lang="en-US" branch="index" id="bm_id3147538"><bookmark_value>NORMSDIST function</bookmark_value> @@ -224,13 +206,11 @@ <paragraph role="heading" id="hd_id3147538" xml-lang="en-US" level="2" l10n="U" oldref="64">NORMSDIST</paragraph> <paragraph role="paragraph" id="par_id3150474" xml-lang="en-US" l10n="U" oldref="65"><ahelp hid="HID_FUNC_STANDNORMVERT">Returns the normal cumulative distribution.</ahelp></paragraph> <paragraph role="heading" id="hd_id3155083" xml-lang="en-US" level="3" l10n="U" oldref="66">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3158411" xml-lang="en-US" l10n="U" oldref="67">NORMSDIST(Number)</paragraph> +<paragraph role="code" id="par_id3158411" xml-lang="en-US" l10n="U" oldref="67">NORMSDIST(Number)</paragraph> <paragraph role="paragraph" id="par_id3154950" xml-lang="en-US" l10n="U" oldref="68"> <emph>Number</emph> is the value to which the standard normal distribution is calculated.</paragraph> <paragraph role="heading" id="hd_id3153228" xml-lang="en-US" level="3" l10n="U" oldref="69">Example</paragraph> <paragraph role="paragraph" id="par_id3155984" xml-lang="en-US" l10n="U" oldref="70">=NORMSDIST(1) returns 0.84. The area below the standard normal distribution curve to the left of X value 1 is 84% of the total area.</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3148428" xml-lang="en-US" l10n="U" oldref="71"><link href="text/scalc/01/04060182.xhp" name="ZTEST">ZTEST</link>, <link href="text/scalc/01/04060184.xhp" name="NORMINV">NORMINV</link>, <link href="text/scalc/01/04060184.xhp" name="NORMDIST">NORMDIST</link>, <link href="text/scalc/01/04060184.xhp" name="PHI">PHI</link>, <link href="text/scalc/01/04060185.xhp" name="STANDARDIZE">STANDARDIZE</link>, <link href="text/scalc/01/04060185.xhp" name="NORMSINV">NORMSINV</link></paragraph> </section> <section id="slope"> <bookmark xml-lang="en-US" branch="index" id="bm_id3152592"><bookmark_value>SLOPE function</bookmark_value> @@ -239,15 +219,13 @@ <paragraph role="heading" id="hd_id3152592" xml-lang="en-US" level="2" l10n="U" oldref="72">SLOPE</paragraph> <paragraph role="paragraph" id="par_id3150386" xml-lang="en-US" l10n="U" oldref="73"><ahelp hid="HID_FUNC_STEIGUNG">Returns the slope of the linear regression line.</ahelp> The slope is adapted to the data points set in the y and x values.</paragraph> <paragraph role="heading" id="hd_id3154315" xml-lang="en-US" level="3" l10n="U" oldref="74">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3149819" xml-lang="en-US" l10n="U" oldref="75">SLOPE(data_Y; data_X)</paragraph> +<paragraph role="code" id="par_id3149819" xml-lang="en-US" l10n="U" oldref="75">SLOPE(data_Y; data_X)</paragraph> <paragraph role="paragraph" id="par_id3083446" xml-lang="en-US" l10n="U" oldref="76"> <emph>Data_Y</emph> is the array or matrix of Y data.</paragraph> <paragraph role="paragraph" id="par_id3152375" xml-lang="en-US" l10n="U" oldref="77"> <emph>Data_X</emph> is the array or matrix of X data.</paragraph> <paragraph role="heading" id="hd_id3146061" xml-lang="en-US" level="3" l10n="U" oldref="78">Example</paragraph> <paragraph role="paragraph" id="par_id3152480" xml-lang="en-US" l10n="U" oldref="79">=SLOPE(A1:A50; B1:B50)</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3156378" xml-lang="en-US" l10n="U" oldref="80"><link href="text/scalc/01/04060181.xhp" name="INTERCEPT">INTERCEPT</link>, <link href="text/scalc/01/04060181.xhp" name="RSQ">RSQ</link>, <link href="text/scalc/01/04060184.xhp" name="PEARSON">PEARSON</link>, <link href="text/scalc/01/04060107.xhp" name="LINEST">LINEST</link>, <link href="text/scalc/01/04060107.xhp" name="LOGEST">LOGEST</link>, <link href="text/scalc/01/04060185.xhp" name="STEYX">STEYX</link>, <link href="text/scalc/01/04060107.xhp" name="TREND">TREND</link></paragraph> </section> <section id="steyx"> <bookmark xml-lang="en-US" branch="index" id="bm_id3155836"><bookmark_value>STEYX function</bookmark_value> @@ -256,15 +234,13 @@ <paragraph role="heading" id="hd_id3155836" xml-lang="en-US" level="2" l10n="U" oldref="81">STEYX</paragraph> <paragraph role="paragraph" id="par_id3149446" xml-lang="en-US" l10n="U" oldref="82"><ahelp hid="HID_FUNC_STFEHLERYX">Returns the standard error of the predicted y value for each x in the regression.</ahelp></paragraph> <paragraph role="heading" id="hd_id3147562" xml-lang="en-US" level="3" l10n="U" oldref="83">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3151267" xml-lang="en-US" l10n="U" oldref="84">STEYX(data_Y; data_X)</paragraph> +<paragraph role="code" id="par_id3151267" xml-lang="en-US" l10n="U" oldref="84">STEYX(data_Y; data_X)</paragraph> <paragraph role="paragraph" id="par_id3147313" xml-lang="en-US" l10n="U" oldref="85"> <emph>Data_Y</emph> is the array or matrix of Y data.</paragraph> <paragraph role="paragraph" id="par_id3156097" xml-lang="en-US" l10n="U" oldref="86"> <emph>Data_X</emph> is the array or matrix of X data.</paragraph> <paragraph role="heading" id="hd_id3145204" xml-lang="en-US" level="3" l10n="U" oldref="87">Example</paragraph> <paragraph role="paragraph" id="par_id3156131" xml-lang="en-US" l10n="U" oldref="88">=STEXY(A1:A50; B1:B50)</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3151184" xml-lang="en-US" l10n="U" oldref="89"><link href="text/scalc/01/04060181.xhp" name="INTERCEPT">INTERCEPT</link>, <link href="text/scalc/01/04060181.xhp" name="RSQ">RSQ</link>, <link href="text/scalc/01/04060184.xhp" name="PEARSON">PEARSON</link>, <link href="text/scalc/01/04060107.xhp" name="LINEST">LINEST</link>, <link href="text/scalc/01/04060107.xhp" name="LOGEST">LOGEST</link>, <link href="text/scalc/01/04060185.xhp" name="SLOPE">SLOPE</link></paragraph> </section> <section id="devsq"> <bookmark xml-lang="en-US" branch="index" id="bm_id3150873"><bookmark_value>DEVSQ function</bookmark_value> @@ -273,13 +249,11 @@ <paragraph role="heading" id="hd_id3150873" xml-lang="en-US" level="2" l10n="U" oldref="90">DEVSQ</paragraph> <paragraph role="paragraph" id="par_id3154748" xml-lang="en-US" l10n="U" oldref="91"><ahelp hid="HID_FUNC_SUMQUADABW">Returns the sum of squares of deviations based on a sample mean.</ahelp></paragraph> <paragraph role="heading" id="hd_id3156121" xml-lang="en-US" level="3" l10n="U" oldref="92">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3146790" xml-lang="en-US" l10n="U" oldref="93">DEVSQ(Number 1; number 2; ...number 30)</paragraph> +<paragraph role="code" id="par_id3146790" xml-lang="en-US" l10n="U" oldref="93">DEVSQ(Number 1; number 2; ...number 30)</paragraph> <paragraph role="paragraph" id="par_id3155995" xml-lang="en-US" l10n="CHG" oldref="94"> <emph>Number 1,number 2,...number 30</emph> numerical values or ranges representing a sample.</paragraph> <paragraph role="heading" id="hd_id3150254" xml-lang="en-US" level="3" l10n="U" oldref="95">Example</paragraph> <paragraph role="paragraph" id="par_id3149136" xml-lang="en-US" l10n="U" oldref="96">=DEVSQ(A1:A50)</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3149980" xml-lang="en-US" l10n="U" oldref="97"><link href="text/scalc/01/04060184.xhp" name="AVEDEV">AVEDEV</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="tinv"> <bookmark xml-lang="en-US" branch="index" id="bm_id3149579"><bookmark_value>TINV function</bookmark_value> @@ -288,15 +262,13 @@ <paragraph role="heading" id="hd_id3149579" xml-lang="en-US" level="2" l10n="U" oldref="98">TINV</paragraph> <paragraph role="paragraph" id="par_id3143232" xml-lang="en-US" l10n="U" oldref="99"><ahelp hid="HID_FUNC_TINV">Returns the inverse of the t-distribution.</ahelp></paragraph> <paragraph role="heading" id="hd_id3155101" xml-lang="en-US" level="3" l10n="U" oldref="100">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3149289" xml-lang="en-US" l10n="U" oldref="101">TINV(Number; degrees_freedom)</paragraph> +<paragraph role="code" id="par_id3149289" xml-lang="en-US" l10n="U" oldref="101">TINV(Number; degrees_freedom)</paragraph> <paragraph role="paragraph" id="par_id3154070" xml-lang="en-US" l10n="U" oldref="102"> <emph>Number</emph> is the probability associated with the two-tailed t-distribution.</paragraph> <paragraph role="paragraph" id="par_id3155315" xml-lang="en-US" l10n="U" oldref="103"> <emph>Degrees_freedom</emph> is the number of degrees of freedom for the t-distribution.</paragraph> <paragraph role="heading" id="hd_id3153885" xml-lang="en-US" level="3" l10n="U" oldref="104">Example</paragraph> <paragraph role="paragraph" id="par_id3156010" xml-lang="en-US" l10n="CHG" oldref="105">=TINV(0.1; 6) returns 1.94</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3154302" xml-lang="en-US" l10n="U" oldref="106"><link href="text/scalc/01/04060185.xhp" name="TTEST">TTEST</link>, <link href="text/scalc/01/04060185.xhp" name="TDIST">TDIST</link></paragraph> </section> <section id="ttest"> <bookmark xml-lang="en-US" branch="index" id="bm_id3154129"><bookmark_value>TTEST function</bookmark_value> @@ -305,7 +277,7 @@ <paragraph role="heading" id="hd_id3154129" xml-lang="en-US" level="2" l10n="U" oldref="107">TTEST</paragraph> <paragraph role="paragraph" id="par_id3159184" xml-lang="en-US" l10n="U" oldref="108"><ahelp hid="HID_FUNC_TTEST">Returns the probability associated with a Student's t-Test.</ahelp></paragraph> <paragraph role="heading" id="hd_id3147257" xml-lang="en-US" level="3" l10n="U" oldref="109">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3151175" xml-lang="en-US" l10n="U" oldref="110">TTEST(Data_1; Data_2; Mode; Type)</paragraph> +<paragraph role="code" id="par_id3151175" xml-lang="en-US" l10n="U" oldref="110">TTEST(Data_1; Data_2; Mode; Type)</paragraph> <paragraph role="paragraph" id="par_id3149202" xml-lang="en-US" l10n="U" oldref="111"> <emph>Data_1</emph> is the dependent array or range of data for the first record.</paragraph> <paragraph role="paragraph" id="par_id3145666" xml-lang="en-US" l10n="U" oldref="112"> @@ -316,8 +288,6 @@ <emph>Type</emph> is the kind of t-test to perform. Type 1 means paired. Type 2 means two samples, equal variance (homoscedastic). Type 3 means two samples, unequal variance (heteroscedastic).</paragraph> <paragraph role="heading" id="hd_id3159342" xml-lang="en-US" level="3" l10n="U" oldref="115">Example</paragraph> <paragraph role="paragraph" id="par_id3150119" xml-lang="en-US" l10n="U" oldref="116">=TTEST(A1:A50; B1:B50; 2; 2)</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3148559" xml-lang="en-US" l10n="U" oldref="117"><link href="text/scalc/01/04060185.xhp" name="TINV">TINV</link>, <link href="text/scalc/01/04060185.xhp" name="TDIST">TDIST</link></paragraph> </section> <section id="tdist"> <bookmark xml-lang="en-US" branch="index" id="bm_id3154930"><bookmark_value>TDIST function</bookmark_value> @@ -326,7 +296,7 @@ <paragraph role="heading" id="hd_id3154930" xml-lang="en-US" level="2" l10n="U" oldref="118">TDIST</paragraph> <paragraph role="paragraph" id="par_id3153372" xml-lang="en-US" l10n="U" oldref="119"><ahelp hid="HID_FUNC_TVERT">Returns the t-distribution.</ahelp></paragraph> <paragraph role="heading" id="hd_id3149911" xml-lang="en-US" level="3" l10n="U" oldref="120">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3150521" xml-lang="en-US" l10n="U" oldref="121">TDIST(Number; Degrees_freedom; Mode)</paragraph> +<paragraph role="code" id="par_id3150521" xml-lang="en-US" l10n="U" oldref="121">TDIST(Number; Degrees_freedom; Mode)</paragraph> <paragraph role="paragraph" id="par_id3146991" xml-lang="en-US" l10n="U" oldref="122"> <emph>Number</emph> is the value for which the t-distribution is calculated.</paragraph> <paragraph role="paragraph" id="par_id3148824" xml-lang="en-US" l10n="U" oldref="123"> @@ -335,8 +305,6 @@ <emph>Mode</emph> = 1 returns the one-tailed test, <emph>Mode</emph> = 2 returns the two-tailed test.</paragraph> <paragraph role="heading" id="hd_id3159150" xml-lang="en-US" level="3" l10n="U" oldref="125">Example</paragraph> <paragraph role="paragraph" id="par_id3149773" xml-lang="en-US" l10n="U" oldref="126">=TDIST(12; 5; 1)</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3154212" xml-lang="en-US" l10n="U" oldref="127"><link href="text/scalc/01/04060185.xhp" name="TINV">TINV</link>, <link href="text/scalc/01/04060185.xhp" name="TTEST">TTEST</link></paragraph> </section> <section id="var"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153828"><bookmark_value>VAR function</bookmark_value> @@ -345,13 +313,11 @@ <paragraph role="heading" id="hd_id3153828" xml-lang="en-US" level="2" l10n="U" oldref="128">VAR</paragraph> <paragraph role="paragraph" id="par_id3159165" xml-lang="en-US" l10n="U" oldref="129"><ahelp hid="HID_FUNC_VARIANZ">Estimates the variance based on a sample.</ahelp></paragraph> <paragraph role="heading" id="hd_id3154286" xml-lang="en-US" level="3" l10n="U" oldref="130">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3153054" xml-lang="en-US" l10n="U" oldref="131">VAR(Number 1; number 2; ...number 30)</paragraph> +<paragraph role="code" id="par_id3153054" xml-lang="en-US" l10n="U" oldref="131">VAR(Number 1; number 2; ...number 30)</paragraph> <paragraph role="paragraph" id="par_id3148938" xml-lang="en-US" l10n="CHG" oldref="132"> <emph>Number 1,number 2,...number 30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph> <paragraph role="heading" id="hd_id3147233" xml-lang="en-US" level="3" l10n="U" oldref="133">Example</paragraph> <paragraph role="paragraph" id="par_id3153575" xml-lang="en-US" l10n="U" oldref="134">=VAR(A1:A50)</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3147506" xml-lang="en-US" l10n="U" oldref="135"><link href="text/scalc/01/04060184.xhp" name="AVEDEV">AVEDEV</link>, <link href="text/scalc/01/04060184.xhp" name="AVERAGE">AVERAGE</link>, <link href="text/scalc/01/04060184.xhp" name="MODE">MODE</link>, <link href="text/scalc/01/04060185.xhp" name="STDEV">STDEV</link></paragraph> </section> <section id="vara"> <bookmark xml-lang="en-US" branch="index" id="bm_id3151045"><bookmark_value>VARA function</bookmark_value> @@ -360,13 +326,11 @@ <paragraph role="heading" id="hd_id3151045" xml-lang="en-US" level="2" l10n="U" oldref="202">VARA</paragraph> <paragraph role="paragraph" id="par_id3155122" xml-lang="en-US" l10n="U" oldref="203"><ahelp hid="HID_FUNC_VARIANZA">Estimates a variance based on a sample. The value of text is 0.</ahelp></paragraph> <paragraph role="heading" id="hd_id3149176" xml-lang="en-US" level="3" l10n="U" oldref="204">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3149999" xml-lang="en-US" l10n="U" oldref="205">VARA(Value 1; value 2; ...value 30)</paragraph> +<paragraph role="code" id="par_id3149999" xml-lang="en-US" l10n="U" oldref="205">VARA(Value 1; value 2; ...value 30)</paragraph> <paragraph role="paragraph" id="par_id3158421" xml-lang="en-US" l10n="CHG" oldref="206"> <emph>Value 1,value 2,...value 30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0.</paragraph> <paragraph role="heading" id="hd_id3149160" xml-lang="en-US" level="3" l10n="U" oldref="207">Example</paragraph> <paragraph role="paragraph" id="par_id3154279" xml-lang="en-US" l10n="U" oldref="208">=VARA(A1:A50)</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3153237" xml-lang="en-US" l10n="U" oldref="209"><link href="text/scalc/01/04060185.xhp" name="VAR">VAR</link>, <link href="text/scalc/01/04060185.xhp" name="STDEV">STDEV</link> and <link href="text/scalc/01/04060185.xhp" name="STDEVA">STDEVA</link></paragraph> </section> <section id="varp"> <bookmark xml-lang="en-US" branch="index" id="bm_id3166441"><bookmark_value>VARP function</bookmark_value> @@ -375,13 +339,11 @@ <paragraph role="heading" id="hd_id3166441" xml-lang="en-US" level="2" l10n="U" oldref="136">VARP</paragraph> <paragraph role="paragraph" id="par_id3159199" xml-lang="en-US" l10n="U" oldref="137"><ahelp hid="HID_FUNC_VARIANZEN">Calculates a variance based on the entire population.</ahelp></paragraph> <paragraph role="heading" id="hd_id3150706" xml-lang="en-US" level="3" l10n="U" oldref="138">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3147282" xml-lang="en-US" l10n="U" oldref="139">VARP(Number 1; number 2; ...number 30)</paragraph> +<paragraph role="code" id="par_id3147282" xml-lang="en-US" l10n="U" oldref="139">VARP(Number 1; number 2; ...number 30)</paragraph> <paragraph role="paragraph" id="par_id3149793" xml-lang="en-US" l10n="CHG" oldref="140"> <emph>Number 1,number 2,...number 30</emph> are numerical values or ranges representing an entire population.</paragraph> <paragraph role="heading" id="hd_id3152939" xml-lang="en-US" level="3" l10n="U" oldref="141">Example</paragraph> <paragraph role="paragraph" id="par_id3153385" xml-lang="en-US" l10n="U" oldref="142">=VARP(A1:A50)</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3150244" xml-lang="en-US" l10n="U" oldref="143"><link href="text/scalc/01/04060184.xhp" name="AVEDEV">AVEDEV</link>, <link href="text/scalc/01/04060184.xhp" name="AVERAGE">AVERAGE</link>, <link href="text/scalc/01/04060184.xhp" name="MODE">MODE</link>, <link href="text/scalc/01/04060185.xhp" name="STDEV">STDEV</link></paragraph> </section> <section id="varpa"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153688"><bookmark_value>VARPA function</bookmark_value> @@ -390,13 +352,11 @@ <paragraph role="heading" id="hd_id3153688" xml-lang="en-US" level="2" l10n="U" oldref="210">VARPA</paragraph> <paragraph role="paragraph" id="par_id3149109" xml-lang="en-US" l10n="U" oldref="211"><ahelp hid="HID_FUNC_VARIANZENA">Calculates the variance based on the entire population. The value of text is 0.</ahelp></paragraph> <paragraph role="heading" id="hd_id3152880" xml-lang="en-US" level="3" l10n="U" oldref="212">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3149967" xml-lang="en-US" l10n="U" oldref="213">VARA(Value 1; value 2; ...value 30)</paragraph> +<paragraph role="code" id="par_id3149967" xml-lang="en-US" l10n="U" oldref="213">VARA(Value 1; value 2; ...value 30)</paragraph> <paragraph role="paragraph" id="par_id3149920" xml-lang="en-US" l10n="CHG" oldref="214"> <emph>Value 1,value 2,...value 30</emph> are values or ranges representing an entire population.</paragraph> <paragraph role="heading" id="hd_id3154862" xml-lang="en-US" level="3" l10n="U" oldref="215">Example</paragraph> <paragraph role="paragraph" id="par_id3156203" xml-lang="en-US" l10n="U" oldref="216">=VARPA(A1:A50)</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3148994" xml-lang="en-US" l10n="U" oldref="217"><link href="text/scalc/01/04060185.xhp" name="STDEVP">STDEVP</link> and <link href="text/scalc/01/04060185.xhp" name="STDEVPA">STDEVPA</link></paragraph> </section> <section id="permut"> <bookmark xml-lang="en-US" branch="index" id="bm_id3154599"><bookmark_value>PERMUT function</bookmark_value> @@ -405,15 +365,13 @@ <paragraph role="heading" id="hd_id3154599" xml-lang="en-US" level="2" l10n="U" oldref="144">PERMUT</paragraph> <paragraph role="paragraph" id="par_id3154334" xml-lang="en-US" l10n="U" oldref="145"><ahelp hid="HID_FUNC_VARIATIONEN">Returns the number of permutations for a given number of objects.</ahelp></paragraph> <paragraph role="heading" id="hd_id3149422" xml-lang="en-US" level="3" l10n="U" oldref="146">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3148466" xml-lang="en-US" l10n="U" oldref="147">PERMUT(Count_1; Count_2)</paragraph> +<paragraph role="code" id="par_id3148466" xml-lang="en-US" l10n="U" oldref="147">PERMUT(Count_1; Count_2)</paragraph> <paragraph role="paragraph" id="par_id3148656" xml-lang="en-US" l10n="U" oldref="148"> <emph>Count_1</emph> is the total number of objects.</paragraph> <paragraph role="paragraph" id="par_id3150826" xml-lang="en-US" l10n="U" oldref="149"> <emph>Count_2</emph> is the number of objects in each permutation.</paragraph> <paragraph role="heading" id="hd_id3153351" xml-lang="en-US" level="3" l10n="U" oldref="150">Example</paragraph> <paragraph role="paragraph" id="par_id3150424" xml-lang="en-US" l10n="U" oldref="151">=PERMUT(6; 3) returns 120. There are 120 different possibilities, to pick a sequence of 3 playing cards out of 6 playing cards.</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3145308" xml-lang="en-US" l10n="U" oldref="152"><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/04060183.xhp" name="CRITBINOM">CRITBINOM</link>, <link href="text/scalc/01/04060184.xhp" name="NEGBINOMDIST">NEGBINOMDIST</link></paragraph> </section> <section id="permutationa"> <bookmark xml-lang="en-US" branch="index" id="bm_id3143276"><bookmark_value>PERMUTATIONA function</bookmark_value> @@ -422,7 +380,7 @@ <paragraph role="heading" id="hd_id3143276" xml-lang="en-US" level="2" l10n="U" oldref="153">PERMUTATIONA</paragraph> <paragraph role="paragraph" id="par_id3144759" xml-lang="en-US" l10n="U" oldref="154"><ahelp hid="HID_FUNC_VARIATIONEN2">Returns the number of permutations for a given number of objects (repetition allowed).</ahelp></paragraph> <paragraph role="heading" id="hd_id3145598" xml-lang="en-US" level="3" l10n="U" oldref="155">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3149298" xml-lang="en-US" l10n="U" oldref="156">PERMUTATIONA(Count_1; Count_2)</paragraph> +<paragraph role="code" id="par_id3149298" xml-lang="en-US" l10n="U" oldref="156">PERMUTATIONA(Count_1; Count_2)</paragraph> <paragraph role="paragraph" id="par_id3156139" xml-lang="en-US" l10n="U" oldref="157"> <emph>Count_1</emph> is the total number of objects.</paragraph> <paragraph role="paragraph" id="par_id3149519" xml-lang="en-US" l10n="U" oldref="158"> @@ -431,8 +389,6 @@ <paragraph role="paragraph" id="par_id3153949" xml-lang="en-US" l10n="U" oldref="160">How often can 2 objects be selected from a total of 11 objects?</paragraph> <paragraph role="paragraph" id="par_id3149233" xml-lang="en-US" l10n="U" oldref="161">PERMUTATIONA(11;2) returns 121.</paragraph> <paragraph role="paragraph" id="par_id3150622" xml-lang="en-US" l10n="U" oldref="162">PERMUTATIONA(6; 3) returns 216. There are 216 different possibilities to put a sequence of 3 playing cards together out of six playing cards if every card is returned before the next one is drawn.</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3154802" xml-lang="en-US" l10n="U" oldref="163"><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="COMBINA">COMBINA</link>, <link href="text/scalc/01/04060183.xhp" name="CRITBINOM">CRITBINOM</link>, <link href="text/scalc/01/04060184.xhp" name="NEGBINOMDIST">NEGBINOMDIST</link></paragraph> </section> <section id="prob"> <bookmark xml-lang="en-US" branch="index" id="bm_id3152952"><bookmark_value>PROB function</bookmark_value> @@ -441,7 +397,7 @@ <paragraph role="heading" id="hd_id3152952" xml-lang="en-US" level="2" l10n="U" oldref="164">PROB</paragraph> <paragraph role="paragraph" id="par_id3154110" xml-lang="en-US" l10n="U" oldref="165"><ahelp hid="HID_FUNC_WAHRSCHBEREICH">Returns the probability that values in a range are between two limits.</ahelp> If there is no <emph>End</emph> value, this function calculates the probability based on the principle that the Data values are equal to the value of <emph>Start</emph>.</paragraph> <paragraph role="heading" id="hd_id3146810" xml-lang="en-US" level="3" l10n="U" oldref="166">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3147330" xml-lang="en-US" l10n="U" oldref="167">PROB(Data; Probability: Start; End)</paragraph> +<paragraph role="code" id="par_id3147330" xml-lang="en-US" l10n="U" oldref="167">PROB(Data; Probability: Start; End)</paragraph> <paragraph role="paragraph" id="par_id3154573" xml-lang="en-US" l10n="U" oldref="168"> <emph>Data</emph> is the array or range of data in the sample.</paragraph> <paragraph role="paragraph" id="par_id3156334" xml-lang="en-US" l10n="U" oldref="169"> @@ -452,8 +408,6 @@ <emph>End</emph> (optional) is the end value of the interval whose probabilities are to be summed. If this parameter is missing, the probability for the <emph>Start </emph>value is calculated.</paragraph> <paragraph role="heading" id="hd_id3147574" xml-lang="en-US" level="3" l10n="U" oldref="172">Example</paragraph> <paragraph role="paragraph" id="par_id3153666" xml-lang="en-US" l10n="U" oldref="173">=PROB(A1:A50; B1:B50; 50; 60) returns the probability with which a value within the range of A1:A50 is also within the limits between 50 and 60. Every value within the range of A1:A50 has a probability within the range of B1:B50.</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3155606" xml-lang="en-US" l10n="U" oldref="174"><link href="text/scalc/01/04060181.xhp" name="BINOMDIST">BINOMDIST</link>, <link href="text/scalc/01/04060183.xhp" name="CRITBINOM">CRITBINOM</link></paragraph> </section> <section id="weibull"> <bookmark xml-lang="en-US" branch="index" id="bm_id3150941"><bookmark_value>WEIBULL function</bookmark_value> @@ -462,7 +416,7 @@ <paragraph role="heading" id="hd_id3150941" xml-lang="en-US" level="2" l10n="U" oldref="175">WEIBULL</paragraph> <paragraph role="paragraph" id="par_id3154916" xml-lang="en-US" l10n="U" oldref="176"><ahelp hid="HID_FUNC_WEIBULL">Returns the values of the Weibull distribution.</ahelp></paragraph> <paragraph role="heading" id="hd_id3159393" xml-lang="en-US" level="3" l10n="U" oldref="177">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3154478" xml-lang="en-US" l10n="U" oldref="178">WEIBULL(Number; Alpha; Beta; C)</paragraph> +<paragraph role="code" id="par_id3154478" xml-lang="en-US" l10n="U" oldref="178">WEIBULL(Number; Alpha; Beta; C)</paragraph> <paragraph role="paragraph" id="par_id3151317" xml-lang="en-US" l10n="U" oldref="179"> <emph>Number</emph> is the value at which to calculate the Weibull distribution.</paragraph> <paragraph role="paragraph" id="par_id3158436" xml-lang="en-US" l10n="U" oldref="180"> @@ -473,8 +427,6 @@ <emph>C</emph> indicates the type of function. If C equals 0 the form of the function is calculated, if C equals 1 the distribution is calculated.</paragraph> <paragraph role="heading" id="hd_id3153794" xml-lang="en-US" level="3" l10n="U" oldref="183">Example</paragraph> <paragraph role="paragraph" id="par_id3146077" xml-lang="en-US" l10n="U" oldref="184">=WEIBULL(2; 1; 1; 1) returns 0.86.</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3156046" xml-lang="en-US" l10n="U" oldref="185"><link href="text/scalc/01/04060181.xhp" name="EXPONDIST">EXPONDIST</link></paragraph> </section> </sort> </body> |