source/text/scalc/01/04060182.xhp | 22 ++++++++++------------
1 file changed, 10 insertions(+), 12 deletions(-)
New commits:
commit 8a1427c35e2392ecfe8ecaee84ab1c24fa5b87ae
Author: Steve Fanning <stevemfann...@yahoo.co.uk>
AuthorDate: Mon Jun 1 11:15:37 2020 +0200
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Mon Jun 1 15:16:17 2020 +0200
(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.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/04060182.xhp
b/source/text/scalc/01/04060182.xhp
index c02ddbbc0..b6a78433b 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">
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
