diff options
| author | Seth Chaiklin <sdc.blanco@youmail.dk> | 2021-03-27 20:47:10 +0100 |
|---|---|---|
| committer | Seth Chaiklin <sdc.blanco@youmail.dk> | 2021-03-27 22:10:40 +0100 |
| commit | 267f7663e5705dcf822f317ad386130b853fd484 (patch) | |
| tree | 25a0d5a8be2fc4cf286e1195203d47390eebd434 /source/text/scalc/01/04060183.xhp | |
| parent | 9535013762e34c86cc4fa19a1ae94d346899a821 (diff) | |
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>
Diffstat (limited to 'source/text/scalc/01/04060183.xhp')
| -rw-r--r-- | source/text/scalc/01/04060183.xhp | 3 |
1 files changed, 3 insertions, 0 deletions
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> |