summaryrefslogtreecommitdiff
path: root/source
diff options
context:
space:
mode:
authorSophia Schröder <sophia.schroeder@libreoffice.org>2018-04-23 12:58:00 +0100
committerOlivier Hallot <olivier.hallot@libreoffice.org>2018-04-23 23:10:09 +0200
commit3db795172c8031ac1a88967f28858812a2d35089 (patch)
tree2804f2c8d15cd9ddad44604079a1ac813c14de59 /source
parent41c6294398f9a3a8ba7c3c66abd4cc14dbbcecd1 (diff)
Improve formatting in help text.
Change-Id: I873128ed6353caf37f063a87361bd0a6f7c79f96 Reviewed-on: https://gerrit.libreoffice.org/53321 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source')
-rw-r--r--source/text/scalc/01/04060109.xhp12
-rw-r--r--source/text/scalc/01/04060119.xhp10
-rw-r--r--source/text/scalc/01/04060181.xhp22
-rw-r--r--source/text/scalc/01/04060182.xhp12
-rw-r--r--source/text/scalc/01/04060183.xhp10
-rw-r--r--source/text/scalc/01/04060184.xhp44
-rw-r--r--source/text/scalc/01/04060185.xhp66
-rw-r--r--source/text/scalc/01/func_skewp.xhp7
8 files changed, 91 insertions, 92 deletions
diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp
index 95e3d87911..caa0431b56 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -33,7 +33,7 @@
</bookmark>
<paragraph xml-lang="en-US" id="hd_id3148522" role="heading" level="1">Spreadsheet Functions</paragraph>
<paragraph xml-lang="en-US" id="par_id3144508" role="paragraph"><variable id="tabelletext">This section contains descriptions of the <emph>Spreadsheet</emph> functions together with an example.
-</variable></paragraph>
+ </variable></paragraph>
<section id="howtoget">
<embed href="text/scalc/00/00000404.xhp#efefft"/>
</section>
@@ -381,7 +381,7 @@
<item type="input">=OFFSET(B2:C3;1;0;3;4)</item> returns a reference to B2:C3 moved down by one row resized to 3 rows and 4 columns (B3:E5).</paragraph>
<paragraph xml-lang="en-US" id="par_id3153739" role="paragraph">
<item type="input">=SUM(OFFSET(A1;2;2;5;6))</item> determines the total of the area that starts in cell C3 and has a height of 5 rows and a width of 6 columns (area=C3:H7).</paragraph>
- <paragraph xml-lang="en-US" id="par_id3153740" role="note">If the width or height is included, the OFFSET function returns a range and thus must be entered as an <link href="text/scalc/01/04060107.xhp">array formula</link>. If both the width and height are missing, a cell reference is returned.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3153740" role="note">If the width or height is included, the OFFSET function returns a range and thus must be entered as an <link href="text/scalc/01/04060107.xhp">array formula</link>. If both the width and height are missing, a cell reference is returned.</paragraph>
</section>
<section id="Section14">
<bookmark xml-lang="en-US" branch="index" id="bm_id3159273"><bookmark_value>LOOKUP function</bookmark_value>
@@ -409,7 +409,7 @@
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VORLAGE" id="bm_id3154342" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3149425" role="heading" level="2">STYLE</paragraph>
- <paragraph xml-lang="en-US" id="par_id3150826" role="paragraph"><ahelp hid="HID_FUNC_VORLAGE">Applies a style to the cell containing the formula.</ahelp> After a set amount of time, another style can be applied. This function always returns the value 0, allowing you to add it to another function without changing the value. Together with the CURRENT function you can apply a color to a cell depending on the value. For example: =...+STYLE(IF(CURRENT()&gt;3;"red";"green")) applies the style "red" to the cell if the value is greater than 3, otherwise the style "green" is applied. Both cell formats have to be defined beforehand.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3150826" role="paragraph"><ahelp hid="HID_FUNC_VORLAGE">Applies a style to the cell containing the formula.</ahelp> After a set amount of time, another style can be applied. This function always returns the value 0, allowing you to add it to another function without changing the value. Together with the CURRENT function you can apply a color to a cell depending on the value. For example: =...+STYLE(IF(CURRENT()&gt;3;"red";"green")) applies the style "red" to the cell if the value is greater than 3, otherwise the style "green" is applied. Both cell formats, "red" and "green" have to be defined beforehand.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3145373" role="heading" level="3">Syntax</paragraph>
<paragraph xml-lang="en-US" id="par_id3149302" role="code">STYLE("Style"; Time; "Style2")</paragraph>
<paragraph xml-lang="en-US" id="par_id3150596" role="paragraph">
@@ -424,7 +424,7 @@
<paragraph xml-lang="en-US" id="hd_id3159254" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3151374" role="paragraph">
<item type="input">=STYLE("Invisible";60;"Default")</item> formats the cell in transparent format for 60 seconds after the document was recalculated or loaded, then the Default format is assigned. Both cell formats have to be defined beforehand.</paragraph>
- <paragraph xml-lang="en-US" id="par_id8056886" role="paragraph">Since STYLE() has a numeric return value of zero, this return value gets appended to a string. This can be avoided using T() as in the following example </paragraph>
+ <paragraph xml-lang="en-US" id="par_id8056886" role="paragraph">Since STYLE() has a numeric return value of zero, this return value gets appended to a string. This can be avoided using T() as in the following example:</paragraph>
<paragraph xml-lang="en-US" id="par_id3668935" role="paragraph">
<item type="input">="Text"&amp;T(STYLE("myStyle"))</item>
</paragraph>
@@ -441,7 +441,7 @@
<paragraph xml-lang="en-US" id="par_id3144755" role="paragraph">
<emph>Index</emph> is a reference or number between 1 and 30 indicating which value is to be taken from the list.</paragraph>
<paragraph xml-lang="en-US" id="par_id3149939" role="paragraph">
- <emph>Value1...Value30</emph> is the list of values entered as a reference to a cell or as individual values.</paragraph>
+ <emph>Value1, Value2, ..., Value30</emph> is the list of values entered as a reference to a cell or as individual values.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3151253" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3150625" role="paragraph">
<item type="input">=CHOOSE(A1;B1;B2;B3;"Today";"Yesterday";"Tomorrow")</item>, for example, returns the contents of cell B2 for A1 = 2; for A1 = 4, the function returns the text "Today".</paragraph>
@@ -527,7 +527,7 @@
<paragraph xml-lang="en-US" id="par_id8859523" role="paragraph">
<item type="input">=HYPERLINK("#Sheet1.A1";"Go to top")</item> displays the text Go to top and jumps to cell Sheet1.A1 in this document.</paragraph>
<paragraph xml-lang="en-US" id="par_id2958769" role="paragraph">
- <item type="input">=HYPERLINK("file:///C:/writer.odt#Specification";"Go to Writer bookmark")</item>displays the text Go to Writer bookmark, loads the specified text document and jumps to bookmark "Specification".</paragraph>
+ <item type="input">=HYPERLINK("file:///C:/writer.odt#Specification";"Go to Writer bookmark")</item> displays the text Go to Writer bookmark, loads the specified text document and jumps to bookmark "Specification".</paragraph>
</section>
<section id="getpivotdata">
<bookmark xml-lang="en-US" branch="index" id="bm_id7682424"><bookmark_value>GETPIVOTDATA function</bookmark_value>
diff --git a/source/text/scalc/01/04060119.xhp b/source/text/scalc/01/04060119.xhp
index fca7a50715..818c386388 100644
--- a/source/text/scalc/01/04060119.xhp
+++ b/source/text/scalc/01/04060119.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="textscalc0104060119xml" indexer="include">
<title id="tit" xml-lang="en-US">Financial Functions Part Two</title>
@@ -332,11 +332,11 @@
<paragraph id="par_idN111381" role="paragraph" xml-lang="en-US">If the payments take place at irregular intervals, use the <link href="text/scalc/01/04060118.xhp#xnpv" name="XNPV">XNPV</link> function.</paragraph>
<paragraph role="heading" id="hd_id3149937" xml-lang="en-US" level="3">Syntax</paragraph>
-<paragraph role="code" id="par_id3153321" xml-lang="en-US">NPV(Rate; Value1; Value2; ...)</paragraph>
+<paragraph role="code" id="par_id3153321" xml-lang="en-US">NPV(Rate; Value1; Value2; ...; Value30)</paragraph>
<paragraph role="paragraph" id="par_id3150630" xml-lang="en-US">
<emph>Rate</emph> is the discount rate for a period.</paragraph>
<paragraph role="paragraph" id="par_id3150427" xml-lang="en-US">
-<emph>Value1;...</emph> are up to 30 values, which represent deposits or withdrawals.</paragraph>
+<emph>Value1, Value2, ..., Value30</emph> are up to 30 values, which represent deposits or withdrawals.</paragraph>
<paragraph role="heading" id="hd_id3153538" xml-lang="en-US" level="3">Example</paragraph>
<paragraph role="paragraph" id="par_id3154800" xml-lang="en-US">What is the net present value of periodic payments of 10, 20 and 30 currency units with a discount rate of 8.75%. At time zero the costs were paid as -40 currency units.</paragraph>
<paragraph role="paragraph" id="par_id3143270" xml-lang="en-US">
diff --git a/source/text/scalc/01/04060181.xhp b/source/text/scalc/01/04060181.xhp
index ba890e71da..1909e4b56e 100644
--- a/source/text/scalc/01/04060181.xhp
+++ b/source/text/scalc/01/04060181.xhp
@@ -66,8 +66,8 @@
<paragraph id="par_id3150700" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ANZAHL">Counts how many numbers are in the list of arguments.</ahelp> Text entries are ignored.</paragraph>
<paragraph id="hd_id3153930" role="heading" level="3" xml-lang="en-US">Syntax</paragraph>
-<paragraph id="par_id3148585" role="code" xml-lang="en-US">COUNT(Value1; Value2; ... Value30)</paragraph>
-<paragraph id="par_id3155827" role="paragraph" xml-lang="en-US"><emph>Value1; Value2, ...</emph> are 1 to 30 values or ranges representing the values to be counted.</paragraph>
+<paragraph id="par_id3148585" role="code" xml-lang="en-US">COUNT(Value1; Value2; ...; Value30)</paragraph>
+<paragraph id="par_id3155827" role="paragraph" xml-lang="en-US"><emph>Value1; Value2, ..., Value30</emph> are 1 to 30 values or ranges representing the values to be counted.</paragraph>
<paragraph id="hd_id3149254" role="heading" level="3" xml-lang="en-US">Example</paragraph>
<paragraph id="par_id3149953" role="paragraph" xml-lang="en-US">The entries 2, 4, 6 and eight in the Value 1-4 fields are to be counted.</paragraph>
@@ -86,8 +86,8 @@
<paragraph id="par_id3150142" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ANZAHL2">Counts how many values are in the list of arguments.</ahelp> Text entries are also counted, even when they contain an empty string of length 0. If an argument is an array or reference, empty cells within the array or reference are ignored.<comment>UFI: fix to #i35888#</comment></paragraph>
<paragraph id="hd_id3148573" role="heading" level="3" xml-lang="en-US">Syntax</paragraph>
-<paragraph id="par_id3153111" role="code" xml-lang="en-US">COUNTA(Value1; Value2; ... Value30)</paragraph>
-<paragraph id="par_id3150001" role="paragraph" xml-lang="en-US"><emph>Value1; Value2, ...</emph> are 1 to 30 arguments representing the values to be counted.</paragraph>
+<paragraph id="par_id3153111" role="code" xml-lang="en-US">COUNTA(Value1; Value2; ...; Value30)</paragraph>
+<paragraph id="par_id3150001" role="paragraph" xml-lang="en-US"><emph>Value1; Value2, ..., Value30</emph> are 1 to 30 arguments representing the values to be counted.</paragraph>
<paragraph id="hd_id3150334" role="heading" level="3" xml-lang="en-US">Example</paragraph>
<paragraph id="par_id3154508" role="paragraph" xml-lang="en-US">The entries 2, 4, 6 and eight in the Value 1-4 fields are to be counted.</paragraph>
@@ -133,11 +133,11 @@
<paragraph id="hd_id3165037" role="heading" level="3" xml-lang="en-US">Example</paragraph>
<paragraph id="par_id3166505" role="paragraph" xml-lang="en-US">A1:A10 is a cell range containing the numbers <item type="input">2000</item> to <item type="input">2009</item>. Cell B1 contains the number <item type="input">2006</item>. In cell B2, you enter a formula:</paragraph>
-<paragraph id="par_id3581652" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIF(A1:A10;2006)</item> - this returns 1</paragraph>
-<paragraph id="par_id708639" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIF(A1:A10;B1)</item> - this returns 1</paragraph>
-<paragraph id="par_id5169225" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIF(A1:A10;"&gt;=2006") </item>- this returns 4</paragraph>
-<paragraph id="par_id2118594" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIF(A1:A10;"&lt;"&amp;B1)</item> - when B1 contains <item type="input">2006</item>, this returns 6</paragraph>
-<paragraph id="par_id166020" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIF(A1:A10;C2)</item> where cell C2 contains the text <item type="input">&gt;2006</item> counts the number of cells in the range A1:A10 which are &gt;2006</paragraph>
+<paragraph id="par_id3581652" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIF(A1:A10;2006)</item> - this returns 1.</paragraph>
+<paragraph id="par_id708639" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIF(A1:A10;B1)</item> - this returns 1.</paragraph>
+<paragraph id="par_id5169225" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIF(A1:A10;"&gt;=2006")</item> - this returns 4.</paragraph>
+<paragraph id="par_id2118594" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIF(A1:A10;"&lt;"&amp;B1)</item> - when B1 contains <item type="input">2006</item>, this returns 6.</paragraph>
+<paragraph id="par_id166020" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIF(A1:A10;C2)</item> where cell C2 contains the text <item type="input">&gt;2006</item> counts the number of cells in the range A1:A10 which are &gt;2006.</paragraph>
<paragraph id="par_id6386913" role="paragraph" xml-lang="en-US">To count only negative numbers: <item type="input">=COUNTIF(A1:A10;"&lt;0")</item></paragraph>
</section>
@@ -261,7 +261,7 @@
<paragraph id="par_idN10AB3" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph>
<paragraph id="hd_id3145649" role="heading" level="3" xml-lang="en-US">Example</paragraph>
-<paragraph id="par_id3156118" role="paragraph" xml-lang="en-US"><item type="input">=BETADIST(0.75;3;4)</item> returns the value 0.96</paragraph>
+<paragraph id="par_id3156118" role="paragraph" xml-lang="en-US"><item type="input">=BETADIST(0.75;3;4)</item> returns the value 0.96.</paragraph>
</section>
<section id="betadotdist">
@@ -675,7 +675,7 @@
<paragraph id="hd_id2846787" role="heading" level="3" xml-lang="en-US">Example</paragraph>
<paragraph id="par_id2845774" role="paragraph" xml-lang="en-US"><item type="input">=CHISQ.DIST(3; 2; 0) </item>equals 0.1115650801, the probability density function with 2 degrees of freedom, at x = 3.</paragraph>
-<paragraph id="par_id2745774" role="paragraph" xml-lang="en-US"><item type="input">=CHISQ.DIST(3; 2; 1) </item>equals 0.7768698399, the cumulative chi-square distribution with 2 degrees of freedom, at the value x = 3</paragraph>
+<paragraph id="par_id2745774" role="paragraph" xml-lang="en-US"><item type="input">=CHISQ.DIST(3; 2; 1) </item>equals 0.7768698399, the cumulative chi-square distribution with 2 degrees of freedom, at the value x = 3.</paragraph>
</section>
<section id="chisqdotdistdotrt">
diff --git a/source/text/scalc/01/04060182.xhp b/source/text/scalc/01/04060182.xhp
index faa2821e0c..f94205c758 100644
--- a/source/text/scalc/01/04060182.xhp
+++ b/source/text/scalc/01/04060182.xhp
@@ -283,7 +283,7 @@
<paragraph xml-lang="en-US" id="par_id3145295" role="paragraph">
<emph>Alpha</emph> is the parameter Alpha of the Gamma distribution.</paragraph>
<paragraph xml-lang="en-US" id="par_id3151015" role="paragraph">
- <emph>Beta</emph> is the parameter Beta of the Gamma distribution</paragraph>
+ <emph>Beta</emph> is the parameter Beta of the Gamma distribution.</paragraph>
<paragraph xml-lang="en-US" id="par_id3157972" role="paragraph">
<emph>C</emph> (optional) = 0 or False calculates the density function <emph>C</emph> = 1 or True calculates the distribution.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3149535" role="heading" level="3">Example</paragraph>
@@ -303,7 +303,7 @@
<paragraph id="par_id240620142238475" role="code" xml-lang="en-US">GAMMA.DIST(Number; Alpha; Beta; C)</paragraph>
<paragraph id="par_id2406201422385134" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the value for which the Gamma distribution is to be calculated.</paragraph>
<paragraph id="par_id2406201422385590" role="paragraph" xml-lang="en-US"><emph>Alpha</emph> is the parameter Alpha of the Gamma distribution.</paragraph>
-<paragraph id="par_id2406201422390458" role="paragraph" xml-lang="en-US"><emph>Beta</emph> is the parameter Beta of the Gamma distribution</paragraph>
+<paragraph id="par_id2406201422390458" role="paragraph" xml-lang="en-US"><emph>Beta</emph> is the parameter Beta of the Gamma distribution.</paragraph>
<paragraph id="par_id2406201422391058" role="paragraph" xml-lang="en-US"><emph>C</emph> (optional) = 0 or False calculates the density function <emph>C</emph> = 1 or True calculates the distribution.</paragraph>
<paragraph id="hd_id2406201422391870" role="heading" xml-lang="en-US" level="3">Example</paragraph>
<paragraph id="par_id2406201422392251" role="paragraph" xml-lang="en-US"><item type="input">=GAMMA.DIST(2;1;1;1)</item> yields 0.86.</paragraph>
@@ -334,9 +334,9 @@
<paragraph xml-lang="en-US" id="hd_id3148425" role="heading" level="2">GEOMEAN</paragraph>
<paragraph xml-lang="en-US" id="par_id3156257" role="paragraph"><ahelp hid="HID_FUNC_GEOMITTEL">Returns the geometric mean of a sample.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id3147167" role="heading" level="3">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3153720" role="code">GEOMEAN(Number1; Number2; ...Number30)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3153720" role="code">GEOMEAN(Number1; Number2; ...; Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3152585" role="paragraph">
- <emph>Number1, Number2,...Number30</emph> are numeric arguments or ranges that represent a random sample.</paragraph>
+ <emph>Number1, Number2, ..., Number30</emph> are numeric arguments or ranges that represent a random sample.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3146146" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3149819" role="paragraph">
<item type="input">=GEOMEAN(23;46;69)</item> = 41.79. The geometric mean value of this random sample is therefore 41.79.</paragraph>
@@ -396,9 +396,9 @@
<paragraph xml-lang="en-US" id="hd_id3153623" role="heading" level="2">HARMEAN</paragraph>
<paragraph xml-lang="en-US" id="par_id3155102" role="paragraph"><ahelp hid="HID_FUNC_HARMITTEL">Returns the harmonic mean of a data set.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id3146900" role="heading" level="3">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3149287" role="code">HARMEAN(Number1; Number2; ...Number30)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3149287" role="code">HARMEAN(Number1; Number2; ...; Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3154303" role="paragraph">
- <emph>Number1,Number2,...Number30</emph> are up to 30 values or ranges, that can be used to calculate the harmonic mean.</paragraph>
+ <emph>Number1, Number2, ..., Number30</emph> are up to 30 values or ranges, that can be used to calculate the harmonic mean.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3159179" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3146093" role="paragraph">
<item type="input">=HARMEAN(23;46;69)</item> = 37.64. The harmonic mean of this random sample is thus 37.64</paragraph>
diff --git a/source/text/scalc/01/04060183.xhp b/source/text/scalc/01/04060183.xhp
index 73ce3af89d..1b725410a9 100644
--- a/source/text/scalc/01/04060183.xhp
+++ b/source/text/scalc/01/04060183.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="textscalc0104060183xml" indexer="include">
<title id="tit" xml-lang="en-US">Statistical Functions Part Three</title>
@@ -205,9 +205,9 @@
<paragraph role="heading" id="hd_id3155956" xml-lang="en-US" level="2">KURT</paragraph>
<paragraph role="paragraph" id="par_id3153108" xml-lang="en-US"><ahelp hid="HID_FUNC_KURT">Returns the kurtosis of a data set (at least 4 values required).</ahelp></paragraph>
<paragraph role="heading" id="hd_id3150334" xml-lang="en-US" level="3">Syntax</paragraph>
-<paragraph role="code" id="par_id3154508" xml-lang="en-US">KURT(Number1; Number2; ...Number30)</paragraph>
+<paragraph role="code" id="par_id3154508" xml-lang="en-US">KURT(Number1; Number2; ...; Number30)</paragraph>
<paragraph role="paragraph" id="par_id3145167" xml-lang="en-US">
-<emph>Number1,Number2,...Number30</emph> are numeric arguments or ranges representing a random sample of distribution.</paragraph>
+<emph>Number1, Number2, ..., Number30</emph> are numeric arguments or ranges representing a random sample of distribution.</paragraph>
<paragraph role="heading" id="hd_id3158000" xml-lang="en-US" level="3">Example</paragraph>
<paragraph role="paragraph" id="par_id3150016" xml-lang="en-US">
<item type="input">=KURT(A1;A2;A3;A4;A5;A6)</item>
diff --git a/source/text/scalc/01/04060184.xhp b/source/text/scalc/01/04060184.xhp
index 68c7f81d21..fd6dc0eceb 100644
--- a/source/text/scalc/01/04060184.xhp
+++ b/source/text/scalc/01/04060184.xhp
@@ -38,8 +38,8 @@
<paragraph xml-lang="en-US" id="par_id3153709" role="paragraph"><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">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>
<paragraph xml-lang="en-US" id="hd_id3154256" role="heading" level="3">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3147340" role="code">MAX(Number1; Number2; ...Number30)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149568" role="paragraph"><emph>Number1; Number2;...Number30</emph> are numerical values or ranges. </paragraph>
+<paragraph xml-lang="en-US" id="par_id3147340" role="code">MAX(Number1; Number2; ...; Number30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149568" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges. </paragraph>
<paragraph xml-lang="en-US" id="hd_id3153963" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3147343" role="paragraph">
<item type="input">=MAX(A1;A2;A3;50;100;200)</item> returns the largest value from the list.</paragraph>
@@ -54,8 +54,8 @@
<paragraph xml-lang="en-US" id="par_id3150363" role="paragraph"><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>
<paragraph xml-lang="en-US" id="par_id7689443" role="paragraph">The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3150516" role="heading" level="3">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3166431" role="code">MAXA(Value1; Value2; ... Value30)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150202" role="paragraph"><emph>Value1; Value2;...Value30</emph> are values or ranges. Text has the value of 0.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3166431" role="code">MAXA(Value1; Value2; ...; Value30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150202" role="paragraph"><emph>Value1; Value2;...; Value30</emph> are values or ranges. Text has the value of 0.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3156290" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3156446" role="paragraph">
<item type="input">=MAXA(A1;A2;A3;50;100;200;"Text")</item> returns the largest value from the list.</paragraph>
@@ -69,8 +69,8 @@
<paragraph xml-lang="en-US" id="hd_id3153820" role="heading" level="2">MEDIAN</paragraph>
<paragraph xml-lang="en-US" id="par_id3151241" role="paragraph"><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>
<paragraph xml-lang="en-US" id="hd_id3148871" role="heading" level="3">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3155264" role="code">MEDIAN(Number1; Number2; ...Number30)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150109" role="paragraph"><emph>Number1; Number2;...Number30</emph> are values or ranges, which represent a sample. Each number can also be replaced by a reference.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3155264" role="code">MEDIAN(Number1; Number2; ...; Number30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150109" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are values or ranges, which represent a sample. Each number can also be replaced by a reference.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3144506" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3145078" role="paragraph">for an odd number: <item type="input">=MEDIAN(1;5;9;20;21)</item> returns 9 as the median value.</paragraph>
<paragraph xml-lang="en-US" id="par_id3149126" role="paragraph">for an even number: <item type="input">=MEDIAN(1;5;9;20)</item> returns the average of the two middle values 5 and 9, thus 7.</paragraph>
@@ -83,8 +83,8 @@
<paragraph xml-lang="en-US" id="par_id3143222" role="paragraph"><ahelp hid="HID_FUNC_MIN">Returns the minimum value in a list of arguments.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id2301400" role="paragraph">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>
<paragraph xml-lang="en-US" id="hd_id3154651" role="heading" level="3">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3146964" role="code">MIN(Number1; Number2; ...Number30)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3153486" role="paragraph"><emph>Number1; Number2;...Number30</emph> are numerical values or ranges.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3146964" role="code">MIN(Number1; Number2; ...; Number30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153486" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3155523" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3154734" role="paragraph">
<item type="input">=MIN(A1:B100)</item> returns the smallest value in the list.</paragraph>
@@ -97,8 +97,8 @@
<paragraph xml-lang="en-US" id="par_id3147249" role="paragraph"><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>
<paragraph xml-lang="en-US" id="par_id4294564" role="paragraph">The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3150435" role="heading" level="3">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3153336" role="code">MINA(Value1; Value2; ... Value30)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3146098" role="paragraph"><emph>Value1; Value2;...Value30</emph> are values or ranges. Text has the value of 0.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153336" role="code">MINA(Value1; Value2; ...; Value30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3146098" role="paragraph"><emph>Value1, Value2, ..., Value30</emph> are values or ranges. Text has the value of 0.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3148743" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3147401" role="paragraph">
<item type="input">=MINA(1;"Text";20)</item> returns 0.</paragraph>
@@ -113,8 +113,8 @@
<paragraph role="heading" id="hd_id3166465" xml-lang="en-US" level="2">AVEDEV</paragraph>
<paragraph role="paragraph" id="par_id3150373" xml-lang="en-US"><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">Syntax</paragraph>
-<paragraph role="code" id="par_id3145636" xml-lang="en-US">AVEDEV(Number1; Number2; ...Number30)</paragraph>
-<paragraph role="paragraph" id="par_id3157871" xml-lang="en-US"><emph>Number1, Number2,...Number30</emph> are values or ranges that represent a sample. Each number can also be replaced by a reference.</paragraph>
+<paragraph role="code" id="par_id3145636" xml-lang="en-US">AVEDEV(Number1; Number2; ...; Number30)</paragraph>
+<paragraph role="paragraph" id="par_id3157871" xml-lang="en-US"><emph>Number1, Number2, ..., Number30</emph> are values or ranges that represent a sample. Each number can also be replaced by a reference.</paragraph>
<paragraph role="heading" id="hd_id3149725" xml-lang="en-US" level="3">Example</paragraph>
<paragraph role="paragraph" id="par_id3153122" xml-lang="en-US">
<item type="input">=AVEDEV(A1:A50)</item>
@@ -127,8 +127,8 @@
<paragraph xml-lang="en-US" id="hd_id3145824" role="heading" level="2">AVERAGE</paragraph>
<paragraph xml-lang="en-US" id="par_id3150482" role="paragraph"><ahelp hid="HID_FUNC_MITTELWERT">Returns the average of the arguments.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id3146943" role="heading" level="3">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3154679" role="code">AVERAGE(Number1; Number2; ...Number30)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150741" role="paragraph"><emph>Number1; Number2;...Number30</emph> are numerical values or ranges.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3154679" role="code">AVERAGE(Number1; Number2; ...; Number30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150741" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3153039" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3151232" role="paragraph">
<item type="input">=AVERAGE(A1:A50)</item>
@@ -141,8 +141,8 @@
<paragraph xml-lang="en-US" id="hd_id3148754" role="heading" level="2">AVERAGEA</paragraph>
<paragraph xml-lang="en-US" id="par_id3145138" role="paragraph"><ahelp hid="HID_FUNC_MITTELWERTA">Returns the average of the arguments. The value of a text is 0.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id3153326" role="heading" level="3">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149734" role="code">AVERAGEA(Value1; Value2; ... Value30)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3155260" role="paragraph"><emph>Value1; Value2;...Value30</emph> are values or ranges. Text has the value of 0.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149734" role="code">AVERAGEA(Value1; Value2; ...; Value30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3155260" role="paragraph"><emph>Value1, Value2, ..., Value30</emph> are values or ranges. Text has the value of 0.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3149504" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3150864" role="paragraph">
<item type="input">=AVERAGEA(A1:A50)</item>
@@ -165,8 +165,8 @@
<paragraph xml-lang="en-US" id="par_id3153085" role="paragraph"><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>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
<paragraph xml-lang="en-US" id="hd_id3153003" role="heading" level="3">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3155950" role="code">MODE(Number1; Number2; ...Number30)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150337" role="paragraph"><emph>Number1; Number2;...Number30</emph> are numerical values or ranges.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3155950" role="code">MODE(Number1; Number2; ...; Number30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150337" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3153571" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3153733" role="paragraph">
<item type="input">=MODE(A1:A50)</item>
@@ -181,8 +181,8 @@
<paragraph xml-lang="en-US" id="hd_id2953933" role="heading" level="2">MODE.SNGL</paragraph>
<paragraph xml-lang="en-US" id="par_id2953085" role="paragraph"><ahelp hid="HID_FUNC_MODAL_VALUE_MS">Returns the most frequently occurring, or repetitive, value in an array or range of data.</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>
<paragraph xml-lang="en-US" id="hd_id2953003" role="heading" level="3">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id2955950" role="code">MODE.SNGL(Number1; Number2; ...Number30)</paragraph>
-<paragraph xml-lang="en-US" id="par_id2950337" role="paragraph"><emph>Number1; Number2;...Number30</emph> are numerical values or ranges.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2955950" role="code">MODE.SNGL(Number1; Number2; ...; Number30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2950337" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges.</paragraph>
<paragraph xml-lang="en-US" id="par_id2963792" role="warning">If the data set contains no duplicate data points, MODE.SNGL returns the #VALUE! error value.</paragraph>
<paragraph xml-lang="en-US" id="hd_id2953571" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id2953733" role="paragraph"><item type="input">=MODE.SNGL(A1:A50)</item></paragraph>
@@ -195,8 +195,8 @@
<paragraph xml-lang="en-US" id="hd_id2853933" role="heading" level="2">MODE.MULT</paragraph>
<paragraph xml-lang="en-US" id="par_id2853085" role="paragraph"><ahelp hid="HID_FUNC_MODAL_VALUE_MULTI">Returns a vertical array of the statistical modes (the most frequently occurring values) within a list of supplied numbers.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id2853003" role="heading" level="3">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id2855950" role="code">MODE.MULT(Number1; Number2; ...Number30)</paragraph>
-<paragraph xml-lang="en-US" id="par_id2850337" role="paragraph"><emph>Number1; Number2;...Number30</emph> are numerical values or ranges.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2855950" role="code">MODE.MULT(Number1; Number2; ...; Number30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2850337" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges.</paragraph>
<paragraph xml-lang="en-US" id="par_id2863792" role="warning">As the MODE.MULT function returns an array of values, it must be entered as an array formula. If the function is not entered as an array formula, only the first mode is returned, which is the same as using the MODE.SNGL function.</paragraph>
<paragraph xml-lang="en-US" id="hd_id2853571" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id2853733" role="paragraph"><item type="input">=MODE.MULT(A1:A50)</item></paragraph>
diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp
index f9f4f09857..b838f45cc2 100644
--- a/source/text/scalc/01/04060185.xhp
+++ b/source/text/scalc/01/04060185.xhp
@@ -45,7 +45,7 @@
<emph>Data</emph> is the array or range of data in the sample.</paragraph>
<paragraph xml-lang="en-US" id="par_id3150215" role="paragraph">
<emph>Type</emph> (optional) is the sequence order.</paragraph>
- <paragraph xml-lang="en-US" id="par_id9305398" role="paragraph">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_id9305398" role="paragraph">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_id9996948" role="paragraph">Type = 1 means ascending from the first item of the range to the last.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3143223" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3155919" role="paragraph">
@@ -65,7 +65,7 @@
<paragraph xml-lang="en-US" id="par_id2954543" role="paragraph"><emph>Value</emph> is the value, whose rank is to be determined.</paragraph>
<paragraph xml-lang="en-US" id="par_id2949130" role="paragraph"><emph>Data</emph> is the array or range of data in the sample.</paragraph>
<paragraph xml-lang="en-US" id="par_id2950215" role="paragraph"><emph>Type</emph> (optional) is the sequence order.</paragraph>
-<paragraph xml-lang="en-US" id="par_id0305398" role="paragraph">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_id0305398" role="paragraph">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">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">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id2955919" role="paragraph"><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>
@@ -84,7 +84,7 @@
<paragraph xml-lang="en-US" id="par_id2854543" role="paragraph"><emph>Value</emph> is the value, whose rank is to be determined.</paragraph>
<paragraph xml-lang="en-US" id="par_id2849130" role="paragraph"><emph>Data</emph> is the array or range of data in the sample.</paragraph>
<paragraph xml-lang="en-US" id="par_id2850215" role="paragraph"><emph>Type</emph> (optional) is the sequence order.</paragraph>
-<paragraph xml-lang="en-US" id="par_id89305398" role="paragraph">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_id89305398" role="paragraph">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">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">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id2855919" role="paragraph"><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>
@@ -96,9 +96,9 @@
<paragraph xml-lang="en-US" id="hd_id3153556" role="heading" level="2">SKEW</paragraph>
<paragraph xml-lang="en-US" id="par_id3153485" role="paragraph"><ahelp hid="HID_FUNC_SCHIEFE">Returns the skewness of a distribution.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id3154733" role="heading" level="3">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3151191" role="code">SKEW(Number1; Number2; ...Number30)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3151191" role="code">SKEW(Number1; Number2; ...; Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3155757" role="paragraph">
- <emph>Number1, Number2...Number30</emph> are numerical values or ranges.</paragraph>
+ <emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3153297" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3145118" role="paragraph">
<item type="input">=SKEW(A1:A50)</item> calculates the value of skew for the data referenced.</paragraph>
@@ -155,9 +155,9 @@
<paragraph xml-lang="en-US" id="hd_id3149143" role="heading" level="2">STDEV</paragraph>
<paragraph xml-lang="en-US" id="par_id3146888" role="paragraph"><ahelp hid="HID_FUNC_STABW">Estimates the standard deviation based on a sample.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id3146815" role="heading" level="3">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3149946" role="code">STDEV(Number1; Number2; ...Number30)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3149946" role="code">STDEV(Number1; Number2; ...; Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3157904" role="paragraph">
- <emph>Number1, Number2, ... Number30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph>
+ <emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3150650" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3149434" role="paragraph">
<item type="input">=STDEV(A1:A50)</item> returns the estimated standard deviation based on the data referenced.</paragraph>
@@ -169,9 +169,9 @@
<paragraph xml-lang="en-US" id="hd_id3144745" role="heading" level="2">STDEVA</paragraph>
<paragraph xml-lang="en-US" id="par_id3151234" role="paragraph"><ahelp hid="HID_FUNC_STABWA">Calculates the standard deviation of an estimation based on a sample.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id3148884" role="heading" level="3">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3147422" role="code">STDEVA(Value1;Value2;...Value30)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3147422" role="code">STDEVA(Value1; Value2; ...; Value30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3154547" role="paragraph">
- <emph>Value1, Value2, ...Value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0.</paragraph>
+ <emph>Value1, Value2, ..., Value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3155829" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3148581" role="paragraph">
<item type="input">=STDEVA(A1:A50)</item> returns the estimated standard deviation based on the data referenced.</paragraph>
@@ -184,9 +184,9 @@
<paragraph xml-lang="en-US" id="hd_id3149734" role="heading" level="2">STDEVP</paragraph>
<paragraph xml-lang="en-US" id="par_id3149187" role="paragraph"><ahelp hid="HID_FUNC_STABWN">Calculates the standard deviation based on the entire population.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id3154387" role="heading" level="3">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3154392" role="code">STDEVP(Number1;Number2;...Number30)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3154392" role="code">STDEVP(Number1; Number2; ...; Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3155261" role="paragraph">
- <emph>Number 1,Number 2,...Number 30</emph> are numerical values or ranges representing an entire population.</paragraph>
+ <emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3145591" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3153933" role="paragraph">
<item type="input">=STDEVP(A1:A50)</item> returns a standard deviation of the data referenced.</paragraph>
@@ -200,8 +200,8 @@
<paragraph xml-lang="en-US" id="hd_id2949734" role="heading" level="2">STDEV.P</paragraph>
<paragraph xml-lang="en-US" id="par_id2949187" role="paragraph"><ahelp hid="HID_FUNC_ST_DEV_P_MS">Calculates the standard deviation based on the entire population.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id2954387" role="heading" level="3">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id2954392" role="code">STDEV.P(Number1;Number2;...Number30)</paragraph>
- <paragraph xml-lang="en-US" id="par_id2955261" role="paragraph"><emph>Number 1,Number 2,...Number 30</emph> are numerical values or ranges representing an entire population.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2954392" role="code">STDEV.P(Number1; Number2; ...; Number30)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2955261" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population.</paragraph>
<paragraph xml-lang="en-US" id="hd_id2945591" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id2953933" role="paragraph"><item type="input">=STDEV.P(A1:A50)</item> returns a standard deviation of the data referenced.</paragraph>
</section>
@@ -214,8 +214,8 @@
<paragraph xml-lang="en-US" id="hd_id2849734" role="heading" level="2">STDEV.S</paragraph>
<paragraph xml-lang="en-US" id="par_id2849187" role="paragraph"><ahelp hid="HID_FUNC_ST_DEV_S">Calculates the standard deviation based on sample of the population.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id2854387" role="heading" level="3">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id2854392" role="code">STDEV.S(Number1;Number2;...Number30)</paragraph>
- <paragraph xml-lang="en-US" id="par_id2855261" role="paragraph"><emph>Number 1,Number 2,...Number 30</emph> are numerical values or ranges representing a sample of the population.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2854392" role="code">STDEV.S(Number1; Number2; ...; Number30)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2855261" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample of the population.</paragraph>
<paragraph xml-lang="en-US" id="hd_id2845591" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id2853933" role="paragraph"><item type="input">=STDEV.S(A1:A50)</item> returns a standard deviation of the data referenced.</paragraph>
</section>
@@ -226,9 +226,9 @@
<paragraph xml-lang="en-US" id="hd_id3154522" role="heading" level="2">STDEVPA</paragraph>
<paragraph xml-lang="en-US" id="par_id3149549" role="paragraph"><ahelp hid="HID_FUNC_STABWNA">Calculates the standard deviation based on the entire population.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id3155950" role="heading" level="3">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3146851" role="code">STDEVPA(Value1;Value2;...Value30)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3146851" role="code">STDEVPA(Value1; Value2; ...; Value30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3153109" role="paragraph">
- <emph>Value1,value2,...value30</emph> are values or ranges representing an entire population. Text has the value 0.</paragraph>
+ <emph>Value1, Value2, ..., Value30</emph> are values or ranges representing an entire population. Text has the value 0.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3154506" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3145163" role="paragraph">
<item type="input">=STDEVPA(A1:A50)</item> returns the standard deviation of the data referenced.</paragraph>
@@ -360,9 +360,9 @@
<paragraph xml-lang="en-US" id="hd_id3150873" role="heading" level="2">DEVSQ</paragraph>
<paragraph xml-lang="en-US" id="par_id3154748" role="paragraph"><ahelp hid="HID_FUNC_SUMQUADABW">Returns the sum of squares of deviations based on a sample mean.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id3156121" role="heading" level="3">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3146790" role="code">DEVSQ(Number1; Number2; ...Number30)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3146790" role="code">DEVSQ(Number1; Number2; ...; Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3155995" role="paragraph">
- <emph>Number1, Number2, ...Number30</emph> numerical values or ranges representing a sample. </paragraph>
+ <emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3150254" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3149136" role="paragraph">
<item type="input">=DEVSQ(A1:A50)</item>
@@ -526,9 +526,9 @@
<paragraph xml-lang="en-US" id="hd_id3153828" role="heading" level="2">VAR</paragraph>
<paragraph xml-lang="en-US" id="par_id3159165" role="paragraph"><ahelp hid="HID_FUNC_VARIANZ">Estimates the variance based on a sample.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id3154286" role="heading" level="3">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3153054" role="code">VAR(Number1; Number2; ...Number30)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3153054" role="code">VAR(Number1 ; Number2; ...; Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3148938" role="paragraph">
- <emph>Number1, Number2, ...Number30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph>
+ <emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3147233" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3153575" role="paragraph">
<item type="input">=VAR(A1:A50)</item>
@@ -543,8 +543,8 @@
<paragraph xml-lang="en-US" id="hd_id2953828" role="heading" level="2">VAR.S</paragraph>
<paragraph xml-lang="en-US" id="par_id2959165" role="paragraph"><ahelp hid="HID_FUNC_VAR_S">Estimates the variance based on a sample.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id2954286" role="heading" level="3">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id2953054" role="code">VAR.S(Number1; Number2; ...Number30)</paragraph>
- <paragraph xml-lang="en-US" id="par_id2948938" role="paragraph"><emph>Number1, Number2, ...Number30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2953054" role="code">VAR.S(Number1; Number2; ...; Number30)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2948938" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph>
<paragraph xml-lang="en-US" id="hd_id2947233" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id2953575" role="paragraph"><item type="input">=VAR.S(A1:A50)</item></paragraph>
</section>
@@ -555,9 +555,9 @@
<paragraph xml-lang="en-US" id="hd_id3151045" role="heading" level="2">VARA</paragraph>
<paragraph xml-lang="en-US" id="par_id3155122" role="paragraph"><ahelp hid="HID_FUNC_VARIANZA">Estimates a variance based on a sample. The value of text is 0.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id3149176" role="heading" level="3">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3149999" role="code">VARA(Value1; Value2; ...Value30)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3149999" role="code">VARA(Value1; Value2; ...; Value30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3158421" role="paragraph">
- <emph>Value1, Value2,...Value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0.</paragraph>
+ <emph>Value1, Value2, ..., Value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3149160" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3154279" role="paragraph">
<item type="input">=VARA(A1:A50)</item>
@@ -570,9 +570,9 @@
<paragraph xml-lang="en-US" id="hd_id3166441" role="heading" level="2">VARP</paragraph>
<paragraph xml-lang="en-US" id="par_id3159199" role="paragraph"><ahelp hid="HID_FUNC_VARIANZEN">Calculates a variance based on the entire population.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id3150706" role="heading" level="3">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3147282" role="code">VARP(Number1; Number2; ...Number30)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3147282" role="code">VARP(Number1; Number2; ...; Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3149793" role="paragraph">
- <emph>Number1, Number2, ...Number30</emph> are numerical values or ranges representing an entire population.</paragraph>
+ <emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3152939" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3153385" role="paragraph">
<item type="input">=VARP(A1:A50)</item>
@@ -586,8 +586,8 @@
<paragraph xml-lang="en-US" id="hd_id2966441" role="heading" level="2">VAR.P</paragraph>
<paragraph xml-lang="en-US" id="par_id2959199" role="paragraph"><ahelp hid="HID_FUNC_VAR_P_MS">Calculates a variance based on the entire population.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id2950706" role="heading" level="3">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id2947282" role="code">VAR.P(Number1; Number2; ...Number30)</paragraph>
- <paragraph xml-lang="en-US" id="par_id2949793" role="paragraph"><emph>Number1, Number2, ...Number30</emph> are numerical values or ranges representing an entire population.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2947282" role="code">VAR.P(Number1; Number2; ...; Number30)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2949793" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population.</paragraph>
<paragraph xml-lang="en-US" id="hd_id2952939" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id2953385" role="paragraph"><item type="input">=VAR.P(A1:A50)</item></paragraph>
</section>
@@ -598,9 +598,9 @@
<paragraph xml-lang="en-US" id="hd_id3153688" role="heading" level="2">VARPA</paragraph>
<paragraph xml-lang="en-US" id="par_id3149109" role="paragraph"><ahelp hid="HID_FUNC_VARIANZENA">Calculates the variance based on the entire population. The value of text is 0.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id3152880" role="heading" level="3">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3149967" role="code">VARPA(Value1; Value2; ...Value30)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3149967" role="code">VARPA(Value1; Value2; ...; Value30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3149920" role="paragraph">
- <emph>Value1,value2,...Value30</emph> are values or ranges representing an entire population.</paragraph>
+ <emph>Value1, Value2, ..., Value30</emph> are values or ranges representing an entire population.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3154862" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3156203" role="paragraph">
<item type="input">=VARPA(A1:A50)</item>
@@ -657,7 +657,7 @@
<paragraph xml-lang="en-US" id="par_id3151107" role="paragraph">
<emph>Start</emph> is the start value of the interval whose probabilities are to be summed.</paragraph>
<paragraph xml-lang="en-US" id="par_id3153694" role="paragraph">
- <emph>End</emph> (optional) is the end value of the interval whose probabilities are to be summed. If this parameter is missing, the probability for the <emph>Start </emph>value is calculated.</paragraph>
+ <emph>End</emph> (optional) is the end value of the interval whose probabilities are to be summed. If this parameter is missing, the probability for the <emph>Start</emph> value is calculated.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3147574" role="heading" level="3">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3153666" role="paragraph">
<item type="input">=PROB(A1:A50;B1:B50;50;60)</item> returns the probability with which a value within the range of A1:A50 is also within the limits between 50 and 60. Every value within the range of A1:A50 has a probability within the range of B1:B50.</paragraph>
@@ -668,7 +668,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WEIBULL" id="bm_id3150405" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3150941" role="heading" level="2">WEIBULL</paragraph>
<paragraph xml-lang="en-US" id="par_id3154916" role="paragraph"><ahelp hid="HID_FUNC_WEIBULL">Returns the values of the Weibull distribution.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="par_id0305200911372767" role="paragraph">The Weibull distribution is a continuous probability distribution, with parameters Alpha &gt; 0 (shape) and Beta &gt; 0 (scale). </paragraph>
+ <paragraph xml-lang="en-US" id="par_id0305200911372767" role="paragraph">The Weibull distribution is a continuous probability distribution, with parameters Alpha &gt; 0 (shape) and Beta &gt; 0 (scale).</paragraph>
<paragraph xml-lang="en-US" id="par_id0305200911372777" role="paragraph">If C is 0, WEIBULL calculates the probability density function.</paragraph>
<paragraph xml-lang="en-US" id="par_id0305200911372743" role="paragraph">If C is 1, WEIBULL calculates the cumulative distribution function.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3159393" role="heading" level="3">Syntax</paragraph>
diff --git a/source/text/scalc/01/func_skewp.xhp b/source/text/scalc/01/func_skewp.xhp
index 176fc7ba8e..942b44a6e9 100644
--- a/source/text/scalc/01/func_skewp.xhp
+++ b/source/text/scalc/01/func_skewp.xhp
@@ -34,7 +34,7 @@
<paragraph id="hd_id456845684568" role="heading" level="2" xml-lang="en-US"><variable id="skewp_head"><link href="text/scalc/01/func_skewp.xhp">SKEWP</link></variable></paragraph>
<paragraph id="par_id1102201617001848" role="paragraph" xml-lang="en-US"><ahelp hid=".">Calculates the skewness of a distribution using the population of a random variable.</ahelp></paragraph>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
-<paragraph id="par_id27421466710275" role="code" xml-lang="en-US">SKEWP(Number1; Number2;..., Number30)</paragraph>
+<paragraph id="par_id27421466710275" role="code" xml-lang="en-US">SKEWP(Number1; Number2; ...; Number30)</paragraph>
<paragraph id="par_id242131304318587" role="paragraph" xml-lang="en-US"><emph>Number1, Number2, ..., Number30</emph> are up to 30 numerical values or ranges.</paragraph>
<paragraph id="par_id242131304315587" role="paragraph" xml-lang="en-US">Calculates the skewness of a distribution using the population, i.e. the possible outcomes, of a random variable. The sequence shall contain three numbers at least.</paragraph>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
@@ -42,9 +42,8 @@
<paragraph id="par_id1102201617001888" role="paragraph" xml-lang="en-US"><item type="literal">SKEWP(2;3;1;6;8;5)</item> returns 0.2828158928
</paragraph>
<paragraph id="par_id1102201618185378" role="paragraph" xml-lang="en-US"><item type="literal">SKEWP(A1:A6)</item> returns 0.2828158928, when the range A1:A6 contains {2;3;1;6;8;5}</paragraph>
-<paragraph id="par_id1102201618185326" role="paragraph" xml-lang="en-US"><item type="literal">SKEWP(Number1;Number2)</item> returns zero always, if Number1 and Number2 results in two numbers.</paragraph>
-<paragraph id="par_id1102201618188326" role="paragraph" xml-lang="en-US"><item type="literal">SKEWP(Number1)</item> returns Err:502 (Invalid argument) if Number1 results in one number, because SKEWP cannot be calculated with one value.
-</paragraph>
+<paragraph id="par_id1102201618185326" role="paragraph" xml-lang="en-US"><item type="literal">SKEWP(Number1; Number2)</item> always returns zero, if Number1 and Number2 results in two numbers.</paragraph>
+<paragraph id="par_id1102201618188326" role="paragraph" xml-lang="en-US"><item type="literal">SKEWP(Number1)</item> returns Err:502 (Invalid argument) if Number1 results in one number, because SKEWP cannot be calculated with one value.</paragraph>
</section>
<section id="relatedtopics">
<paragraph id="par_id14337286612130" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060185.xhp#skew">SKEW</link></paragraph>