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/04060184.xhp | |
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/04060184.xhp')
-rwxr-xr-x | helpcontent2/source/text/scalc/01/04060184.xhp | 38 |
1 files changed, 19 insertions, 19 deletions
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"> |