diff options
| author | Steve Fanning <stevemfanning.wh@gmail.com> | 2020-03-24 20:04:52 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2020-03-25 22:27:29 +0100 |
| commit | dac90072fecdfa76352153616f102d3229b5512e (patch) | |
| tree | 0f87523364419d523af7a79ac2d52930b73a553b /source/text/scalc/01/04060184.xhp | |
| parent | Correct arguments for TEXTJOIN (diff) | |
| download | help-dac90072fecdfa76352153616f102d3229b5512e.tar.gz help-dac90072fecdfa76352153616f102d3229b5512e.zip | |
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.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc/01/04060184.xhp')
| -rw-r--r-- | source/text/scalc/01/04060184.xhp | 106 |
1 files changed, 52 insertions, 54 deletions
diff --git a/source/text/scalc/01/04060184.xhp b/source/text/scalc/01/04060184.xhp index 9f7e210a05..9f9cf63e8c 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> |