source/text/scalc/01/04060181.xhp | 1 +
source/text/scalc/01/04060182.xhp | 7 +++++--
source/text/scalc/01/04060183.xhp | 3 +++
source/text/scalc/01/04060185.xhp | 7 +++++++
source/text/scalc/01/func_skewp.xhp | 1 +
5 files changed, 17 insertions(+), 2 deletions(-)
New commits:
commit 267f7663e5705dcf822f317ad386130b853fd484
Author: Seth Chaiklin <sdc.bla...@youmail.dk>
AuthorDate: Sat Mar 27 20:47:10 2021 +0100
Commit: Seth Chaiklin <sdc.bla...@youmail.dk>
CommitDate: Sat Mar 27 22:10:40 2021 +0100
tdf#137715 add "text in data range" note to statistical functions
( scalc/01/04060181.xhp )
COUNT
( scalc/01/04060182.xhp )
FTEST, GEOMEAN, HARMEAN, TRIMMEAN, ZTEST
( scalc/01/04060183.xhp )
KURT, LARGE, SMALL
( scalc/01/04060185.xhp )
DEVSQ, STDEVP, VAR, VARP, RANK, SKEW, STDEV
( scalc/01/func_skewp.xhp )
SKEWP
Change-Id: I4ddfadff93bb39ff426f8d6887009cdf6c261e08
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/113218
Tested-by: Jenkins
Reviewed-by: Seth Chaiklin <sdc.bla...@youmail.dk>
diff --git a/source/text/scalc/01/04060181.xhp
b/source/text/scalc/01/04060181.xhp
index 2dd591ea4..a6ac2baed 100644
--- a/source/text/scalc/01/04060181.xhp
+++ b/source/text/scalc/01/04060181.xhp
@@ -68,6 +68,7 @@
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<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#datenumbersequencenote"/>
<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>
diff --git a/source/text/scalc/01/04060182.xhp
b/source/text/scalc/01/04060182.xhp
index fea713ec0..a324f5681 100644
--- a/source/text/scalc/01/04060182.xhp
+++ b/source/text/scalc/01/04060182.xhp
@@ -1,6 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,7 +18,6 @@
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
<meta>
<topic id="textscalc0104060182xml" indexer="include">
<title xml-lang="en-US" id="tit">Statistical Functions Part
Two</title>
@@ -126,6 +124,7 @@
<emph>Data1</emph> is the first record array.</paragraph>
<paragraph xml-lang="en-US" id="par_id3153018" role="paragraph">
<emph>Data2</emph> is the second record array.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3159126" role="paragraph">
<item type="input">=FTEST(A1:A30;B1:B12)</item> calculates whether
the two data sets are different in their variance and returns the probability
that both sets could have come from the same total population.</paragraph>
@@ -345,6 +344,7 @@
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3153720"
role="code">GEOMEAN(<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#datenumbersequencenote"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<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>
@@ -362,6 +362,7 @@
<emph>Data</emph> is the array of data in the sample.</paragraph>
<paragraph xml-lang="en-US" id="par_id3156304" role="paragraph">
<emph>Alpha</emph> is the percentage of the marginal data that
will not be taken into consideration.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3156130" role="paragraph">
<item type="input">=TRIMMEAN(A1:A50; 0.1)</item> calculates the
mean value of numbers in A1:A50, without taking into consideration the 5
percent of the values representing the highest values and the 5 percent of the
values representing the lowest ones. The percentage numbers refer to the amount
of the untrimmed mean value, not to the number of summands.</paragraph>
@@ -381,6 +382,7 @@
<paragraph xml-lang="en-US" id="par_id3154740" role="paragraph">
<emph>Sigma</emph> (optional) is the known standard deviation of
the population. If omitted, the standard deviation of the given sample is
used.</paragraph>
<paragraph xml-lang="en-US" id="par_id0305200911372999"
role="paragraph">See also the <link
href="https://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_ZTEST_function";
name="wiki.documentfoundation.org Documentation/HowTo/Calc/ZTEST
function">Wiki page</link>.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
</section>
<section id="zdottest">
<bookmark xml-lang="en-US" branch="index"
id="bm_id2953216"><bookmark_value>Z.TEST function</bookmark_value>
@@ -407,6 +409,7 @@
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3149287"
role="code">HARMEAN(<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#datenumbersequencenote"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<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 b4eb4c6f2..c543cf539 100644
--- a/source/text/scalc/01/04060183.xhp
+++ b/source/text/scalc/01/04060183.xhp
@@ -41,6 +41,7 @@
<paragraph role="code" id="par_id3154372" xml-lang="en-US">LARGE(Data;
RankC)</paragraph>
<paragraph role="paragraph" id="par_id3152986"
xml-lang="en-US"><emph>Data</emph> is the cell range of data.</paragraph>
<paragraph role="paragraph" id="par_id3156448"
xml-lang="en-US"><emph>RankC</emph> is the ranking of the value. If RankC is an
array, the function becomes an <link href="text/scalc/01/04060107.xhp"
name="array function">array function</link>.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3148702"
xml-lang="en-US"><input>=LARGE(A1:C50;2)</input> gives the second largest value
in A1:C50.</paragraph>
<paragraph role="paragraph" id="par_id3248702"
xml-lang="en-US"><input>=LARGE(A1:C50;B1:B5)</input> entered as an array
function gives an array of the c-th largest value in A1:C50 with ranks defined
in B1:B5.</paragraph>
@@ -56,6 +57,7 @@
<paragraph role="code" id="par_id3153974" xml-lang="en-US">SMALL(Data;
RankC)</paragraph>
<paragraph role="paragraph" id="par_id3154540"
xml-lang="en-US"><emph>Data</emph> is the cell range of data.</paragraph>
<paragraph role="paragraph" id="par_id3155094"
xml-lang="en-US"><emph>RankC</emph> is the rank of the value. If RankC is an
array, the function becomes an <link href="text/scalc/01/04060107.xhp"
name="array function">array function</link>.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3149897"
xml-lang="en-US"><input>=SMALL(A1:C50;2)</input> gives the second smallest
value in A1:C50.</paragraph>
<paragraph role="paragraph" id="par_id3249897"
xml-lang="en-US"><input>=SMALL(A1:C50;B1:B5)</input> entered as an array
function gives an array of the c-th smallest value in A1:C50 with ranks defined
in B1:B5.</paragraph>
@@ -210,6 +212,7 @@
<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#datenumbersequencenote"/>
<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>
diff --git a/source/text/scalc/01/04060185.xhp
b/source/text/scalc/01/04060185.xhp
index 65bfaec40..ce6d078ea 100644
--- a/source/text/scalc/01/04060185.xhp
+++ b/source/text/scalc/01/04060185.xhp
@@ -47,6 +47,7 @@
<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_id9996948" role="paragraph">Type
= 1 means ascending from the first item of the range to the last.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3155919" role="paragraph">
<item type="input">=RANK(A10;A1:A50)</item> returns the ranking of
the value in A10 in value range A1:A50. If <item type="literal">Value</item>
does not exist within the range an error message is displayed.</paragraph>
@@ -102,6 +103,7 @@
<paragraph xml-lang="en-US" id="par_id3151191"
role="code">SKEW(<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_id171585151428396" role="paragraph"
xml-lang="en-US">The parameters should specify at least three
values.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<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>
@@ -160,6 +162,7 @@
<paragraph xml-lang="en-US" id="par_id3149946"
role="code">STDEV(<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_id211585163957345" role="paragraph"
xml-lang="en-US">The parameters should specify at least two values.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3149434"
role="paragraph"><input>=STDEV(A1:A50)</input> returns the estimated standard
deviation based on the data referenced.</paragraph>
</section>
@@ -189,6 +192,7 @@
<paragraph xml-lang="en-US" id="par_id3154392"
role="code">STDEVP(<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#datenumbersequencenote"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<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>
@@ -371,6 +375,7 @@
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<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#datenumbersequencenote"/>
<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>
@@ -544,6 +549,7 @@
<paragraph xml-lang="en-US" id="par_id3153054"
role="code">VAR(<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_id721585215582420" role="paragraph"
xml-lang="en-US">The parameters should specify at least two values.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3153575" role="paragraph">
<item type="input">=VAR(A1:A50)</item>
@@ -589,6 +595,7 @@
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3147282"
role="code">VARP(<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#datenumbersequencenote"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3153385" role="paragraph">
<item type="input">=VARP(A1:A50)</item>
diff --git a/source/text/scalc/01/func_skewp.xhp
b/source/text/scalc/01/func_skewp.xhp
index 23b7f93e7..5a9cf51ae 100644
--- a/source/text/scalc/01/func_skewp.xhp
+++ b/source/text/scalc/01/func_skewp.xhp
@@ -40,6 +40,7 @@
<embed href="text/scalc/01/ful_func.xhp#number255"/>
<paragraph id="par_id242131304315587" role="paragraph" xml-lang="en-US">The
parameters should specify at least three values.</paragraph>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
+<embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
<paragraph id="par_id1102201617001888" role="paragraph"
xml-lang="en-US"><input>SKEWP(2;3;1;6;8;5)</input> returns
0.2329985562</paragraph>
<paragraph id="par_id1102201618185378" role="paragraph"
xml-lang="en-US"><input>SKEWP(A1:A6)</input> returns 0.2329985562, when the
range A1:A6 contains {2;3;1;6;8;5}</paragraph>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
