source/text/scalc/01/04060109.xhp | 12 +++---
source/text/scalc/01/04060119.xhp | 10 ++---
source/text/scalc/01/04060181.xhp | 22 ++++++------
source/text/scalc/01/04060182.xhp | 12 +++---
source/text/scalc/01/04060183.xhp | 10 ++---
source/text/scalc/01/04060184.xhp | 44 ++++++++++++------------
source/text/scalc/01/04060185.xhp | 66 ++++++++++++++++++------------------
source/text/scalc/01/func_skewp.xhp | 7 +--
8 files changed, 91 insertions(+), 92 deletions(-)
New commits:
commit 3db795172c8031ac1a88967f28858812a2d35089
Author: Sophia Schröder <sophia.schroe...@libreoffice.org>
Date: Mon Apr 23 12:58:00 2018 +0100
Improve formatting in help text.
Change-Id: I873128ed6353caf37f063a87361bd0a6f7c79f96
Reviewed-on: https://gerrit.libreoffice.org/53321
Tested-by: Jenkins <c...@libreoffice.org>
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/04060109.xhp
b/source/text/scalc/01/04060109.xhp
index 95e3d8791..caa0431b5 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()>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()>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"&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 fca7a5071..818c38638 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 ba890e71d..1909e4b56 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;">=2006") </item>- this returns 4</paragraph>
-<paragraph id="par_id2118594" role="paragraph" xml-lang="en-US"><item
type="input">=COUNTIF(A1:A10;"<"&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">>2006</item> counts the number of cells in the range A1:A10
which are >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;">=2006")</item> - this returns 4.</paragraph>
+<paragraph id="par_id2118594" role="paragraph" xml-lang="en-US"><item
type="input">=COUNTIF(A1:A10;"<"&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">>2006</item> counts the number of cells in the range A1:A10
which are >2006.</paragraph>
<paragraph id="par_id6386913" role="paragraph" xml-lang="en-US">To count only
negative numbers: <item type="input">=COUNTIF(A1:A10;"<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 faa2821e0..f94205c75 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 73ce3af89..1b725410a 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 68c7f81d2..fd6dc0ece 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 f9f4f0985..b838f45cc 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 > 0 (shape) and Beta > 0 (scale).
</paragraph>
+ <paragraph xml-lang="en-US" id="par_id0305200911372767"
role="paragraph">The Weibull distribution is a continuous probability
distribution, with parameters Alpha > 0 (shape) and Beta > 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 176fc7ba8..942b44a6e 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>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
