From a80ec77e17ca9cbf4c4e12affa4d31a7ed412677 Mon Sep 17 00:00:00 2001 From: Steve Fanning Date: Mon, 1 Jun 2020 11:15:37 +0200 Subject: (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 (cherry picked from commit 8a1427c35e2392ecfe8ecaee84ab1c24fa5b87ae) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95733 Reviewed-by: Ilmari Lauhakangas --- source/text/scalc/01/04060182.xhp | 22 ++++++++++------------ 1 file changed, 10 insertions(+), 12 deletions(-) diff --git a/source/text/scalc/01/04060182.xhp b/source/text/scalc/01/04060182.xhp index c02ddbbc00..b6a78433b0 100644 --- a/source/text/scalc/01/04060182.xhp +++ b/source/text/scalc/01/04060182.xhp @@ -172,7 +172,7 @@ Calculates the values of the left tail of the F distribution. - F.DIST(Number; DegreesFreedom1; DegreesFreedom2; Cumulative) + F.DIST(Number; DegreesFreedom1; DegreesFreedom2 [; Cumulative]) Number is the value for which the F distribution is to be calculated. degreesFreedom1 is the degrees of freedom in the numerator in the F distribution. degreesFreedom2 is the degrees of freedom in the denominator in the F distribution. @@ -285,7 +285,7 @@ Returns the values of a Gamma distribution. The inverse function is GAMMAINV. - GAMMADIST(Number; Alpha; Beta; C) + GAMMADIST(Number; Alpha; Beta [; C]) Number is the value for which the Gamma distribution is to be calculated. @@ -343,9 +343,8 @@

GEOMEAN

Returns the geometric mean of a sample. - GEOMEAN(Number1; Number2; ...; Number30) - - Number1, Number2, ..., Number30 are numeric arguments or ranges that represent a random sample. + GEOMEAN() + =GEOMEAN(23;46;69) = 41.79. The geometric mean value of this random sample is therefore 41.79. @@ -374,7 +373,7 @@

ZTEST

Calculates the probability of observing a z-statistic greater than the one computed based on a sample. - ZTEST(Data; mu; Sigma) + ZTEST(Data; mu [; Sigma]) Data is the given sample, drawn from a normally distributed population. @@ -391,7 +390,7 @@ Calculates the probability of observing a z-statistic greater than the one computed based on a sample. -Z.TEST(Data; mu; Sigma) +Z.TEST(Data; mu [; Sigma]) Data is the given sample, drawn from a normally distributed population. mu is the known mean of the population. Sigma (optional) is the known standard deviation of the population. If omitted, the standard deviation of the given sample is used. @@ -406,10 +405,9 @@

HARMEAN

Returns the harmonic mean of a data set. - HARMEAN(Number1; Number2; ...; Number30) - - Number1, Number2, ..., Number30 are up to 30 values or ranges, that can be used to calculate the harmonic mean. - + HARMEAN() + + =HARMEAN(23;46;69) = 37.64. The harmonic mean of this random sample is thus 37.64 @@ -422,7 +420,7 @@ Returns the hypergeometric distribution. - HYPGEOMDIST(X; NSample; Successes; NPopulation[; Cumulative]) + HYPGEOMDIST(X; NSample; Successes; NPopulation [; Cumulative]) X is the number of results achieved in the random sample. -- cgit