summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorSteve Fanning <stevemfanning@yahoo.co.uk>2020-06-01 11:15:37 +0200
committerOlivier Hallot <olivier.hallot@libreoffice.org>2020-06-08 18:57:56 +0200
commita80ec77e17ca9cbf4c4e12affa4d31a7ed412677 (patch)
tree04d517975eb7ce27809e26dffc390e96020ba4e5
parent(04060119.xhp) Include square brackets in syntax sections to indicate optiona... (diff)
downloadhelp-a80ec77e17ca9cbf4c4e12affa4d31a7ed412677.zip
help-a80ec77e17ca9cbf4c4e12affa4d31a7ed412677.tar.gz
(04060182.xhp) Include square brackets in syntax sections to indicate optional parameters.
Also updated GEOMEAN() and HARMEAN() to cater for up to 255 arguments rather than 30. Change-Id: I706f1f8426b04b3ec06064d505116151b55f2b00 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95240 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> (cherry picked from commit 8a1427c35e2392ecfe8ecaee84ab1c24fa5b87ae) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95733 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
-rw-r--r--source/text/scalc/01/04060182.xhp22
1 files changed, 10 insertions, 12 deletions
diff --git a/source/text/scalc/01/04060182.xhp b/source/text/scalc/01/04060182.xhp
index c02ddbb..b6a7843 100644
--- a/source/text/scalc/01/04060182.xhp
+++ b/source/text/scalc/01/04060182.xhp
@@ -172,7 +172,7 @@
<paragraph xml-lang="en-US" id="par_id2952981" role="paragraph"><ahelp hid="HID_FUNC_F_DIST_LT">Calculates the values of the left tail of the F distribution.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_id2945826" role="code">F.DIST(Number; DegreesFreedom1; DegreesFreedom2; Cumulative)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2945826" role="code">F.DIST(Number; DegreesFreedom1; DegreesFreedom2 [; Cumulative])</paragraph>
<paragraph xml-lang="en-US" id="par_id2950461" role="paragraph"><emph>Number</emph> is the value for which the F distribution is to be calculated.</paragraph>
<paragraph xml-lang="en-US" id="par_id2950029" role="paragraph"><emph>degreesFreedom1</emph> is the degrees of freedom in the numerator in the F distribution.</paragraph>
<paragraph xml-lang="en-US" id="par_id2946877" role="paragraph"><emph>degreesFreedom2</emph> is the degrees of freedom in the denominator in the F distribution.</paragraph>
@@ -285,7 +285,7 @@
<paragraph xml-lang="en-US" id="par_id3155931" role="paragraph"><ahelp hid="HID_FUNC_GAMMAVERT">Returns the values of a Gamma distribution.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id0119200903333675" role="paragraph">The inverse function is GAMMAINV.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_id3155436" role="code">GAMMADIST(Number; Alpha; Beta; C)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3155436" role="code">GAMMADIST(Number; Alpha; Beta [; C])</paragraph>
<paragraph xml-lang="en-US" id="par_id3150571" role="paragraph">
<emph>Number</emph> is the value for which the Gamma distribution is to be calculated.</paragraph>
<paragraph xml-lang="en-US" id="par_id3145295" role="paragraph">
@@ -343,9 +343,8 @@
<h2 id="hd_id3148425">GEOMEAN</h2>
<paragraph xml-lang="en-US" id="par_id3156257" role="paragraph"><ahelp hid="HID_FUNC_GEOMITTEL">Returns the geometric mean of a sample.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_id3153720" role="code">GEOMEAN(Number1; Number2; ...; Number30)</paragraph>
- <paragraph xml-lang="en-US" id="par_id3152585" role="paragraph">
- <emph>Number1, Number2, ..., Number30</emph> are numeric arguments or ranges that represent a random sample.</paragraph>
+ <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#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>
@@ -374,7 +373,7 @@
<h2 id="hd_id3153216">ZTEST</h2>
<paragraph xml-lang="en-US" id="par_id3150758" role="paragraph"><ahelp hid="HID_FUNC_GTEST">Calculates the probability of observing a z-statistic greater than the one computed based on a sample.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_id3153274" role="code">ZTEST(Data; mu; Sigma)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3153274" role="code">ZTEST(Data; mu [; Sigma])</paragraph>
<paragraph xml-lang="en-US" id="par_id3156109" role="paragraph">
<emph>Data</emph> is the given sample, drawn from a normally distributed population.</paragraph>
<paragraph xml-lang="en-US" id="par_id3149977" role="paragraph">
@@ -391,7 +390,7 @@
<paragraph xml-lang="en-US" id="par_id2950758" role="paragraph"><ahelp hid="HID_FUNC_Z_TEST_MS">Calculates the probability of observing a z-statistic greater than the one computed based on a sample.</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_id2953274" role="code">Z.TEST(Data; mu; Sigma)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2953274" role="code">Z.TEST(Data; mu [; Sigma])</paragraph>
<paragraph xml-lang="en-US" id="par_id2956109" role="paragraph"><emph>Data</emph> is the given sample, drawn from a normally distributed population.</paragraph>
<paragraph xml-lang="en-US" id="par_id2949977" role="paragraph"><emph>mu</emph> is the known mean of the population.</paragraph>
<paragraph xml-lang="en-US" id="par_id2954740" 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>
@@ -406,10 +405,9 @@
<h2 id="hd_id3153623">HARMEAN</h2>
<paragraph xml-lang="en-US" id="par_id3155102" role="paragraph"><ahelp hid="HID_FUNC_HARMITTEL">Returns the harmonic mean of a data set.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_id3149287" role="code">HARMEAN(Number1; Number2; ...; Number30)</paragraph>
- <paragraph xml-lang="en-US" id="par_id3154303" role="paragraph">
- <emph>Number1, Number2, ..., Number30</emph> are up to 30 values or ranges, that can be used to calculate the harmonic mean.</paragraph>
- <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
+ <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#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>
</section>
@@ -422,7 +420,7 @@
<paragraph xml-lang="en-US" id="par_id3159341" role="paragraph"><ahelp hid="HID_FUNC_HYPGEOMVERT">Returns the hypergeometric distribution.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_id3155388" role="code">HYPGEOMDIST(X; NSample; Successes; NPopulation[; Cumulative])</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3155388" role="code">HYPGEOMDIST(X; NSample; Successes; NPopulation [; Cumulative])</paragraph>
<paragraph xml-lang="en-US" id="par_id3154933" role="paragraph">
<emph>X</emph> is the number of results achieved in the random sample.</paragraph>
<paragraph xml-lang="en-US" id="par_id3153106" role="paragraph">