source/text/scalc/01/04060184.xhp | 35 +++++++++++++++++++---------------- source/text/scalc/01/04060185.xhp | 7 ++++--- source/text/scalc/01/func_skewp.xhp | 9 +++++---- 3 files changed, 28 insertions(+), 23 deletions(-)
New commits: commit 93c454f904a11777c934250a46ba6d933d2130c7 Author: Steve Fanning <[email protected]> AuthorDate: Wed Mar 25 18:24:55 2020 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Thu Mar 26 13:33:17 2020 +0100 tdf#131361 Adjust number of function parameters (2) Fixes for MAX, MAXA, MEDIAN, MIN, MINA, MODE, MODE.MULT MODE.SNGL, SKEW, SKEWP Change-Id: I2a8727611cf0f9cfeed9f7dbcd88751c81090e46 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91077 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/source/text/scalc/01/04060184.xhp b/source/text/scalc/01/04060184.xhp index 9f9cf63e8..c62fafdd3 100644 --- a/source/text/scalc/01/04060184.xhp +++ b/source/text/scalc/01/04060184.xhp @@ -38,8 +38,8 @@ <paragraph xml-lang="en-US" id="par_id3153709" role="paragraph"><ahelp hid="HID_FUNC_MAX">Returns the maximum value in a list of arguments.</ahelp></paragraph> <paragraph xml-lang="en-US" id="par_id9282509" role="paragraph">Returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN() and MAX(). The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MIN() or MAX(), e.g. MIN("string"), still results in an error.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph xml-lang="en-US" id="par_id3147340" role="code">MAX(Number1; Number2; ...; Number30)</paragraph> -<paragraph xml-lang="en-US" id="par_id3149568" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges. </paragraph> +<paragraph xml-lang="en-US" id="par_id3147340" role="code">MAX(<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_id3147343" role="paragraph"> <item type="input">=MAX(A1;A2;A3;50;100;200)</item> returns the largest value from the list.</paragraph> @@ -54,8 +54,8 @@ <paragraph xml-lang="en-US" id="par_id3150363" role="paragraph"><ahelp hid="HID_FUNC_MAXA">Returns the maximum value in a list of arguments. In opposite to MAX, here you can enter text. The value of the text is 0.</ahelp></paragraph> <paragraph xml-lang="en-US" id="par_id7689443" role="paragraph">The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph xml-lang="en-US" id="par_id3166431" role="code">MAXA(Value1; Value2; ...; Value30)</paragraph> -<paragraph xml-lang="en-US" id="par_id3150202" role="paragraph"><emph>Value1; Value2;...; Value30</emph> are values or ranges. Text has the value of 0.</paragraph> +<paragraph xml-lang="en-US" id="par_id3166431" role="code">MAXA(<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_id3156446" role="paragraph"> <item type="input">=MAXA(A1;A2;A3;50;100;200;"Text")</item> returns the largest value from the list.</paragraph> @@ -69,8 +69,8 @@ <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> -<paragraph xml-lang="en-US" id="par_id3150109" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are values or ranges, which represent a sample. Each number can also be replaced by a reference.</paragraph> +<paragraph xml-lang="en-US" id="par_id3155264" role="code">MEDIAN(<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_id3145078" role="paragraph">for an odd number: <item type="input">=MEDIAN(1;5;9;20;21)</item> returns 9 as the median value.</paragraph> <paragraph xml-lang="en-US" id="par_id3149126" role="paragraph">for an even number: <item type="input">=MEDIAN(1;5;9;20)</item> returns the average of the two middle values 5 and 9, thus 7.</paragraph> @@ -83,8 +83,8 @@ <paragraph xml-lang="en-US" id="par_id3143222" role="paragraph"><ahelp hid="HID_FUNC_MIN">Returns the minimum value in a list of arguments.</ahelp></paragraph> <paragraph xml-lang="en-US" id="par_id2301400" role="paragraph">Returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN() and MAX(). The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MIN() or MAX(), e.g. MIN("string"), still results in an error.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph xml-lang="en-US" id="par_id3146964" role="code">MIN(Number1; Number2; ...; Number30)</paragraph> -<paragraph xml-lang="en-US" id="par_id3153486" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges.</paragraph> +<paragraph xml-lang="en-US" id="par_id3146964" role="code">MIN(<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_id3154734" role="paragraph"> <item type="input">=MIN(A1:B100)</item> returns the smallest value in the list.</paragraph> @@ -97,8 +97,8 @@ <paragraph xml-lang="en-US" id="par_id3147249" role="paragraph"><ahelp hid="HID_FUNC_MINA">Returns the minimum value in a list of arguments. Here you can also enter text. The value of the text is 0.</ahelp></paragraph> <paragraph xml-lang="en-US" id="par_id4294564" role="paragraph">The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph xml-lang="en-US" id="par_id3153336" role="code">MINA(Value1; Value2; ...; Value30)</paragraph> -<paragraph xml-lang="en-US" id="par_id3146098" role="paragraph"><emph>Value1, Value2, ..., Value30</emph> are values or ranges. Text has the value of 0.</paragraph> +<paragraph xml-lang="en-US" id="par_id3153336" role="code">MINA(<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_id3147401" role="paragraph"> <item type="input">=MINA(1;"Text";20)</item> returns 0.</paragraph> @@ -163,8 +163,8 @@ <paragraph xml-lang="en-US" id="par_id3153085" role="paragraph"><ahelp hid="HID_FUNC_MODALWERT">Returns the most common value in a data set.</ahelp> If there are several values with the same frequency, it returns the smallest value. An error occurs when a value doesn't appear twice.</paragraph> <embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph xml-lang="en-US" id="par_id3155950" role="code">MODE(Number1; Number2; ...; Number30)</paragraph> -<paragraph xml-lang="en-US" id="par_id3150337" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges.</paragraph> +<paragraph xml-lang="en-US" id="par_id3155950" role="code">MODE(<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_id3153733" role="paragraph"> <item type="input">=MODE(A1:A50)</item> @@ -180,8 +180,8 @@ <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_id2955950" role="code">MODE.SNGL(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> +<embed href="text/scalc/01/ful_func.xhp#number255"/> <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> @@ -195,8 +195,11 @@ <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_id2855950" role="code">MODE.MULT(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> +<embed href="text/scalc/01/ful_func.xhp#number255"/> + + <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> diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp index 92117446e..056953c3f 100644 --- a/source/text/scalc/01/04060185.xhp +++ b/source/text/scalc/01/04060185.xhp @@ -98,9 +98,10 @@ <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> - <paragraph xml-lang="en-US" id="par_id3155757" role="paragraph"> - <emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges.</paragraph> + + <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#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> diff --git a/source/text/scalc/01/func_skewp.xhp b/source/text/scalc/01/func_skewp.xhp index 733b134d6..e87b514ff 100644 --- a/source/text/scalc/01/func_skewp.xhp +++ b/source/text/scalc/01/func_skewp.xhp @@ -31,13 +31,14 @@ <bookmark_value>skewness;population</bookmark_value> <bookmark_value>SKEWP function</bookmark_value> </bookmark> -<paragraph id="hd_id456845684568" role="heading" level="2" xml-lang="en-US"><variable id="skewp_head"><link href="text/scalc/01/func_skewp.xhp">SKEWP</link></variable></paragraph> +<h2 id="hd_id456845684568"><variable id="skewp_head"><link href="text/scalc/01/func_skewp.xhp">SKEWP</link></variable></h2> <paragraph id="par_id1102201617001848" role="paragraph" xml-lang="en-US"><ahelp hid=".">Calculates the skewness of a distribution using the population of a random variable.</ahelp></paragraph> <embed href="text/scalc/00/avail_release.xhp#4.1"/> + <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> -<paragraph id="par_id27421466710275" role="code" xml-lang="en-US">SKEWP(Number1; Number2; ...; Number30)</paragraph> -<paragraph id="par_id242131304318587" role="paragraph" xml-lang="en-US"><emph>Number1, Number2, ..., Number30</emph> are up to 30 numerical values or ranges.</paragraph> -<paragraph id="par_id242131304315587" role="paragraph" xml-lang="en-US">Calculates the skewness of a distribution using the population, i.e. the possible outcomes, of a random variable. The sequence shall contain three numbers at least.</paragraph> +<paragraph id="par_id27421466710275" role="code" xml-lang="en-US">SKEWP(<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_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/ful_func.xhp#func_head_example"/> <paragraph id="par_id1102201617001888" role="paragraph" xml-lang="en-US"><item type="literal">SKEWP(2;3;1;6;8;5)</item> returns 0.2828158928 _______________________________________________ Libreoffice-commits mailing list [email protected] https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
