summaryrefslogtreecommitdiffstats
path: root/helpcontent2/source/text/scalc/01/04060184.xhp
diff options
context:
space:
mode:
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060184.xhp')
-rw-r--r--[-rwxr-xr-x]helpcontent2/source/text/scalc/01/04060184.xhp36
1 files changed, 18 insertions, 18 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060184.xhp b/helpcontent2/source/text/scalc/01/04060184.xhp
index ea21a96603..0348ae8616 100755..100644
--- a/helpcontent2/source/text/scalc/01/04060184.xhp
+++ b/helpcontent2/source/text/scalc/01/04060184.xhp
@@ -44,7 +44,7 @@
<section id="max">
<bookmark xml-lang="en-US" branch="index" id="bm_id3154511"><bookmark_value>MAX function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_MAX" id="bm_id3146972" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MAX" id="bm_id3146972" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3154511" role="heading" level="2" l10n="U" oldref="2">MAX</paragraph>
<paragraph xml-lang="en-US" id="par_id3153709" role="paragraph" l10n="U" oldref="3"><ahelp hid="HID_FUNC_MAX">Returns the maximum value in a list of arguments.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id9282509" role="paragraph" l10n="NEW">Returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN() and MAX(). The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MIN() or MAX(), e.g. MIN("string"), still results in an error.</paragraph>
@@ -60,7 +60,7 @@
<section id="maxa">
<bookmark xml-lang="en-US" branch="index" id="bm_id3166426"><bookmark_value>MAXA function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_MAXA" id="bm_id3150304" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MAXA" id="bm_id3150304" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3166426" role="heading" level="2" l10n="U"
oldref="139">MAXA</paragraph>
<paragraph xml-lang="en-US" id="par_id3150363" role="paragraph" 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>
@@ -79,7 +79,7 @@ oldref="144">Example</paragraph>
<section id="median">
<bookmark xml-lang="en-US" branch="index" id="bm_id3153820"><bookmark_value>MEDIAN function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_MEDIAN" id="bm_id3153069" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MEDIAN" id="bm_id3153069" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3153820" role="heading" level="2" l10n="U"
oldref="11">MEDIAN</paragraph>
<paragraph xml-lang="en-US" id="par_id3151241" role="paragraph" 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>
@@ -95,7 +95,7 @@ oldref="16">Example</paragraph>
<section id="min">
<bookmark xml-lang="en-US" branch="index" id="bm_id3154541"><bookmark_value>MIN function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_MIN" id="bm_id3159226" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MIN" id="bm_id3159226" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3154541" role="heading" level="2" l10n="U"
oldref="19">MIN</paragraph>
<paragraph xml-lang="en-US" id="par_id3143222" role="paragraph" l10n="U" oldref="20"><ahelp hid="HID_FUNC_MIN">Returns the minimum value in a list of arguments.</ahelp></paragraph>
@@ -112,7 +112,7 @@ oldref="24">Example</paragraph>
<section id="mina">
<bookmark xml-lang="en-US" branch="index" id="bm_id3147504"><bookmark_value>MINA function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_MINA" id="bm_id3155752" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MINA" id="bm_id3155752" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3147504" role="heading" level="2" l10n="U"
oldref="148">MINA</paragraph>
<paragraph xml-lang="en-US" id="par_id3147249" role="paragraph" 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>
@@ -132,7 +132,7 @@ oldref="153">Example</paragraph>
<bookmark xml-lang="en-US" branch="index" id="bm_id3166465"><bookmark_value>AVEDEV function</bookmark_value>
<bookmark_value>averages;statistical functions</bookmark_value>
</bookmark><comment>mw added "averages;"</comment>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_MITTELABW" id="bm_id3156396" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELABW" id="bm_id3156396" localize="false"/>
<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>
@@ -146,7 +146,7 @@ oldref="153">Example</paragraph>
<section id="average">
<bookmark xml-lang="en-US" branch="index" id="bm_id3145824"><bookmark_value>AVERAGE function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_MITTELWERT" id="bm_id3146878" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELWERT" id="bm_id3146878" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3145824" role="heading" level="2" l10n="U"
oldref="35">AVERAGE</paragraph>
<paragraph xml-lang="en-US" id="par_id3150482" role="paragraph" l10n="U" oldref="36"><ahelp hid="HID_FUNC_MITTELWERT">Returns the average of the arguments.</ahelp></paragraph>
@@ -163,7 +163,7 @@ oldref="40">Example</paragraph>
<section id="averagea">
<bookmark xml-lang="en-US" branch="index" id="bm_id3148754"><bookmark_value>AVERAGEA function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_MITTELWERTA" id="bm_id3149690" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELWERTA" id="bm_id3149690" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3148754" role="heading" level="2" l10n="U"
oldref="157">AVERAGEA</paragraph>
<paragraph xml-lang="en-US" id="par_id3145138" role="paragraph" l10n="U" oldref="158"><ahelp hid="HID_FUNC_MITTELWERTA">Returns the average of the arguments. The value of a text is 0.</ahelp></paragraph>
@@ -181,7 +181,7 @@ oldref="162">Example</paragraph>
<bookmark xml-lang="en-US" branch="index" id="bm_id3153933"><bookmark_value>MODE function</bookmark_value>
<bookmark_value>most common value</bookmark_value>
</bookmark><comment>mw added one entry</comment>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_MODALWERT" id="bm_id3149253" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MODALWERT" id="bm_id3149253" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3153933" role="heading" level="2" l10n="U"
oldref="43">MODE</paragraph>
<paragraph xml-lang="en-US" id="par_id3153085" role="paragraph" 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>
@@ -199,7 +199,7 @@ oldref="48">Example</paragraph>
<bookmark xml-lang="en-US" branch="index" id="bm_id3149879"><bookmark_value>NEGBINOMDIST function</bookmark_value>
<bookmark_value>negative binomial distribution</bookmark_value>
</bookmark><comment>mw added one entry</comment>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_NEGBINOMVERT" id="bm_id3159135" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NEGBINOMVERT" id="bm_id3159135" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3149879" role="heading" level="2" l10n="U"
oldref="51">NEGBINOMDIST</paragraph>
<paragraph xml-lang="en-US" id="par_id3155437" role="paragraph" l10n="U" oldref="52"><ahelp hid="HID_FUNC_NEGBINOMVERT">Returns the negative binomial distribution.</ahelp></paragraph>
@@ -218,7 +218,7 @@ oldref="58">Example</paragraph>
<bookmark xml-lang="en-US" branch="index" id="bm_id3155516"><bookmark_value>NORMINV function</bookmark_value>
<bookmark_value>normal distribution;inverse of</bookmark_value>
</bookmark><comment>mw added one entry</comment>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_NORMINV" id="bm_id3149396" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NORMINV" id="bm_id3149396" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3155516" role="heading" level="2" l10n="U"
oldref="61">NORMINV</paragraph>
<paragraph xml-lang="en-US" id="par_id3154634" role="paragraph" l10n="U" oldref="62"><ahelp hid="HID_FUNC_NORMINV">Returns the inverse of the normal cumulative distribution.</ahelp></paragraph>
@@ -237,7 +237,7 @@ oldref="68">Example</paragraph>
<bookmark xml-lang="en-US" branch="index" id="bm_id3153722"><bookmark_value>NORMDIST function</bookmark_value>
<bookmark_value>density function</bookmark_value>
</bookmark><comment>mw added one entry</comment>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_NORMVERT" id="bm_id3147484" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NORMVERT" id="bm_id3147484" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3153722" role="heading" level="2" l10n="U"
oldref="71">NORMDIST</paragraph>
<paragraph xml-lang="en-US" id="par_id3150386" role="paragraph" l10n="CHG" oldref="72"><ahelp hid="HID_FUNC_NORMVERT">Returns the density function or the normal cumulative distribution.</ahelp></paragraph>
@@ -258,7 +258,7 @@ oldref="79">Example</paragraph>
<section id="pearson">
<bookmark xml-lang="en-US" branch="index" id="bm_id3152934"><bookmark_value>PEARSON function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_PEARSON" id="bm_id3156103" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_PEARSON" id="bm_id3156103" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3152934" role="heading" level="2" l10n="U"
oldref="83">PEARSON</paragraph>
<paragraph xml-lang="en-US" id="par_id3153216" role="paragraph" l10n="U" oldref="84"><ahelp hid="HID_FUNC_PEARSON">Returns the Pearson product moment correlation coefficient r.</ahelp></paragraph>
@@ -275,7 +275,7 @@ oldref="89">Example</paragraph>
<section id="phi">
<bookmark xml-lang="en-US" branch="index" id="bm_id3152806"><bookmark_value>PHI function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_PHI" id="bm_id3153757" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_PHI" id="bm_id3153757" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3152806" role="heading" level="2" l10n="U"
oldref="92">PHI</paragraph>
<paragraph xml-lang="en-US" id="par_id3150254" role="paragraph" l10n="U" oldref="93"><ahelp hid="HID_FUNC_PHI">Returns the values of the distribution function for a standard normal distribution.</ahelp></paragraph>
@@ -295,7 +295,7 @@ oldref="97">Example</paragraph>
<section id="poisson">
<bookmark xml-lang="en-US" branch="index" id="bm_id3153985"><bookmark_value>POISSON function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_POISSON" id="bm_id3156011" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_POISSON" id="bm_id3156011" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3153985" role="heading" level="2" oldref="102">POISSON</paragraph>
<paragraph xml-lang="en-US" id="par_id3154298" role="paragraph" l10n="U" oldref="103"><ahelp hid="HID_FUNC_POISSON">Returns the Poisson distribution.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id3159183" role="heading" level="3" l10n="U"
@@ -312,7 +312,7 @@ oldref="109">Example</paragraph>
<section id="percentile">
<bookmark xml-lang="en-US" branch="index" id="bm_id3153100"><bookmark_value>PERCENTILE function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_QUANTIL" id="bm_id3155394" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_QUANTIL" id="bm_id3155394" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3153100" role="heading" level="2" l10n="U"
oldref="112">PERCENTILE</paragraph>
<paragraph xml-lang="en-US" id="par_id3154940" role="paragraph" 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 <item type="literal">Alpha</item> = 25%, the percentile means the first quartile; <item type="literal">Alpha</item> = 50% is the MEDIAN.</paragraph>
@@ -329,7 +329,7 @@ oldref="118">Example</paragraph>
<section id="percentrank">
<bookmark xml-lang="en-US" branch="index" id="bm_id3148807"><bookmark_value>PERCENTRANK function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_QUANTILSRANG" id="bm_id3154902" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_QUANTILSRANG" id="bm_id3154902" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3148807" role="heading" level="2" l10n="U"
oldref="121">PERCENTRANK</paragraph>
<paragraph xml-lang="en-US" id="par_id3153573" role="paragraph" l10n="U" oldref="122"><ahelp hid="HID_FUNC_QUANTILSRANG">Returns the percentage rank of a value in a sample.</ahelp></paragraph>
@@ -346,7 +346,7 @@ oldref="127">Example</paragraph>
<section id="quartile">
<bookmark xml-lang="en-US" branch="index" id="bm_id3166442"><bookmark_value>QUARTILE function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_QUARTILE" id="bm_id3150709" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_QUARTILE" id="bm_id3150709" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3166442" role="heading" level="2" l10n="U"
oldref="130">QUARTILE</paragraph>
<paragraph xml-lang="en-US" id="par_id3146958" role="paragraph" l10n="U" oldref="131"><ahelp hid="HID_FUNC_QUARTILE">Returns the quartile of a data set.</ahelp></paragraph>