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.blanco@youmail.dk>

5 files changed, 17 insertions, 2 deletions

diff --git a/source/text/scalc/01/04060181.xhp b/source/text/scalc/01/04060181.xhp
index 2dd591ea4b..a6ac2baedc 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 fea713ec05..a324f5681e 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 b4eb4c6f25..c543cf5393 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 65bfaec408..ce6d078ea9 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 23b7f93e71..5a9cf51ae4 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>