source/text/scalc/01/04060106.xhp | 16 ++---
source/text/scalc/01/04060119.xhp | 9 +--
source/text/scalc/01/04060181.xhp | 11 +--
source/text/scalc/01/04060183.xhp | 36 ++++++------
source/text/scalc/01/04060184.xhp | 106 ++++++++++++++++++--------------------
source/text/scalc/01/04060185.xhp | 95 ++++++++++++++++------------------
source/text/scalc/01/ful_func.xhp | 4 +
7 files changed, 136 insertions(+), 141 deletions(-)
New commits:
commit dac90072fecdfa76352153616f102d3229b5512e
Author: Steve Fanning <stevemfanning...@gmail.com>
AuthorDate: Tue Mar 24 20:04:52 2020 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed Mar 25 22:27:29 2020 +0100
tdf#131361 Adjust number of function parameters
Fixes for SUM, SUMSQ, NPV, AVEDEV, AVERAGE, AVERAGEA
COUNT, COUNTA, DEVSQ, KURT
Change-Id: I1227064ed343ccccd5a339cce7425b5143072537
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91013
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/04060106.xhp
b/source/text/scalc/01/04060106.xhp
index 46deb1449..94bef6036 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -900,14 +900,12 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_QUADRATESUMME"
id="bm_id3160351" localize="false"/>
<h2 id="hd_id3160340">SUMSQ</h2>
-<paragraph id="par_id3160368" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_QUADRATESUMME">If you want to calculate the sum of the squares of
numbers (totaling up of the squares of the arguments), enter these into the
text fields.</ahelp></paragraph>
-
+<paragraph id="par_id3160368" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_QUADRATESUMME">Calculates the sum of the squares of a set of
numbers.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3160402" role="code" xml-lang="en-US">SUMSQ(Number1;
Number2; ...; Number30)</paragraph>
-<paragraph id="par_id3160415" role="paragraph" xml-lang="en-US"><emph>Number1
to 30</emph> are up to 30 arguments the sum of whose squares is to be
calculated.</paragraph>
-
+<paragraph id="par_id3160402" role="code" xml-lang="en-US">SUMSQ(<embedvar
href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph>
+<embed href="text/scalc/01/ful_func.xhp#number255"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3160449" role="paragraph" xml-lang="en-US">If you enter
the numbers <item type="input">2</item>; <item type="input">3</item> and <item
type="input">4</item> in the Number 1; 2 and 3 text boxes, 29 is returned as
the result.</paragraph>
+<paragraph id="par_id3160449" role="paragraph" xml-lang="en-US">If you enter
the numbers 2; 3 and 4 in the Number 1; 2 and 3 arguments, 29 is returned as
the result.</paragraph>
</section>
<section id="Section24">
@@ -1131,11 +1129,11 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMME" id="bm_id3163608"
localize="false"/>
<h2 id="hd_id3163596"><variable id="sum_head"><link
href="text/scalc/01/04060106.xhp#Section16">SUM</link></variable></h2>
-<paragraph id="par_id3163625" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_SUMME">Adds all the numbers in a range of
cells.</ahelp></paragraph>
+<paragraph id="par_id3163625" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_SUMME">Adds a set of numbers.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3163656" role="code" xml-lang="en-US">SUM(Number1;
Number2; ...; Number30)</paragraph>
-<paragraph id="par_id3163671" role="paragraph" xml-lang="en-US"><emph>Number1
to Number30</emph> are up to 30 arguments, either cells or ranges, whose sum is
to be calculated.</paragraph>
+<paragraph id="par_id3163656" role="code" xml-lang="en-US">SUM(<embedvar
href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph>
+<embed href="text/scalc/01/ful_func.xhp#number255"/>
<tip id="par_id151567608802604">SUM ignores any text or empty cell within a
range or array. If you suspect wrong results of the SUM function, look for text
in the data ranges. Use the <link href="text/scalc/01/03080000.xhp" name="value
highlight">value highlighting</link> feature to highlight the text contents in
the range that may represent a number.</tip>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3163704" role="paragraph" xml-lang="en-US">If you enter
the numbers <item type="input">2</item>; <item type="input">3 </item>and <item
type="input">4</item> in the Number 1; 2 and 3 text boxes, 9 will be returned
as the result.</paragraph>
diff --git a/source/text/scalc/01/04060119.xhp
b/source/text/scalc/01/04060119.xhp
index ea6686d20..5abb0366f 100644
--- a/source/text/scalc/01/04060119.xhp
+++ b/source/text/scalc/01/04060119.xhp
@@ -332,11 +332,10 @@
<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>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<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, Value2, ..., Value30</emph> are up to 30 values, which represent
deposits or withdrawals.</paragraph>
+
+<paragraph role="code" id="par_id3153321" xml-lang="en-US">NPV(Rate; <embedvar
href="text/scalc/01/ful_func.xhp#number254_1" markup="keep"/>)</paragraph>
+<paragraph role="paragraph" id="par_id3150630"
xml-lang="en-US"><emph>Rate</emph> is the discount rate for a
period.</paragraph>
+<embed href="text/scalc/01/ful_func.xhp#number254"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<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 d7c383b01..afce809eb 100644
--- a/source/text/scalc/01/04060181.xhp
+++ b/source/text/scalc/01/04060181.xhp
@@ -66,9 +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>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<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="par_id3148585" role="code" xml-lang="en-US">COUNT(<embedvar
href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph>
+<embed href="text/scalc/01/ful_func.xhp#number255"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<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>
<paragraph id="par_id3154558" role="paragraph" xml-lang="en-US"><item
type="input">=COUNT(2;4;6;"eight")</item> = 3. The count of numbers is
therefore 3.</paragraph>
@@ -84,11 +83,9 @@
<h2 id="hd_id3149729"><variable id="counta_head"><link
href="text/scalc/01/04060181.xhp#counta">COUNTA</link></variable></h2>
<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>
-
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<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="par_id3153111" role="code" xml-lang="en-US">COUNTA(<embedvar
href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph>
+<embed href="text/scalc/01/ful_func.xhp#number255"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<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>
<paragraph id="par_id3158000" role="paragraph" xml-lang="en-US"><item
type="input">=COUNTA(2;4;6;"eight")</item> = 4. The count of values is
therefore 4.</paragraph>
diff --git a/source/text/scalc/01/04060183.xhp
b/source/text/scalc/01/04060183.xhp
index 1232151f6..e3cf9d24a 100644
--- a/source/text/scalc/01/04060183.xhp
+++ b/source/text/scalc/01/04060183.xhp
@@ -27,8 +27,8 @@
</topic>
</meta>
<body>
-<paragraph role="heading" id="hd_id3166425" xml-lang="en-US"
level="1"><variable id="kl"><link href="text/scalc/01/04060183.xhp"
name="Statistical Functions Part Three">Statistical Functions Part Three</link>
-</variable></paragraph>
+<h1 id="hd_id3166425"><variable id="kl"><link
href="text/scalc/01/04060183.xhp" name="Statistical Functions Part
Three">Statistical Functions Part Three</link>
+</variable></h1>
<sort order="asc">
<section id="large">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3149530"><bookmark_value>LARGE function</bookmark_value>
@@ -64,7 +64,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3153559"><bookmark_value>CONFIDENCE function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KONFIDENZ"
id="bm_id3153803" localize="false"/>
-<paragraph role="heading" id="hd_id3153559" xml-lang="en-US"
level="2">CONFIDENCE</paragraph>
+<h2 id="hd_id3153559">CONFIDENCE</h2>
<paragraph role="paragraph" id="par_id3153814" xml-lang="en-US"><ahelp
hid="HID_FUNC_KONFIDENZ">Returns the (1-alpha) confidence interval for a normal
distribution.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3147501" xml-lang="en-US">CONFIDENCE(Alpha;
StDev; Size)</paragraph>
@@ -82,7 +82,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id2953559"><bookmark_value>CONFIDENCE.T function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CONFIDENCE_T"
id="bm_id2953803" localize="false"/>
-<paragraph role="heading" id="hd_id2953559" xml-lang="en-US"
level="2">CONFIDENCE.T</paragraph>
+<h2 id="hd_id2953559">CONFIDENCE.T</h2>
<paragraph role="paragraph" id="par_id2953814" xml-lang="en-US">
<ahelp hid="HID_FUNC_CONFIDENCE_T">Returns the (1-alpha) confidence
interval for a Student's t distribution.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
@@ -102,7 +102,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id2853559"><bookmark_value>CONFIDENCE.NORM function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CONFIDENCE_N"
id="bm_id2853803" localize="false"/>
-<paragraph role="heading" id="hd_id2853559" xml-lang="en-US"
level="2">CONFIDENCE.NORM</paragraph>
+<h2 id="hd_id2853559">CONFIDENCE.NORM</h2>
<paragraph role="paragraph" id="par_id2853814" xml-lang="en-US">
<ahelp hid="HID_FUNC_CONFIDENCE_N">Returns the (1-alpha) confidence
interval for a normal distribution.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
@@ -123,7 +123,7 @@
<bookmark_value>coefficient of correlation</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KORREL" id="bm_id3147403"
localize="false"/>
-<paragraph role="heading" id="hd_id3148746" xml-lang="en-US"
level="2">CORREL</paragraph>
+<h2 id="hd_id3148746">CORREL</h2>
<paragraph role="paragraph" id="par_id3147299" xml-lang="en-US"><ahelp
hid="HID_FUNC_KORREL">Returns the correlation coefficient between two data
sets.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3153023" xml-lang="en-US">CORREL(Data1;
Data2)</paragraph>
@@ -139,7 +139,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3150652"><bookmark_value>COVAR function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KOVAR" id="bm_id3152983"
localize="false"/>
-<paragraph role="heading" id="hd_id3150652" xml-lang="en-US"
level="2">COVAR</paragraph>
+<h2 id="hd_id3150652">COVAR</h2>
<paragraph role="paragraph" id="par_id3146875" xml-lang="en-US"><ahelp
hid="HID_FUNC_KOVAR">Returns the covariance of the product of paired
deviations.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3150740" xml-lang="en-US">COVAR(Data1;
Data2)</paragraph>
@@ -157,7 +157,7 @@
<bookmark_value>COVARIANCE.P function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COVARIANCE_P"
id="bm_id2952983" localize="false"/>
- <paragraph role="heading" id="hd_id2950652" xml-lang="en-US"
level="2">COVARIANCE.P</paragraph>
+ <h2 id="hd_id2950652">COVARIANCE.P</h2>
<paragraph role="paragraph" id="par_id2946875" xml-lang="en-US"><ahelp
hid="HID_FUNC_COVARIANCE_P">Returns the covariance of the product of paired
deviations, for the entire population.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -172,7 +172,7 @@
<bookmark_value>COVARIANCE.S function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COVARIANCE_S"
id="bm_id2852983" localize="false"/>
- <paragraph role="heading" id="hd_id2850652" xml-lang="en-US"
level="2">COVARIANCE.S</paragraph>
+ <h2 id="hd_id2850652">COVARIANCE.S</h2>
<paragraph role="paragraph" id="par_id2846875" xml-lang="en-US"><ahelp
hid="HID_FUNC_COVARIANCE_S">Returns the covariance of the product of paired
deviations, for a sample of the population.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -186,7 +186,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3147472"><bookmark_value>CRITBINOM function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KRITBINOM"
id="bm_id3154848" localize="false"/>
-<paragraph role="heading" id="hd_id3147472" xml-lang="en-US"
level="2">CRITBINOM</paragraph>
+<h2 id="hd_id3147472">CRITBINOM</h2>
<paragraph role="paragraph" id="par_id3149254" xml-lang="en-US"><ahelp
hid="HID_FUNC_KRITBINOM">Returns the smallest value for which the cumulative
binomial distribution is greater than or equal to a criterion
value.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3148586" xml-lang="en-US">CRITBINOM(Trials;
SP; Alpha)</paragraph>
@@ -204,12 +204,12 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3155956"><bookmark_value>KURT function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KURT" id="bm_id3146847"
localize="false"/>
-<paragraph role="heading" id="hd_id3155956" xml-lang="en-US"
level="2">KURT</paragraph>
+<h2 id="hd_id3155956">KURT</h2>
<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>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<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>
+<paragraph role="code" id="par_id3154508" xml-lang="en-US">KURT(<embedvar
href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph>
+<embed href="text/scalc/01/ful_func.xhp#number255"/>
+<paragraph id="par_id501585152669900" role="paragraph" xml-lang="en-US">The
parameters should specify at least four values.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3150016" xml-lang="en-US">
<item type="input">=KURT(A1;A2;A3;A4;A5;A6)</item>
@@ -220,7 +220,7 @@
<bookmark_value>inverse of lognormal distribution</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOGINV" id="bm_id3156062"
localize="false"/>
-<paragraph role="heading" id="hd_id3150928" xml-lang="en-US"
level="2">LOGINV</paragraph>
+<h2 id="hd_id3150928">LOGINV</h2>
<paragraph role="paragraph" id="par_id3145297" xml-lang="en-US"><ahelp
hid="HID_FUNC_LOGINV">Returns the inverse of the lognormal
distribution.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3153049" xml-lang="en-US">LOGINV(Number;
Mean; StDev)</paragraph>
@@ -239,7 +239,7 @@
<bookmark_value>inverse of lognormal distribution</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOGINV_MS"
id="bm_id2901062" localize="false"/>
-<paragraph role="heading" id="hd_id2901928" xml-lang="en-US"
level="2">LOGNORM.INV</paragraph>
+<h2 id="hd_id2901928">LOGNORM.INV</h2>
<paragraph role="paragraph" id="par_id2901297" xml-lang="en-US"><ahelp
hid="HID_FUNC_LOGINV_MS">Returns the inverse of the lognormal
distribution.</ahelp></paragraph>
<paragraph id="par_id290122405814" role="paragraph" xml-lang="en-US">This
function is identical to LOGINV and was introduced for interoperability with
other office suites.</paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
@@ -260,7 +260,7 @@
<bookmark_value>lognormal distribution</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOGNORMVERT"
id="bm_id3155366" localize="false"/>
-<paragraph role="heading" id="hd_id3158417" xml-lang="en-US"
level="2">LOGNORMDIST</paragraph>
+<h2 id="hd_id3158417">LOGNORMDIST</h2>
<paragraph role="paragraph" id="par_id3154953" xml-lang="en-US"><ahelp
hid="HID_FUNC_LOGNORMVERT">Returns the values of a lognormal
distribution.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3150686" xml-lang="en-US">LOGNORMDIST(Number;
Mean; StDev; Cumulative)</paragraph>
@@ -281,7 +281,7 @@
<bookmark_value>lognormal distribution</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOGNORMDIST_MS"
id="bm_id2901366" localize="false"/>
-<paragraph role="heading" id="hd_id2908417" xml-lang="en-US"
level="2">LOGNORM.DIST</paragraph>
+<h2 id="hd_id2908417">LOGNORM.DIST</h2>
<paragraph role="paragraph" id="par_id2904953" xml-lang="en-US"><ahelp
hid="HID_FUNC_LOGNORMDIST_MS">Returns the values of a lognormal
distribution.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
diff --git a/source/text/scalc/01/04060184.xhp
b/source/text/scalc/01/04060184.xhp
index 9f7e210a0..9f9cf63e8 100644
--- a/source/text/scalc/01/04060184.xhp
+++ b/source/text/scalc/01/04060184.xhp
@@ -27,14 +27,14 @@
</topic>
</meta>
<body>
-<paragraph xml-lang="en-US" id="hd_id3153415" role="heading"
level="1"><variable id="mq"><link href="text/scalc/01/04060184.xhp"
name="Statistical Functions Part Four">Statistical Functions Part Four</link>
-</variable></paragraph>
+<h1 id="hd_id3153415"><variable id="mq"><link
href="text/scalc/01/04060184.xhp" name="Statistical Functions Part
Four">Statistical Functions Part Four</link>
+</variable></h1>
<sort order="asc">
<section id="max">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3154511"><bookmark_value>MAX function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MAX" id="bm_id3146972"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3154511" role="heading"
level="2"><variable id="max_head"><link
href="text/scalc/01/04060184.xhp#max">MAX</link></variable></paragraph>
+<h2 id="hd_id3154511"><variable id="max_head"><link
href="text/scalc/01/04060184.xhp#max">MAX</link></variable></h2>
<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>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -50,7 +50,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3166426"><bookmark_value>MAXA function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MAXA" id="bm_id3150304"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3166426" role="heading"
level="2"><variable id="maxa_head"><link
href="text/scalc/01/04060184.xhp#maxa">MAXA</link></variable></paragraph>
+<h2 id="hd_id3166426"><variable id="maxa_head"><link
href="text/scalc/01/04060184.xhp#maxa">MAXA</link></variable></h2>
<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>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -66,7 +66,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3153820"><bookmark_value>MEDIAN function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MEDIAN" id="bm_id3153069"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153820" role="heading"
level="2"><variable id="median_head"><link
href="text/scalc/01/04060184.xhp#median">MEDIAN</link></variable></paragraph>
+<h2 id="hd_id3153820"><variable id="median_head"><link
href="text/scalc/01/04060184.xhp#median">MEDIAN</link></variable></h2>
<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>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3155264" role="code">MEDIAN(Number1;
Number2; ...; Number30)</paragraph>
@@ -79,7 +79,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3154541"><bookmark_value>MIN function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MIN" id="bm_id3159226"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3154541" role="heading"
level="2"><variable id="min_head"><link
href="text/scalc/01/04060184.xhp#min">MIN</link></variable></paragraph>
+<h2 id="hd_id3154541"><variable id="min_head"><link
href="text/scalc/01/04060184.xhp#min">MIN</link></variable></h2>
<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>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -93,7 +93,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3147504"><bookmark_value>MINA function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MINA" id="bm_id3155752"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3147504" role="heading"
level="2"><variable id="mina_head"><link
href="text/scalc/01/04060184.xhp#mina">MINA</link></variable></paragraph>
+<h2 id="hd_id3147504"><variable id="mina_head"><link
href="text/scalc/01/04060184.xhp#mina">MINA</link></variable></h2>
<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>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -110,25 +110,23 @@
<bookmark_value>averages;statistical functions</bookmark_value>
</bookmark><comment>mw added "averages;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELABW"
id="bm_id3156396" localize="false"/>
-<paragraph role="heading" id="hd_id3166465" xml-lang="en-US"
level="2"><variable id="avedev_head"><link
href="text/scalc/01/04060184.xhp#avedev">AVEDEV</link></variable></paragraph>
+<h2 id="hd_id3166465"><variable id="avedev_head"><link
href="text/scalc/01/04060184.xhp#avedev">AVEDEV</link></variable></h2>
<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>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<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(<embedvar
href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph>
+<embed href="text/scalc/01/ful_func.xhp#number255"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph role="paragraph" id="par_id3153122" xml-lang="en-US">
- <item type="input">=AVEDEV(A1:A50)</item>
- </paragraph>
+<paragraph role="paragraph" id="par_id3153122" xml-lang="en-US"><item
type="input">=AVEDEV(A1:A50)</item> </paragraph>
</section>
<section id="average">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3145824"><bookmark_value>AVERAGE function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELWERT"
id="bm_id3146878" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3145824" role="heading"
level="2"><variable id="average_head"><link
href="text/scalc/01/04060184.xhp#average">AVERAGE</link></variable></paragraph>
+<h2 id="hd_id3145824"><variable id="average_head"><link
href="text/scalc/01/04060184.xhp#average">AVERAGE</link></variable></h2>
<paragraph xml-lang="en-US" id="par_id3150482" role="paragraph"><ahelp
hid="HID_FUNC_MITTELWERT">Returns the average of the
arguments.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<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(<embedvar
href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph>
+<embed href="text/scalc/01/ful_func.xhp#number255"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3151232" role="paragraph">
<item type="input">=AVERAGE(A1:A50)</item>
@@ -138,30 +136,30 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3148754"><bookmark_value>AVERAGEA function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELWERTA"
id="bm_id3149690" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3148754" role="heading"
level="2"><variable id="averagea_head"><link
href="text/scalc/01/04060184.xhp#averagea">AVERAGEA</link></variable></paragraph>
+<h2 id="hd_id3148754"><variable id="averagea_head"><link
href="text/scalc/01/04060184.xhp#averagea">AVERAGEA</link></variable></h2>
<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>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<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(<embedvar
href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph>
+<embed href="text/scalc/01/ful_func.xhp#number255"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3150864" role="paragraph">
<item type="input">=AVERAGEA(A1:A50)</item>
</paragraph>
</section>
<section id="averageif">
-<paragraph id="hd_id110421803716508" role="heading" level="2"
localize="false" xml-lang="en-US"><embedvar
href="text/scalc/01/func_averageif.xhp#averageif_head"/></paragraph>
-<paragraph id="par_id71462400513325" role="paragraph" localize="false"
xml-lang="en-US"><embedvar
href="text/scalc/01/func_averageif.xhp#averageif_des"/></paragraph>
+<h2 id="hd_id110421803716508"><embedvar
href="text/scalc/01/func_averageif.xhp#averageif_head"/></h2>
+<paragraph id="par_id71462400513325" role="paragraph" localize="false"
xml-lang="en-US"><embedvar
href="text/scalc/01/func_averageif.xhp#averageif_des"/></paragraph>
</section>
<section id="averageifs">
-<paragraph id="hd_id5471656631510" role="heading" level="2" localize="false"
xml-lang="en-US"><embedvar
href="text/scalc/01/func_averageifs.xhp#averageifs_head"/></paragraph>
-<paragraph id="par_id5259182024777" role="paragraph" localize="false"
xml-lang="en-US"><embedvar
href="text/scalc/01/func_averageifs.xhp#averageifs_des"/></paragraph>
+<h2 id="hd_id5471656631510"><embedvar
href="text/scalc/01/func_averageifs.xhp#averageifs_head"/></h2>
+<paragraph id="par_id5259182024777" role="paragraph" localize="false"
xml-lang="en-US"><embedvar
href="text/scalc/01/func_averageifs.xhp#averageifs_des"/></paragraph>
</section>
<section id="mode">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3153933"><bookmark_value>MODE function</bookmark_value>
<bookmark_value>most common value</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MODALWERT"
id="bm_id3149253" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153933" role="heading"
level="2">MODE</paragraph>
+<h2 id="hd_id3153933">MODE</h2>
<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"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -178,13 +176,13 @@
<bookmark_value>most common value</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MODAL_VALUE_MS"
id="bm_id2949253" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id2953933" role="heading"
level="2">MODE.SNGL</paragraph>
+<h2 id="hd_id2953933">MODE.SNGL</h2>
<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>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<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>
+<warning id="par_id2963792">If the data set contains no duplicate data points,
MODE.SNGL returns the #VALUE! error value.</warning>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2953733" role="paragraph"><item
type="input">=MODE.SNGL(A1:A50)</item></paragraph>
</section>
@@ -193,13 +191,13 @@
<bookmark_value>most common value</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MODAL_VALUE_MULTI"
id="bm_id2849253" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id2853933" role="heading"
level="2">MODE.MULT</paragraph>
+<h2 id="hd_id2853933">MODE.MULT</h2>
<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>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<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>
+<warning id="par_id2863792">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.</warning>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2853733" role="paragraph"><item
type="input">=MODE.MULT(A1:A50)</item></paragraph>
</section>
@@ -208,7 +206,7 @@
<bookmark_value>negative binomial distribution</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NEGBINOMVERT"
id="bm_id3159135" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3149879" role="heading"
level="2">NEGBINOMDIST</paragraph>
+<h2 id="hd_id3149879">NEGBINOMDIST</h2>
<paragraph xml-lang="en-US" id="par_id3155437" role="paragraph"><ahelp
hid="HID_FUNC_NEGBINOMVERT">Returns the negative binomial
distribution.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3150935" role="code">NEGBINOMDIST(X; R;
SP)</paragraph>
@@ -224,7 +222,7 @@
<bookmark_value>negative binomial distribution</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NEGBINOMDIST_MS"
id="bm_id2959135" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id2949879" role="heading"
level="2">NEGBINOM.DIST</paragraph>
+<h2 id="hd_id2949879">NEGBINOM.DIST</h2>
<paragraph xml-lang="en-US" id="par_id2955437" role="paragraph"><ahelp
hid="HID_FUNC_NEGBINOMDIST_MS">Returns the negative binomial density or
distribution function.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -242,7 +240,7 @@
<bookmark_value>normal distribution;inverse of</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NORMINV" id="bm_id3149396"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3155516" role="heading"
level="2">NORMINV</paragraph>
+<h2 id="hd_id3155516">NORMINV</h2>
<paragraph xml-lang="en-US" id="par_id3154634" role="paragraph"><ahelp
hid="HID_FUNC_NORMINV">Returns the inverse of the normal cumulative
distribution.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3147534" role="code">NORMINV(Number;
Mean; StDev)</paragraph>
@@ -258,7 +256,7 @@
<bookmark_value>normal distribution;inverse of</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NORMINV_MS"
id="bm_id2949396" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id2955516" role="heading"
level="2">NORM.INV</paragraph>
+<h2 id="hd_id2955516">NORM.INV</h2>
<paragraph xml-lang="en-US" id="par_id2954634" role="paragraph"><ahelp
hid="HID_FUNC_NORMINV_MS">Returns the inverse of the normal cumulative
distribution.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -275,7 +273,7 @@
<bookmark_value>density function</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NORMVERT" id="bm_id3147484"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153722" role="heading"
level="2">NORMDIST</paragraph>
+<h2 id="hd_id3153722">NORMDIST</h2>
<paragraph xml-lang="en-US" id="par_id3150386" role="paragraph"><ahelp
hid="HID_FUNC_NORMVERT">Returns the density function or the normal cumulative
distribution.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3150613" role="code">NORMDIST(Number;
Mean; StDev; C)</paragraph>
@@ -294,7 +292,7 @@
<bookmark_value>density function</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NORMDIST_MS"
id="bm_id2917484" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id2913722" role="heading"
level="2">NORM.DIST</paragraph>
+<h2 id="hd_id2913722">NORM.DIST</h2>
<paragraph xml-lang="en-US" id="par_id2910386" role="paragraph"><ahelp
hid="HID_FUNC_NORMDIST_MS">Returns the density function or the normal
cumulative distribution.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -313,7 +311,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3152934"><bookmark_value>PEARSON function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_PEARSON" id="bm_id3156103"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3152934" role="heading"
level="2">PEARSON</paragraph>
+<h2 id="hd_id3152934">PEARSON</h2>
<paragraph xml-lang="en-US" id="par_id3153216" role="paragraph"><ahelp
hid="HID_FUNC_PEARSON">Returns the Pearson product moment correlation
coefficient r.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3156133" role="code">PEARSON(Data1;
Data2)</paragraph>
@@ -327,7 +325,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3152806"><bookmark_value>PHI function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_PHI" id="bm_id3153757"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3152806" role="heading"
level="2">PHI</paragraph>
+<h2 id="hd_id3152806">PHI</h2>
<paragraph xml-lang="en-US" id="par_id3150254" role="paragraph"><ahelp
hid="HID_FUNC_PHI">Returns the values of the distribution function for a
standard normal distribution.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3149976"
role="code">PHI(Number)</paragraph>
@@ -344,7 +342,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3153985"><bookmark_value>POISSON function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_POISSON" id="bm_id3156011"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153985" role="heading"
level="2">POISSON</paragraph>
+<h2 id="hd_id3153985">POISSON</h2>
<paragraph xml-lang="en-US" id="par_id3154298" role="paragraph"><ahelp
hid="HID_FUNC_POISSON">Returns the Poisson distribution.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3146093" role="code">POISSON(Number;
Mean; C)</paragraph>
@@ -360,7 +358,7 @@
<bookmark_value>POISSON.DIST function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_POISSON_DIST_MS"
id="bm_id2956011" localize="false"/>
- <paragraph xml-lang="en-US" id="hd_id2953985" role="heading"
level="2">POISSON.DIST</paragraph>
+ <h2 id="hd_id2953985">POISSON.DIST</h2>
<paragraph xml-lang="en-US" id="par_id2954298" role="paragraph"><ahelp
hid="HID_FUNC_POISSON_DIST_MS">Returns the Poisson
distribution.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -375,7 +373,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3153100"><bookmark_value>PERCENTILE function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_QUANTIL" id="bm_id3155394"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153100" role="heading"
level="2">PERCENTILE</paragraph>
+<h2 id="hd_id3153100">PERCENTILE</h2>
<paragraph xml-lang="en-US" id="par_id3154940" role="paragraph"><ahelp
hid="HID_FUNC_QUANTIL">Returns the alpha-percentile of data values in an
array.</ahelp> A percentile returns the scale value for a data series which
goes from the smallest (Alpha=0) to the largest value (alpha=1) of a data
series. For <item type="literal">Alpha</item> = 25%, the percentile means the
first quartile; <item type="literal">Alpha</item> = 50% is the
MEDIAN.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3148813" role="code">PERCENTILE(Data;
Alpha)</paragraph>
@@ -389,10 +387,10 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id2853100"><bookmark_value>PERCENTILE.EXC function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/HID_FUNC_PERCENTILE_EXC"
id="bm_id2855394" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id2853100" role="heading"
level="2">PERCENTILE.EXC</paragraph>
+<h2 id="hd_id2853100">PERCENTILE.EXC</h2>
<paragraph xml-lang="en-US" id="par_id2854940" role="paragraph"><ahelp
hid="HID_FUNC_PERCENTILE_EXC">Returns the <item type="literal">Alpha</item>'th
percentile of a supplied range of values for a given value of <item
type="literal">Alpha</item>, within the range 0 to 1 (exclusive).</ahelp> A
percentile returns the scale value for a data series which goes from the
smallest (<item type="literal">Alpha=0</item>) to the largest value (<item
type="literal">Alpha=1</item>) of a data series. For <item
type="literal">Alpha</item> = 25%, the percentile means the first quartile;
<item type="literal">Alpha</item> = 50% is the MEDIAN.</paragraph>
-<paragraph xml-lang="en-US" id="par_id2754940" role="warning">If <item
type="literal">Alpha</item> is not a multiple of <item
type="literal">1/(n+1)</item>, (where n is the number of values in the supplied
array), the function interpolates between the values in the supplied array, to
calculate the percentile value. However, if <item type="literal">Alpha</item>
is less than <item type="literal">1/(n+1)</item> or <item
type="literal">Alpha</item> is greater than <item
type="literal">n/(n+1)</item>, the function is unable to interpolate, and so
returns an error.</paragraph>
-<paragraph xml-lang="en-US" id="par_id2653976" role="note">The difference
between <item type="input">PERCENTILE.INC</item> and <item
type="input">PERCENTILE.EXC</item> is that, in the <item
type="input">PERCENTILE.INC</item> function the value of alpha is within the
range 0 to 1 inclusive, and in the <item type="input">PERCENTILE.EXC</item>
function, the value of alpha is within the range 0 to 1 exclusive.</paragraph>
+<warning id="par_id2754940">If <item type="literal">Alpha</item> is not a
multiple of <item type="literal">1/(n+1)</item>, (where n is the number of
values in the supplied array), the function interpolates between the values in
the supplied array, to calculate the percentile value. However, if <item
type="literal">Alpha</item> is less than <item type="literal">1/(n+1)</item> or
<item type="literal">Alpha</item> is greater than <item
type="literal">n/(n+1)</item>, the function is unable to interpolate, and so
returns an error.</warning>
+<note id="par_id2653976">The difference between <item
type="input">PERCENTILE.INC</item> and <item type="input">PERCENTILE.EXC</item>
is that, in the <item type="input">PERCENTILE.INC</item> function the value of
alpha is within the range 0 to 1 inclusive, and in the <item
type="input">PERCENTILE.EXC</item> function, the value of alpha is within the
range 0 to 1 exclusive.</note>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2848813"
role="code">PERCENTILE.EXC(Data; Alpha)</paragraph>
@@ -405,9 +403,9 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id2953100"><bookmark_value>PERCENTILE.INC function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/HID_FUNC_PERCENTILE_INC"
id="bm_id2955394" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id2953100" role="heading"
level="2">PERCENTILE.INC</paragraph>
+<h2 id="hd_id2953100">PERCENTILE.INC</h2>
<paragraph xml-lang="en-US" id="par_id2954940" role="paragraph"><ahelp
hid="HID_FUNC_PERCENTILE_INC">Returns the alpha-percentile of data values in an
array.</ahelp> A percentile returns the scale value for a data series which
goes from the smallest (Alpha=0) to the largest value (alpha=1) of a data
series. For <item type="literal">Alpha</item> = 25%, the percentile means the
first quartile; <item type="literal">Alpha</item> = 50% is the
MEDIAN.</paragraph>
-<paragraph xml-lang="en-US" id="par_id2753976" role="note">The difference
between <item type="input">PERCENTILE.INC</item> and <item
type="input">PERCENTILE.EXC</item> is that, in the <item
type="input">PERCENTILE.INC</item> function the value of alpha is within the
range 0 to 1 inclusive, and in the <item type="input">PERCENTILE.EXC</item>
function, the value of alpha is within the range 0 to 1 exclusive.</paragraph>
+<note id="par_id2753976">The difference between <item
type="input">PERCENTILE.INC</item> and <item type="input">PERCENTILE.EXC</item>
is that, in the <item type="input">PERCENTILE.INC</item> function the value of
alpha is within the range 0 to 1 inclusive, and in the <item
type="input">PERCENTILE.EXC</item> function, the value of alpha is within the
range 0 to 1 exclusive.</note>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2948813"
role="code">PERCENTILE.INC(Data; Alpha)</paragraph>
@@ -420,7 +418,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3148807"><bookmark_value>PERCENTRANK function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_QUANTILSRANG"
id="bm_id3154902" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3148807" role="heading"
level="2">PERCENTRANK</paragraph>
+<h2 id="hd_id3148807">PERCENTRANK</h2>
<paragraph xml-lang="en-US" id="par_id3153573" role="paragraph"><ahelp
hid="HID_FUNC_QUANTILSRANG">Returns the percentage rank of a value in a
sample.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3147238" role="code">PERCENTRANK(Data;
Value; Significance)</paragraph>
@@ -434,9 +432,9 @@
<section id="percentrankexc">
<bookmark xml-lang="en-US" branch="index"
id="bm_id2848807"><bookmark_value>PERCENTRANK.EXC
function</bookmark_value></bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_PERCENTRANK_EXC"
id="bm_id2854902" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id2848807" role="heading"
level="2">PERCENTRANK.EXC</paragraph>
+<h2 id="hd_id2848807">PERCENTRANK.EXC</h2>
<paragraph xml-lang="en-US" id="par_id2853573" role="paragraph"><ahelp
hid="HID_FUNC_PERCENTRANK_EXC"> Returns the relative position, between 0 and 1
(exclusive), of a specified value within a supplied array.</ahelp></paragraph>
-<paragraph xml-lang="en-US" id="par_id2553976" role="note">The difference
between <item type="input">PERCENTRANK.INC</item> and <item
type="input">PERCENTRANK.EXC</item> is that <item
type="input">PERCENTRANK.INC</item> calculates a value in the range 0 to 1
inclusive, whereas the <item type="input">PERCENTRANK.EXC</item> function
calculates a value in the range 0 to 1 exclusive.</paragraph>
+<note id="par_id2553976">The difference between <item
type="input">PERCENTRANK.INC</item> and <item
type="input">PERCENTRANK.EXC</item> is that <item
type="input">PERCENTRANK.INC</item> calculates a value in the range 0 to 1
inclusive, whereas the <item type="input">PERCENTRANK.EXC</item> function
calculates a value in the range 0 to 1 exclusive.</note>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2847238"
role="code">PERCENTRANK.EXC(Data; Value; Significance)</paragraph>
@@ -449,9 +447,9 @@
<section id="percentrankinc">
<bookmark xml-lang="en-US" branch="index"
id="bm_id2948807"><bookmark_value>PERCENTRANK.INC
function</bookmark_value></bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_PERCENTRANK_INC"
id="bm_id2954902" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id2948807" role="heading"
level="2">PERCENTRANK.INC</paragraph>
+<h2 id="hd_id2948807">PERCENTRANK.INC</h2>
<paragraph xml-lang="en-US" id="par_id2953573" role="paragraph"><ahelp
hid="HID_FUNC_PERCENTRANK_INC">Returns the relative position, between 0 and 1
(inclusive), of a specified value within a supplied array.</ahelp></paragraph>
-<paragraph xml-lang="en-US" id="par_id2453976" role="note">The difference
between <item type="input">PERCENTRANK.INC</item> and <item
type="input">PERCENTRANK.EXC</item> is that <item
type="input">PERCENTRANK.INC</item> calculates a value in the range 0 to 1
inclusive, whereas the <item type="input">PERCENTRANK.EXC</item> function
calculates a value in the range 0 to 1 exclusive.</paragraph>
+<note id="par_id2453976">The difference between <item
type="input">PERCENTRANK.INC</item> and <item
type="input">PERCENTRANK.EXC</item> is that <item
type="input">PERCENTRANK.INC</item> calculates a value in the range 0 to 1
inclusive, whereas the <item type="input">PERCENTRANK.EXC</item> function
calculates a value in the range 0 to 1 exclusive.</note>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2947238"
role="code">PERCENTRANK.INC(Data; Value; Significance)</paragraph>
@@ -465,7 +463,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3166442"><bookmark_value>QUARTILE function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_QUARTILE" id="bm_id3150709"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3166442" role="heading"
level="2">QUARTILE</paragraph>
+<h2 id="hd_id3166442">QUARTILE</h2>
<paragraph xml-lang="en-US" id="par_id3146958" role="paragraph"><ahelp
hid="HID_FUNC_QUARTILE">Returns the quartile of a data set.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3153684" role="code">QUARTILE(Data;
Type)</paragraph>
@@ -479,9 +477,9 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id2866442"><bookmark_value>QUARTILE.EXC function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_QUARTILE_EXC"
id="bm_id2950709" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id2866442" role="heading"
level="2">QUARTILE.EXC</paragraph>
+<h2 id="hd_id2866442">QUARTILE.EXC</h2>
<paragraph xml-lang="en-US" id="par_id2846958" role="paragraph"><ahelp
hid="HID_FUNC_QUARTILE_EXC">Returns a requested quartile of a supplied range of
values, based on a percentile range of 0 to 1 exclusive.</ahelp></paragraph>
-<paragraph xml-lang="en-US" id="par_id2353976" role="note">The difference
between <item type="input">QUARTILE.INC</item> and <item
type="input">QUARTILE.EXC</item> is that the <item
type="input">QUARTILE.INC</item> function bases its calculation on a percentile
range of 0 to 1 inclusive, whereas the <item type="input">QUARTILE.EXC</item>
function bases its calculation on a percentile range of 0 to 1
exclusive.</paragraph>
+<note id="par_id2353976">The difference between <item
type="input">QUARTILE.INC</item> and <item type="input">QUARTILE.EXC</item> is
that the <item type="input">QUARTILE.INC</item> function bases its calculation
on a percentile range of 0 to 1 inclusive, whereas the <item
type="input">QUARTILE.EXC</item> function bases its calculation on a percentile
range of 0 to 1 exclusive.</note>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2853684" role="code">QUARTILE.EXC(Data;
Type)</paragraph>
@@ -495,9 +493,9 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id2966442"><bookmark_value>QUARTILE.INC function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_QUARTILE_INC"
id="bm_id2950309" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id2966442" role="heading"
level="2">QUARTILE.INC</paragraph>
+<h2 id="hd_id2966442">QUARTILE.INC</h2>
<paragraph xml-lang="en-US" id="par_id2946958" role="paragraph"><ahelp
hid="HID_FUNC_QUARTILE_INC">Returns the quartile of a data
set.</ahelp></paragraph>
-<paragraph xml-lang="en-US" id="par_id2253976" role="note">The difference
between <item type="input">QUARTILE.INC</item> and <item
type="input">QUARTILE.EXC</item> is that the <item
type="input">QUARTILE.INC</item> function bases its calculation on a percentile
range of 0 to 1 inclusive, whereas the <item type="input">QUARTILE.EXC</item>
function bases its calculation on a percentile range of 0 to 1
exclusive.</paragraph>
+<note id="par_id2253976">The difference between <item
type="input">QUARTILE.INC</item> and <item type="input">QUARTILE.EXC</item> is
that the <item type="input">QUARTILE.INC</item> function bases its calculation
on a percentile range of 0 to 1 inclusive, whereas the <item
type="input">QUARTILE.EXC</item> function bases its calculation on a percentile
range of 0 to 1 exclusive.</note>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2953684" role="code">QUARTILE.INC(Data;
Type)</paragraph>
diff --git a/source/text/scalc/01/04060185.xhp
b/source/text/scalc/01/04060185.xhp
index 9d5c12c76..92117446e 100644
--- a/source/text/scalc/01/04060185.xhp
+++ b/source/text/scalc/01/04060185.xhp
@@ -27,15 +27,15 @@
</topic>
</meta>
<body>
- <paragraph xml-lang="en-US" id="hd_id3147072" role="heading"
level="1"><variable id="rz"><link href="text/scalc/01/04060185.xhp"
name="Statistical Functions Part Five">Statistical Functions Part Five</link>
-</variable></paragraph>
+ <h1 id="hd_id3147072"><variable id="rz"><link
href="text/scalc/01/04060185.xhp" name="Statistical Functions Part
Five">Statistical Functions Part Five</link>
+</variable></h1>
<sort order="asc">
<section id="rank">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3155071"><bookmark_value>RANK function</bookmark_value>
<bookmark_value>numbers;determining ranks</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RANG" id="bm_id3146778"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3155071" role="heading"
level="2">RANK</paragraph>
+<h2 id="hd_id3155071">RANK</h2>
<paragraph xml-lang="en-US" id="par_id3153976"
role="paragraph"><ahelp hid="HID_FUNC_RANG">Returns the rank of a number in a
sample.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3153250"
role="code">RANK(Value; Data; Type)</paragraph>
@@ -57,9 +57,9 @@
<bookmark_value>numbers;determining ranks</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RANK_AVG" id="bm_id2946778"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id2955071" role="heading"
level="2">RANK.AVG</paragraph>
+<h2 id="hd_id2955071">RANK.AVG</h2>
<paragraph xml-lang="en-US" id="par_id2953976" role="paragraph"><ahelp
hid="HID_FUNC_RANK_AVG">Returns the statistical rank of a given value, within a
supplied array of values.</ahelp> If there are duplicate values in the list,
the average rank is returned.</paragraph>
-<paragraph xml-lang="en-US" id="par_id2653976" role="note">The difference
between <item type="input">RANK.AVG</item> and <item
type="input">RANK.EQ</item> occurs when there are duplicates in the list of
values. The <item type="input">RANK.EQ</item> function returns the lower rank,
whereas the <item type="input">RANK.AVG</item> function returns the average
rank.</paragraph>
+<note id="par_id2653976">The difference between <item
type="input">RANK.AVG</item> and <item type="input">RANK.EQ</item> occurs when
there are duplicates in the list of values. The <item
type="input">RANK.EQ</item> function returns the lower rank, whereas the <item
type="input">RANK.AVG</item> function returns the average rank.</note>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2953250" role="code">RANK.AVG(Value;
Data; Type)</paragraph>
@@ -77,9 +77,9 @@
<bookmark_value>numbers;determining ranks</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RANK_EQ" id="bm_id2846778"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id2855071" role="heading"
level="2">RANK.EQ</paragraph>
+<h2 id="hd_id2855071">RANK.EQ</h2>
<paragraph xml-lang="en-US" id="par_id2853976" role="paragraph"><ahelp
hid="HID_FUNC_RANK_EQ">Returns the statistical rank of a given value, within a
supplied array of values.</ahelp> If there are duplicate values in the list,
these are given the same rank.</paragraph>
-<paragraph xml-lang="en-US" id="par_id2753976" role="note">The difference
between <item type="input">RANK.AVG</item> and <item
type="input">RANK.EQ</item> occurs when there are duplicates in the list of
values. The <item type="input">RANK.EQ</item> function returns the lower rank,
whereas the <item type="input">RANK.AVG</item> function returns the average
rank.</paragraph>
+<note id="par_id2753976">The difference between <item
type="input">RANK.AVG</item> and <item type="input">RANK.EQ</item> occurs when
there are duplicates in the list of values. The <item
type="input">RANK.EQ</item> function returns the lower rank, whereas the <item
type="input">RANK.AVG</item> function returns the average rank.</note>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2853250" role="code">RANK.EQ(Value;
Data; Type)</paragraph>
@@ -95,7 +95,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3153556"><bookmark_value>SKEW function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SCHIEFE" id="bm_id3153801"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153556" role="heading"
level="2">SKEW</paragraph>
+<h2 id="hd_id3153556">SKEW</h2>
<paragraph xml-lang="en-US" id="par_id3153485"
role="paragraph"><ahelp hid="HID_FUNC_SCHIEFE">Returns the skewness of a
distribution.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3151191"
role="code">SKEW(Number1; Number2; ...; Number30)</paragraph>
@@ -106,7 +106,7 @@
<item type="input">=SKEW(A1:A50)</item> calculates the value of
skew for the data referenced.</paragraph>
</section>
<section id="skewp">
- <paragraph id="hd_id72921349523046" role="heading" level="2"
localize="false" xml-lang="en-US"></paragraph>
+ <h2 id="hd_id72921349523046"/>
<embed href="text/scalc/01/func_skewp.xhp#skewp_function"/>
</section>
<section id="forecast">
@@ -115,7 +115,7 @@
<bookmark_value>FORECAST function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SCHAETZER"
id="bm_id3146102" localize="false"/><comment>mw made "regression lines" a two
level entry</comment>
-<paragraph xml-lang="en-US" id="hd_id3149051" role="heading"
level="2">FORECAST</paragraph>
+<h2 id="hd_id3149051">FORECAST</h2>
<paragraph xml-lang="en-US" id="par_id3153290"
role="paragraph"><ahelp hid="HID_FUNC_SCHAETZER">Extrapolates future values
based on existing x and y values.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3147404"
role="code">FORECAST(Value; DataY; DataX)</paragraph>
@@ -135,7 +135,7 @@
<bookmark_value>FORECAST.LINEAR function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FORECAST_LIN"
id="bm_id3146102" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3149052" role="heading"
level="2">FORECAST.LINEAR</paragraph>
+<h2 id="hd_id3149052">FORECAST.LINEAR</h2>
<paragraph xml-lang="en-US" id="par_id3153291"
role="paragraph"><ahelp hid="HID_FUNC_SCHAETZER">Extrapolates future values
based on existing x and y values.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3147405"
role="code">FORECAST.LINEAR(Value; DataY; DataX)</paragraph>
@@ -154,7 +154,7 @@
<bookmark_value>standard deviations in statistics;based on a
sample</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STABW" id="bm_id3153121"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3149143" role="heading"
level="2">STDEV</paragraph>
+<h2 id="hd_id3149143">STDEV</h2>
<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>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3149946"
role="code">STDEV(Number1; Number2; ...; Number30)</paragraph>
@@ -168,7 +168,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3144745"><bookmark_value>STDEVA function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STABWA" id="bm_id3154846"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3144745" role="heading"
level="2">STDEVA</paragraph>
+<h2 id="hd_id3144745">STDEVA</h2>
<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>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3147422"
role="code">STDEVA(Value1; Value2; ...; Value30)</paragraph>
@@ -183,7 +183,7 @@
<bookmark_value>standard deviations in statistics;based on a
population</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STABWN" id="bm_id3146139"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3149734" role="heading"
level="2">STDEVP</paragraph>
+<h2 id="hd_id3149734">STDEVP</h2>
<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>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3154392"
role="code">STDEVP(Number1; Number2; ...; Number30)</paragraph>
@@ -199,7 +199,7 @@
<bookmark_value>standard deviations in statistics;based on a
population</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ST_DEV_P_MS"
id="bm_id2946139" localize="false"/>
- <paragraph xml-lang="en-US" id="hd_id2949734" role="heading"
level="2">STDEV.P</paragraph>
+ <h2 id="hd_id2949734">STDEV.P</h2>
<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>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -214,7 +214,7 @@
<bookmark_value>standard deviations in statistics;based on a
sample</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ST_DEV_S"
id="bm_id2846139" localize="false"/>
- <paragraph xml-lang="en-US" id="hd_id2849734" role="heading"
level="2">STDEV.S</paragraph>
+ <h2 id="hd_id2849734">STDEV.S</h2>
<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>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -227,7 +227,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3154522"><bookmark_value>STDEVPA function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STABWNA" id="bm_id3150902"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3154522" role="heading"
level="2">STDEVPA</paragraph>
+<h2 id="hd_id3154522">STDEVPA</h2>
<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>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3146851"
role="code">STDEVPA(Value1; Value2; ...; Value30)</paragraph>
@@ -242,7 +242,7 @@
<bookmark_value>converting;random variables, into normalized
values</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STANDARDISIERUNG"
id="bm_id3148764" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3155928" role="heading"
level="2">STANDARDIZE</paragraph>
+<h2 id="hd_id3155928">STANDARDIZE</h2>
<paragraph xml-lang="en-US" id="par_id3149883"
role="paragraph"><ahelp hid="HID_FUNC_STANDARDISIERUNG">Converts a random
variable to a normalized value.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3150132"
role="code">STANDARDIZE(Number; Mean; StDev)</paragraph>
@@ -261,7 +261,7 @@
<bookmark_value>normal distribution;inverse of
standard</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STANDNORMINV"
id="bm_id3148389" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3157986" role="heading"
level="2">NORMSINV</paragraph>
+<h2 id="hd_id3157986">NORMSINV</h2>
<paragraph xml-lang="en-US" id="par_id3151282"
role="paragraph"><ahelp hid="HID_FUNC_STANDNORMINV">Returns the inverse of the
standard normal cumulative distribution.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3154195"
role="code">NORMSINV(Number)</paragraph>
@@ -276,7 +276,7 @@
<bookmark_value>normal distribution;inverse of
standard</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STD_NORMINV_MS"
id="bm_id2948389" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id2957986" role="heading"
level="2">NORM.S.INV</paragraph>
+<h2 id="hd_id2957986">NORM.S.INV</h2>
<paragraph xml-lang="en-US" id="par_id2951282"
role="paragraph"><ahelp hid="HID_FUNC_STD_NORMINV_MS">Returns the inverse of
the standard normal cumulative distribution.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -292,7 +292,7 @@
<bookmark_value>normal distribution;statistics</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STANDNORMVERT"
id="bm_id3145269" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3147538" role="heading"
level="2">NORMSDIST</paragraph>
+<h2 id="hd_id3147538">NORMSDIST</h2>
<paragraph xml-lang="en-US" id="par_id3150474"
role="paragraph"><ahelp hid="HID_FUNC_STANDNORMVERT">Returns the standard
normal cumulative distribution function. The distribution has a mean of zero
and a standard deviation of one.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id8652302" role="paragraph">It is
GAUSS(x)=NORMSDIST(x)-0.5</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -308,7 +308,7 @@
<bookmark_value>normal distribution;statistics</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STD_NORMDIST_MS"
id="bm_id2945269" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id2947538" role="heading"
level="2">NORM.S.DIST</paragraph>
+<h2 id="hd_id2947538">NORM.S.DIST</h2>
<paragraph xml-lang="en-US" id="par_id2950474"
role="paragraph"><ahelp hid="HID_FUNC_STD_NORMDIST_MS">Returns the standard
normal cumulative distribution function. The distribution has a mean of zero
and a standard deviation of one.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -327,7 +327,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3152592"><bookmark_value>SLOPE function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STEIGUNG" id="bm_id3153716"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3152592" role="heading"
level="2">SLOPE</paragraph>
+<h2 id="hd_id3152592">SLOPE</h2>
<paragraph xml-lang="en-US" id="par_id3150386"
role="paragraph"><ahelp hid="HID_FUNC_STEIGUNG">Returns the slope of the linear
regression line.</ahelp> The slope is adapted to the data points set in the y
and x values.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3149819"
role="code">SLOPE(DataY; DataX)</paragraph>
@@ -345,7 +345,7 @@
<bookmark_value>standard errors;statistical functions</bookmark_value>
</bookmark><comment>mw changed "standard errors"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STFEHLERYX"
id="bm_id3150964" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3155836" role="heading"
level="2">STEYX</paragraph>
+<h2 id="hd_id3155836">STEYX</h2>
<paragraph xml-lang="en-US" id="par_id3149446"
role="paragraph"><ahelp hid="HID_FUNC_STFEHLERYX">Returns the standard error of
the predicted y value for each x in the regression.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3151267"
role="code">STEYX(DataY; DataX)</paragraph>
@@ -363,12 +363,11 @@
<bookmark_value>sums;of squares of deviations</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMQUADABW"
id="bm_id3156317" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3150873" role="heading"
level="2">DEVSQ</paragraph>
+<h2 id="hd_id3150873">DEVSQ</h2>
<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>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <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> are numerical values
or ranges representing a sample.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3146790"
role="code">DEVSQ(<embedvar href="text/scalc/01/ful_func.xhp#number255_1"
markup="keep"/>)</paragraph>
+ <embed href="text/scalc/01/ful_func.xhp#number255"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3149136" role="paragraph">
<item type="input">=DEVSQ(A1:A50)</item>
@@ -379,7 +378,7 @@
<bookmark_value>inverse of t-distribution</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TINV" id="bm_id3153155"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3149579" role="heading"
level="2">TINV</paragraph>
+<h2 id="hd_id3149579">TINV</h2>
<paragraph xml-lang="en-US" id="par_id3143232"
role="paragraph"><ahelp hid="HID_FUNC_TINV">Returns the inverse of the
t-distribution.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3149289"
role="code">TINV(Number; DegreesFreedom)</paragraph>
@@ -397,7 +396,7 @@
<bookmark_value>one tailed inverse of t-distribution</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TINV_MS"
id="bm_id2953155" localize="false"/>
- <paragraph xml-lang="en-US" id="hd_id2949579" role="heading"
level="2">T.INV</paragraph>
+ <h2 id="hd_id2949579">T.INV</h2>
<paragraph xml-lang="en-US" id="par_id2943232" role="paragraph"><ahelp
hid="HID_FUNC_TINV_MS">Returns the one tailed inverse of the
t-distribution.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -413,7 +412,7 @@
<bookmark_value>inverse of two tailed t-distribution</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TINV_2T"
id="bm_id2853155" localize="false"/>
- <paragraph xml-lang="en-US" id="hd_id2849579" role="heading"
level="2">T.INV.2T</paragraph>
+ <h2 id="hd_id2849579">T.INV.2T</h2>
<paragraph xml-lang="en-US" id="par_id2843232" role="paragraph"><ahelp
hid="HID_FUNC_TINV_2T">Calculates the inverse of the two-tailed Student's T
Distribution </ahelp>, which is a continuous probability distribution that is
frequently used for testing hypotheses on small sample data sets.</paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -427,7 +426,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3154129"><bookmark_value>TTEST function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TTEST" id="bm_id3153981"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3154129" role="heading"
level="2">TTEST</paragraph>
+<h2 id="hd_id3154129">TTEST</h2>
<paragraph xml-lang="en-US" id="par_id3159184"
role="paragraph"><ahelp hid="HID_FUNC_TTEST">Returns the probability associated
with a Student's t-Test.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3151175"
role="code">TTEST(Data1; Data2; Mode; Type)</paragraph>
@@ -449,7 +448,7 @@
<bookmark_value>T.TEST function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TTEST_MS"
id="bm_id2953981" localize="false"/>
- <paragraph xml-lang="en-US" id="hd_id2954129" role="heading"
level="2">T.TEST</paragraph>
+ <h2 id="hd_id2954129">T.TEST</h2>
<paragraph xml-lang="en-US" id="par_id2959184" role="paragraph"><ahelp
hid="HID_FUNC_TTEST_MS">Returns the probability associated with a Student's
t-Test.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -466,7 +465,7 @@
<bookmark_value>t-distribution</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TVERT" id="bm_id3153095"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3154930" role="heading"
level="2">TDIST</paragraph>
+<h2 id="hd_id3154930">TDIST</h2>
<paragraph xml-lang="en-US" id="par_id3153372"
role="paragraph"><ahelp hid="HID_FUNC_TVERT">Returns the
t-distribution.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3150521"
role="code">TDIST(Number; DegreesFreedom; Mode)</paragraph>
@@ -487,7 +486,7 @@
<bookmark_value>t-distribution</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TDIST_MS"
id="bm_id2953095" localize="false"/>
- <paragraph xml-lang="en-US" id="hd_id2954930" role="heading"
level="2">T.DIST</paragraph>
+ <h2 id="hd_id2954930">T.DIST</h2>
<paragraph xml-lang="en-US" id="par_id2953372" role="paragraph"><ahelp
hid="HID_FUNC_TDIST_MS">Returns the t-distribution.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -504,7 +503,7 @@
<bookmark_value>two tailed t-distribution</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TDIST_2T"
id="bm_id2853095" localize="false"/>
- <paragraph xml-lang="en-US" id="hd_id2854930" role="heading"
level="2">T.DIST.2T</paragraph>
+ <h2 id="hd_id2854930">T.DIST.2T</h2>
<paragraph xml-lang="en-US" id="par_id2853372" role="paragraph"><ahelp
hid="HID_FUNC_TDIST_2T">Calculates the two-tailed Student's T Distribution,
which is a continuous probability distribution that is frequently used for
testing hypotheses on small sample data sets.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -520,7 +519,7 @@
<bookmark_value>right tailed t-distribution</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TDIST_RT"
id="bm_id273095" localize="false"/>
- <paragraph xml-lang="en-US" id="hd_id274930" role="heading"
level="2">T.DIST.RT</paragraph>
+ <h2 id="hd_id274930">T.DIST.RT</h2>
<paragraph xml-lang="en-US" id="par_id2753372" role="paragraph"><ahelp
hid="HID_FUNC_TDIST_RT">Calculates the right-tailed Student's T Distribution,
which is a continuous probability distribution that is frequently used for
testing hypotheses on small sample data sets.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -535,7 +534,7 @@
<bookmark_value>variances</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIANZ" id="bm_id3154898"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153828" role="heading"
level="2">VAR</paragraph>
+<h2 id="hd_id3153828">VAR</h2>
<paragraph xml-lang="en-US" id="par_id3159165"
role="paragraph"><ahelp hid="HID_FUNC_VARIANZ">Estimates the variance based on
a sample.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3153054"
role="code">VAR(Number1 ; Number2; ...; Number30)</paragraph>
@@ -552,7 +551,7 @@
<bookmark_value>variances</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VAR_S"
id="bm_id2954898" localize="false"/>
- <paragraph xml-lang="en-US" id="hd_id2953828" role="heading"
level="2">VAR.S</paragraph>
+ <h2 id="hd_id2953828">VAR.S</h2>
<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>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -565,7 +564,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3151045"><bookmark_value>VARA function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIANZA" id="bm_id3148473"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3151045" role="heading"
level="2">VARA</paragraph>
+<h2 id="hd_id3151045">VARA</h2>
<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>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3149999"
role="code">VARA(Value1; Value2; ...; Value30)</paragraph>
@@ -580,7 +579,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3166441"><bookmark_value>VARP function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIANZEN"
id="bm_id3152359" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3166441" role="heading"
level="2">VARP</paragraph>
+<h2 id="hd_id3166441">VARP</h2>
<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>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3147282"
role="code">VARP(Number1; Number2; ...; Number30)</paragraph>
@@ -596,7 +595,7 @@
<bookmark_value>VAR.P function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VAR_P_MS"
id="bm_id2952359" localize="false"/>
- <paragraph xml-lang="en-US" id="hd_id2966441" role="heading"
level="2">VAR.P</paragraph>
+ <h2 id="hd_id2966441">VAR.P</h2>
<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>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -609,7 +608,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3153688"><bookmark_value>VARPA function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIANZENA"
id="bm_id3159276" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153688" role="heading"
level="2">VARPA</paragraph>
+<h2 id="hd_id3153688">VARPA</h2>
<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>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3149967"
role="code">VARPA(Value1; Value2; ...; Value30)</paragraph>
@@ -625,7 +624,7 @@
<bookmark_value>number of permutations</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIATIONEN"
id="bm_id3154610" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3154599" role="heading"
level="2">PERMUT</paragraph>
+<h2 id="hd_id3154599">PERMUT</h2>
<paragraph xml-lang="en-US" id="par_id3154334"
role="paragraph"><ahelp hid="HID_FUNC_VARIATIONEN">Returns the number of
permutations for a given number of objects.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3148466"
role="code">PERMUT(Count1; Count2)</paragraph>
@@ -641,7 +640,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3143276"><bookmark_value>PERMUTATIONA function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIATIONEN2"
id="bm_id3153531" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3143276" role="heading"
level="2">PERMUTATIONA</paragraph>
+<h2 id="hd_id3143276">PERMUTATIONA</h2>
<paragraph xml-lang="en-US" id="par_id3144759"
role="paragraph"><ahelp hid="HID_FUNC_VARIATIONEN2">Returns the number of
permutations for a given number of objects (repetition
allowed).</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3149298"
role="code">PERMUTATIONA(Count1; Count2)</paragraph>
@@ -660,7 +659,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3152952"><bookmark_value>PROB function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WAHRSCHBEREICH"
id="bm_id3152963" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3152952" role="heading"
level="2">PROB</paragraph>
+<h2 id="hd_id3152952">PROB</h2>
<paragraph xml-lang="en-US" id="par_id3154110"
role="paragraph"><ahelp hid="HID_FUNC_WAHRSCHBEREICH">Returns the probability
that values in a range are between two limits.</ahelp> If there is no <item
type="literal">End</item> value, this function calculates the probability based
on the principle that the Data values are equal to the value of <item
type="literal">Start</item>.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3147330" role="code">PROB(Data;
Probability; Start; End)</paragraph>
@@ -680,7 +679,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3150941"><bookmark_value>WEIBULL function</bookmark_value>
</bookmark>
<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>
+<h2 id="hd_id3150941">WEIBULL</h2>
<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_id0305200911372777"
role="paragraph">If C is 0, WEIBULL calculates the probability density
function.</paragraph>
@@ -705,7 +704,7 @@
<bookmark_value>WEIBULL.DIST function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WEIBULL_DIST_MS"
id="bm_id3150406" localize="false"/>
- <paragraph xml-lang="en-US" id="hd_id2950941" role="heading"
level="2">WEIBULL.DIST</paragraph>
+ <h2 id="hd_id2950941">WEIBULL.DIST</h2>
<paragraph xml-lang="en-US" id="par_id2954916" role="paragraph"><ahelp
hid="HID_FUNC_WEIBULL_DIST_MS">Returns the values of the Weibull
distribution.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id2905200911372767"
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_id2905200911372777"
role="paragraph">If C is 0, WEIBULL.DIST calculates the probability density
function.</paragraph>
diff --git a/source/text/scalc/01/ful_func.xhp
b/source/text/scalc/01/ful_func.xhp
index 1d1e29f85..57c79fc04 100644
--- a/source/text/scalc/01/ful_func.xhp
+++ b/source/text/scalc/01/ful_func.xhp
@@ -54,6 +54,10 @@
<section id="integer255">
<paragraph role="paragraph" id="par_id1001584395844941"><emph>Integer
1[; Integer 2][; … ;[Integer 255]]</emph> are integers, references to cells or
to cell ranges of integers.</paragraph>
</section>
+ <paragraph role="paragraph" id="par_id101584447971004"><variable
id="number254_1">Number 1[; Number 2][; … ;[Number 254]]</variable></paragraph>
+ <section id="number254">
+ <paragraph role="paragraph" id="par_id931584305947010"><emph>Number
1[; Number 2][; … ;[Number 254]]</emph> are numbers, references to cells or to
cell ranges of numbers.</paragraph>
+ </section>
<paragraph role="paragraph" id="par_id101584447970004"><variable
id="number255_1">Number 1[; Number 2][; … ;[Number 255]]</variable></paragraph>
<section id="number255">
<paragraph role="paragraph" id="par_id931584395947010"><emph>Number
1[; Number 2][; … ;[Number 255]]</emph> are numbers, references to cells or to
cell ranges of numbers.</paragraph>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
