summaryrefslogtreecommitdiff
path: root/source
diff options
context:
space:
mode:
authorAndrea Gelmini <andrea.gelmini@gelma.net>2018-10-02 17:03:38 +0200
committerJulien Nabet <serval2412@yahoo.fr>2018-10-02 17:16:23 +0200
commit96b1b3768a3253d45b691a38cc0c02cfed5d20bd (patch)
treebf8081c70e4f3e08ef9ba4991e240a9a16d3e7f1 /source
parent84a86433f6be3d6fab810891382d62599d82bdf8 (diff)
Fix typos
Change-Id: Ic23908f65b62064ae99fa337a4f269d1b1ea1c09 Reviewed-on: https://gerrit.libreoffice.org/61254 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
Diffstat (limited to 'source')
-rw-r--r--source/text/scalc/01/04060184.xhp4
1 files changed, 2 insertions, 2 deletions
diff --git a/source/text/scalc/01/04060184.xhp b/source/text/scalc/01/04060184.xhp
index 94447dda06..6b03223313 100644
--- a/source/text/scalc/01/04060184.xhp
+++ b/source/text/scalc/01/04060184.xhp
@@ -386,7 +386,7 @@
<paragraph xml-lang="en-US" id="hd_id2853100" role="heading" level="2">PERCENTILE.EXC</paragraph>
<paragraph xml-lang="en-US" id="par_id2854940" role="paragraph"><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">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="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 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>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2848813" role="code">PERCENTILE.EXC(Data; Alpha)</paragraph>
<paragraph xml-lang="en-US" id="par_id2853054" role="paragraph"><emph>Data</emph> represents the array of data.</paragraph>
@@ -400,7 +400,7 @@
<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">PERCENTILE.INC</paragraph>
<paragraph xml-lang="en-US" id="par_id2954940" role="paragraph"><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="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 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>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2948813" role="code">PERCENTILE.INC(Data; Alpha)</paragraph>
<paragraph xml-lang="en-US" id="par_id2953054" role="paragraph"><emph>Data</emph> represents the array of data.</paragraph>