[Libreoffice-commits] help.git: source/text

Olivier Hallot olivier.hallot at edx.srv.br
Fri Sep 5 08:48:47 PDT 2014


 source/text/scalc/01/04060184.xhp |   91 +++++++++++++++++++++++++++++++++++++-
 source/text/scalc/01/04060185.xhp |   48 +++++++++++++++++---
 2 files changed, 132 insertions(+), 7 deletions(-)

New commits:
commit 1d8274ccfc08372155cef732498580e770eb412a
Author: Olivier Hallot <olivier.hallot at edx.srv.br>
Date:   Wed Aug 27 11:28:16 2014 -0300

    Fix fdo#80435: help pages for Calc new functions
    
    Quartile, percentile, percentrank, rank.
    
    Change-Id: I0cbc75a1f915898839223ab72be471926ab025c4
    Reviewed-on: https://gerrit.libreoffice.org/11142
    Reviewed-by: Caolán McNamara <caolanm at redhat.com>
    Tested-by: Caolán McNamara <caolanm at redhat.com>

diff --git a/source/text/scalc/01/04060184.xhp b/source/text/scalc/01/04060184.xhp
index 6dcdeac..a52a06f 100644
--- a/source/text/scalc/01/04060184.xhp
+++ b/source/text/scalc/01/04060184.xhp
@@ -1,6 +1,6 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <helpdocument version="1.0">
-	
+
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -19,7 +19,7 @@
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
 
-	
+
 <meta>
 <topic id="textscalc0104060184xml" indexer="include">
 <title xml-lang="en-US" id="tit">Statistical Functions Part Four</title>
@@ -416,6 +416,35 @@ oldref="118">Example</paragraph>
 <paragraph xml-lang="en-US" id="par_id3159147" role="paragraph" l10n="CHG" oldref="119">
 <item type="input">=PERCENTILE(A1:A50;0.1)</item> represents the value in the data set, which equals 10% of the total data scale in A1:A50.</paragraph>
 </section>
+<section id="percentileexc">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2853100"><bookmark_value>PERCENTILE.EXC function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/HID_FUNC_PERCENTILE_EXC" id="bm_id2855394" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2853100" role="heading" level="2" l10n="U" oldref="112">PERCENTILE.EXC</paragraph>
+<paragraph xml-lang="en-US" id="par_id2854940" role="paragraph" l10n="U" oldref="113"><ahelp hid="HID_FUNC_PERCENTILE_EXC">Returns the <item type="literal">Alpha</item>'th percentile of a supplied range of values for a given value of <item type="literal">Alpha</item>, within the range 0 to 1 (exclusive).</ahelp> A percentile returns the scale value for a data series which goes from the smallest (<item type="literal">Alpha=0</item>) to the largest value (<item type="literal">Alpha=1</item>) 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>
+<paragraph xml-lang="en-US" id="par_id2754940" role="warning" l10n="U" oldref="113">If <item type="literal">Alpha</item> is not a multiple of <item type="literal">1/(n+1)</item>, (where n is the number of values in the supplied array), the function interpolates between the values in the supplied array, to calculate the percentile value. However, if <item type="literal">Alpha</item> is less than <item type="literal">1/(n+1)</item> or <item type="literal">Alpha</item> is greater than <item type="literal">n/(n+1)</item>, the function is unable to interpolate, and so returns an error.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2653976" role="note">The difference between <item type="input">PERCENTILE.INC</item> and <item type="input">PERCENTILE.EXC</item> is that, in the <item type="input">PERCENTILE.INC</item> function the value of alpha is is within the range 0 to 1 inclusive, and in the <item type="input">PERCENTILE.EXC</item> function, the value of alpha is within the range 0 to 1 exclusive.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2850531" role="heading" level="3" l10n="U" oldref="114">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id2848813" role="code" l10n="U" oldref="115">PERCENTILE.EXC(Data; Alpha)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2853054" role="paragraph" l10n="U" oldref="116"><emph>Data</emph> represents the array of data.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2854212" role="paragraph" l10n="U" oldref="117"><emph>Alpha</emph> represents the percentage of the scale between 0 and 1.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2854290" role="heading" level="3" l10n="U" oldref="118">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id2859147" role="paragraph" l10n="CHG" oldref="119"><item type="input">=PERCENTILE.EXC(A1:A50;10%)</item> represents the value in the data set, which equals 10% of the total data scale in A1:A50.</paragraph>
+</section>
+<section id="percentileinc">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2953100"><bookmark_value>PERCENTILE.INC function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/HID_FUNC_PERCENTILE_INC" id="bm_id2955394" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2953100" role="heading" level="2" l10n="U" oldref="112">PERCENTILE.INC</paragraph>
+<paragraph xml-lang="en-US" id="par_id2954940" role="paragraph" l10n="U" oldref="113"><ahelp hid="HID_FUNC_PERCENTILE_INC">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>
+<paragraph xml-lang="en-US" id="par_id2753976" role="note">The difference between <item type="input">PERCENTILE.INC</item> and <item type="input">PERCENTILE.EXC</item> is that, in the <item type="input">PERCENTILE.INC</item> function the value of alpha is is within the range 0 to 1 inclusive, and in the <item type="input">PERCENTILE.EXC</item> function, the value of alpha is within the range 0 to 1 exclusive.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2950531" role="heading" level="3" l10n="U" oldref="114">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id2948813" role="code" l10n="U" oldref="115">PERCENTILE.INC(Data; Alpha)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2953054" role="paragraph" l10n="U" oldref="116"><emph>Data</emph> represents the array of data.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2954212" role="paragraph" l10n="U" oldref="117"><emph>Alpha</emph> represents the percentage of the scale between 0 and 1.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2954290" role="heading" level="3" l10n="U" oldref="118">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id2959147" role="paragraph" l10n="CHG" oldref="119"><item type="input">=PERCENTILE.INC(A1:A50;0.1)</item> represents the value in the data set, which equals 10% of the total data scale in A1:A50.</paragraph>
+</section>
 <section id="percentrank">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3148807"><bookmark_value>PERCENTRANK function</bookmark_value>
 </bookmark>
@@ -433,6 +462,34 @@ oldref="127">Example</paragraph>
 <paragraph xml-lang="en-US" id="par_id3149163" role="paragraph" l10n="U" oldref="128">
 <item type="input">=PERCENTRANK(A1:A50;50)</item> returns the percentage rank of the value 50 from the total range of all values found in A1:A50. If 50 falls outside the total range, an error message will appear.</paragraph>
 </section>
+<section id="percentrankexc">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2848807"><bookmark_value>PERCENTRANK.EXC function</bookmark_value></bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_PERCENTRANK_EXC" id="bm_id2854902" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2848807" role="heading" level="2" l10n="U" oldref="121">PERCENTRANK.EXC</paragraph>
+<paragraph xml-lang="en-US" id="par_id2853573" role="paragraph" l10n="U" oldref="122"><ahelp hid="HID_FUNC_PERCENTRANK_EXC"> Returns the relative position, between 0 and 1 (exclusive), of a specified value within a supplied array.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="par_id2553976" role="note">The difference between <item type="input">PERCENTRANK.INC</item> and <item type="input">PERCENTRANK.EXC</item> is that <item type="input">PERCENTRANK.INC</item> calculates a value in the range 0 to 1 inclusive, whereas the <item type="input">PERCENTRANK.EXC</item> function calculates a value in the range 0 to 1 exclusive.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2847512" role="heading" level="3" l10n="U" oldref="123">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id2847238" role="code" l10n="U" oldref="124">PERCENTRANK.EXC(Data; Value; Significance)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2854266" role="paragraph" l10n="U" oldref="125"><emph>Data</emph> represents the array of data in the sample.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2848475" role="paragraph" l10n="U" oldref="126"><emph>Value</emph> represents the value whose percentile rank must be determined.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2748475" role="paragraph" l10n="U" oldref="126"><emph>Significance</emph> An optional argument that specifies the number of significant digits that the returned percentage value is rounded to.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2855364" role="heading" level="3" l10n="U" oldref="127">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id2849163" role="paragraph" l10n="U" oldref="128"><item type="input">=PERCENTRANK.EXC(A1:A50;50)</item> returns the percentage rank of the value 50 from the total range of all values found in A1:A50. If 50 falls outside the total range, an error message will appear.</paragraph>
+</section>
+<section id="percentrankinc">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2948807"><bookmark_value>PERCENTRANK.INC function</bookmark_value></bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_PERCENTRANK_INC" id="bm_id2954902" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2948807" role="heading" level="2" l10n="U" oldref="121">PERCENTRANK.INC</paragraph>
+<paragraph xml-lang="en-US" id="par_id2953573" role="paragraph" l10n="U" oldref="122"><ahelp hid="HID_FUNC_PERCENTRANK_INC">Returns the relative position, between 0 and 1 (inclusive), of a specified value within a supplied array.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="par_id2453976" role="note">The difference between <item type="input">PERCENTRANK.INC</item> and <item type="input">PERCENTRANK.EXC</item> is that <item type="input">PERCENTRANK.INC</item> calculates a value in the range 0 to 1 inclusive, whereas the <item type="input">PERCENTRANK.EXC</item> function calculates a value in the range 0 to 1 exclusive.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2947512" role="heading" level="3" l10n="U" oldref="123">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id2947238" role="code" l10n="U" oldref="124">PERCENTRANK.INC(Data; Value; Significance)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2954266" role="paragraph" l10n="U" oldref="125"><emph>Data</emph> represents the array of data in the sample.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2948475" role="paragraph" l10n="U" oldref="126"><emph>Value</emph> represents the value whose percentile rank must be determined.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2648475" role="paragraph" l10n="U" oldref="126"><emph>Significance</emph> An optional argument that specifies the number of significant digits that the returned percentage value is rounded to.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2955364" role="heading" level="3" l10n="U" oldref="127">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id2949163" role="paragraph" l10n="U" oldref="128"><item type="input">=PERCENTRANK.INC(A1:A50;50)</item> returns the percentage rank of the value 50 from the total range of all values found in A1:A50. If 50 falls outside the total range, an error message will appear.</paragraph>
+</section>
 <section id="quartile">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3166442"><bookmark_value>QUARTILE function</bookmark_value>
 </bookmark>
@@ -450,6 +507,36 @@ oldref="136">Example</paragraph>
 <paragraph xml-lang="en-US" id="par_id3159276" role="paragraph" l10n="CHG" oldref="137">
 <item type="input">=QUARTILE(A1:A50;2)</item> returns the value of which 50% of the scale corresponds to the lowest to highest values in the range A1:A50.</paragraph>
 </section>
+<section id="quartileexc">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2866442"><bookmark_value>QUARTILE.EXC function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_QUARTILE_EXC" id="bm_id2950709" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2866442" role="heading" level="2" l10n="U" oldref="130">QUARTILE.EXC</paragraph>
+<paragraph xml-lang="en-US" id="par_id2846958" role="paragraph" l10n="U" oldref="131"><ahelp hid="HID_FUNC_QUARTILE_EXC">Returns a requested quartile of a supplied range of values, based on a percentile range of 0 to 1 exclusive.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="par_id2353976" role="note">The difference between <item type="input">QUARTILE.INC</item> and <item type="input">QUARTILE.EXC</item> is that the <item type="input">QUARTILE.INC</item> function bases its calculation on a percentile range of 0 to 1 inclusive, whereas the <item type="input">QUARTILE.EXC</item> function bases its calculation on a percentile range of 0 to 1 exclusive.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2852942" role="heading" level="3" l10n="U" oldref="132">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id2853684" role="code" l10n="U" oldref="133">QUARTILE.EXC(Data; Type)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2853387" role="paragraph" l10n="U" oldref="134"><emph>Data</emph> represents the range of data values for which you want to calculate the specified quartile.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2855589" role="paragraph" l10n="U" oldref="135"><emph>Type</emph> An integer between 1 and 3, representing the required quartile. (if type = 1 or 3, the supplied array must contain more than 2 values) </paragraph>
+<paragraph xml-lang="en-US" id="hd_id2849103" role="heading" level="3" l10n="U" oldref="136">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id2859276" role="paragraph" l10n="CHG" oldref="137">
+<item type="input">=QUARTILE.EXC(A1:A50;2)</item> returns the value of which 50% of the scale corresponds to the lowest to highest values in the range A1:A50.</paragraph>
+</section>
+<section id="quartileinc">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2966442"><bookmark_value>QUARTILE.INC function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_QUARTILE_INC" id="bm_id2950709" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2966442" role="heading" level="2" l10n="U" oldref="130">QUARTILE.INC</paragraph>
+<paragraph xml-lang="en-US" id="par_id2946958" role="paragraph" l10n="U" oldref="131"><ahelp hid="HID_FUNC_QUARTILE_INC">Returns the quartile of a data set.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="par_id2253976" role="note">The difference between <item type="input">QUARTILE.INC</item> and <item type="input">QUARTILE.EXC</item> is that the <item type="input">QUARTILE.INC</item> function bases its calculation on a percentile range of 0 to 1 inclusive, whereas the <item type="input">QUARTILE.EXC</item> function bases its calculation on a percentile range of 0 to 1 exclusive.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2952942" role="heading" level="3" l10n="U" oldref="132">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id2953684" role="code" l10n="U" oldref="133">QUARTILE.INC(Data; Type)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2953387" role="paragraph" l10n="U" oldref="134"><emph>Data</emph> represents the array of data in the sample.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2955589" role="paragraph" l10n="U" oldref="135"><emph>Type</emph> represents the type of quartile. (0 = MIN, 1 = 25%, 2 = 50% (MEDIAN), 3 = 75% and 4 = MAX.)</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2949103" role="heading" level="3" l10n="U" oldref="136">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id2959276" role="paragraph" l10n="CHG" oldref="137">
+<item type="input">=QUARTILE.INC(A1:A50;2)</item> returns the value of which 50% of the scale corresponds to the lowest to highest values in the range A1:A50.</paragraph>
+</section>
 </sort>
 <section id="relatedtopics">
 <embed href="text/scalc/01/04060100.xhp#drking"/>
diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp
index 902a0ba..a67b169 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"/>


More information about the Libreoffice-commits mailing list