diff options
Diffstat (limited to 'source/text/scalc/01/04060185.xhp')
| -rw-r--r-- | source/text/scalc/01/04060185.xhp | 48 |
1 files changed, 43 insertions, 5 deletions
diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp index 902a0bad75..a67b1692bd 100644 --- a/source/text/scalc/01/04060185.xhp +++ b/source/text/scalc/01/04060185.xhp @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="UTF-8"?> <helpdocument version="1.0"> - + <!-- * This file is part of the LibreOffice project. * @@ -18,8 +18,8 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - - + + <meta> <topic id="textscalc0104060185xml" indexer="include"> <title xml-lang="en-US" id="tit">Statistical Functions Part Five</title> @@ -51,6 +51,44 @@ <paragraph xml-lang="en-US" id="par_id3155919" role="paragraph" l10n="U" oldref="10"> <item type="input">=RANK(A10;A1:A50)</item> returns the ranking of the value in A10 in value range A1:A50. If <item type="literal">Value</item> does not exist within the range an error message is displayed.</paragraph> </section> +<section id="rankavg"> +<bookmark xml-lang="en-US" branch="index" id="bm_id2955071"> + <bookmark_value>RANK.AVG function</bookmark_value> + <bookmark_value>numbers;determining ranks</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RANK_AVG" id="bm_id2946778" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id2955071" role="heading" level="2" l10n="U" oldref="2">RANK.AVG</paragraph> +<paragraph xml-lang="en-US" id="par_id2953976" role="paragraph" l10n="U" oldref="3"><ahelp hid="HID_FUNC_RANK_AVG">Returns the statistical rank of a given value, within a supplied array of values.</ahelp> If there are duplicate values in the list, the average rank is returned.</paragraph> +<paragraph xml-lang="en-US" id="par_id2653976" role="note">The difference between <item type="input">RANK.AVG</item> and <item type="input">RANK.EQ</item> occurs when there are duplicates in the list of values. The <item type="input">RANK.EQ</item> function returns the lower rank, whereas the <item type="input">RANK.AVG</item> function returns the average rank.</paragraph> +<paragraph xml-lang="en-US" id="hd_id2959206" role="heading" level="3" l10n="U" oldref="4">Syntax</paragraph> +<paragraph xml-lang="en-US" id="par_id2953250" role="code" l10n="U" oldref="5">RANK.AVG(Value; Data; Type)</paragraph> +<paragraph xml-lang="en-US" id="par_id2954543" role="paragraph" l10n="U" oldref="6"><emph>Value</emph> is the value, whose rank is to be determined.</paragraph> +<paragraph xml-lang="en-US" id="par_id2949130" role="paragraph" l10n="U" oldref="7"><emph>Data</emph> is the array or range of data in the sample.</paragraph> +<paragraph xml-lang="en-US" id="par_id2950215" role="paragraph" l10n="CHG" oldref="8"><emph>Type</emph> (optional) is the sequence order.</paragraph> +<paragraph xml-lang="en-US" id="par_id0305398" role="paragraph" l10n="NEW">Type = 0 means descending from the last item of the array to the first (this is the default), </paragraph> +<paragraph xml-lang="en-US" id="par_id0996948" role="paragraph" l10n="NEW">Type = 1 means ascending from the first item of the range to the last.</paragraph> +<paragraph xml-lang="en-US" id="hd_id2943223" role="heading" level="3" l10n="U" oldref="9">Example</paragraph> +<paragraph xml-lang="en-US" id="par_id2955919" role="paragraph" l10n="U" oldref="10"><item type="input">=RANK.AVG(A10;A1:A50)</item> returns the ranking of the value in A10 in value range A1:A50. If <item type="literal">Value</item> does not exist within the range an error message is displayed.</paragraph> +</section> +<section id="rankeq"> +<bookmark xml-lang="en-US" branch="index" id="bm_id2855071"> + <bookmark_value>RANK.EQ function</bookmark_value> + <bookmark_value>numbers;determining ranks</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RANK_EQ" id="bm_id2846778" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id2855071" role="heading" level="2" l10n="U" oldref="2">RANK.AVG</paragraph> +<paragraph xml-lang="en-US" id="par_id2853976" role="paragraph" l10n="U" oldref="3"><ahelp hid="HID_FUNC_RANK_EQ">Returns the statistical rank of a given value, within a supplied array of values.</ahelp> If there are duplicate values in the list, these are given the same rank.</paragraph> +<paragraph xml-lang="en-US" id="par_id2753976" role="note">The difference between <item type="input">RANK.AVG</item> and <item type="input">RANK.EQ</item> occurs when there are duplicates in the list of values. The <item type="input">RANK.EQ</item> function returns the lower rank, whereas the <item type="input">RANK.AVG</item> function returns the average rank.</paragraph> +<paragraph xml-lang="en-US" id="hd_id2859206" role="heading" level="3" l10n="U" oldref="4">Syntax</paragraph> +<paragraph xml-lang="en-US" id="par_id2853250" role="code" l10n="U" oldref="5">RANK.EQ(Value; Data; Type)</paragraph> +<paragraph xml-lang="en-US" id="par_id2854543" role="paragraph" l10n="U" oldref="6"><emph>Value</emph> is the value, whose rank is to be determined.</paragraph> +<paragraph xml-lang="en-US" id="par_id2849130" role="paragraph" l10n="U" oldref="7"><emph>Data</emph> is the array or range of data in the sample.</paragraph> +<paragraph xml-lang="en-US" id="par_id2850215" role="paragraph" l10n="CHG" oldref="8"><emph>Type</emph> (optional) is the sequence order.</paragraph> +<paragraph xml-lang="en-US" id="par_id89305398" role="paragraph" l10n="NEW">Type = 0 means descending from the last item of the array to the first (this is the default), </paragraph> +<paragraph xml-lang="en-US" id="par_id89996948" role="paragraph" l10n="NEW">Type = 1 means ascending from the first item of the range to the last.</paragraph> +<paragraph xml-lang="en-US" id="hd_id2843223" role="heading" level="3" l10n="U" oldref="9">Example</paragraph> +<paragraph xml-lang="en-US" id="par_id2855919" role="paragraph" l10n="U" oldref="10"><item type="input">=RANK.EQ(A10;A1:A50)</item> returns the ranking of the value in A10 in value range A1:A50. If <item type="literal">Value</item> does not exist within the range an error message is displayed.</paragraph> +</section> <section id="skew"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153556"><bookmark_value>SKEW function</bookmark_value> </bookmark> @@ -364,7 +402,7 @@ </section> <section id="tdotinv"> <bookmark xml-lang="en-US" branch="index" id="bm_id2949579"> - <bookmark_value>T.INV function</bookmark_value> + <bookmark_value>T.INV function</bookmark_value> <bookmark_value>two tailed inverse of t-distribution</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TINV_MS" id="bm_id2953155" localize="false"/> @@ -379,7 +417,7 @@ </section> <section id="tdotinvdot2t"> <bookmark xml-lang="en-US" branch="index" id="bm_id2849579"> - <bookmark_value>T.INV.2T function</bookmark_value> + <bookmark_value>T.INV.2T function</bookmark_value> <bookmark_value>inverse of two tailed t-distribution</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TINV_2T" id="bm_id2853155" localize="false"/> |