diff options
author | Uwe Fischer <ufi@openoffice.org> | 2010-11-08 17:00:41 +0100 |
---|---|---|
committer | Uwe Fischer <ufi@openoffice.org> | 2010-11-08 17:00:41 +0100 |
commit | 113485813efba721e8e624e785bff201d266c271 (patch) | |
tree | 66f270e0d86e3246d1aa34ec6f306ffa62be5be2 /helpcontent2/source/text/scalc/01/04060184.xhp | |
parent | hcshared28: before first build (diff) | |
parent | CWS changehid: #i115137#: some conversions removed again (diff) | |
download | help-113485813efba721e8e624e785bff201d266c271.tar.gz help-113485813efba721e8e624e785bff201d266c271.zip |
hcshared28: merge with DEV300_m92
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060184.xhp')
-rw-r--r--[-rwxr-xr-x] | helpcontent2/source/text/scalc/01/04060184.xhp | 36 |
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> |