From 19da9bb07bd4cdedc266e614d0aecb6569a81df1 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Sun, 20 Jul 2014 11:09:11 -0300 Subject: Fix fdo#80451: New DIST functions from Excel MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit EXPON.DIST, HYPGEOM.DIST, POISSON.DIST and WEIBULL.DIST Change-Id: I10ca3013e430c53a03d4795d0c47cbaaeb7b9adb Reviewed-on: https://gerrit.libreoffice.org/10423 Reviewed-by: Caolán McNamara Tested-by: Caolán McNamara --- source/text/scalc/01/04060181.xhp | 16 ++++++++++++++++ source/text/scalc/01/04060182.xhp | 21 ++++++++++++++++++++- source/text/scalc/01/04060184.xhp | 15 +++++++++++++++ source/text/scalc/01/04060185.xhp | 20 ++++++++++++++++++++ 4 files changed, 71 insertions(+), 1 deletion(-) diff --git a/source/text/scalc/01/04060181.xhp b/source/text/scalc/01/04060181.xhp index 4768af7dfe..04994d133a 100644 --- a/source/text/scalc/01/04060181.xhp +++ b/source/text/scalc/01/04060181.xhp @@ -507,6 +507,22 @@ =EXPONDIST(3;0.5;1) returns 0.78. +
+ + EXPON.DIST function + exponential distributions + + +EXPON.DIST +Returns the exponential distribution. +Syntax +EXPON.DIST(Number; Lambda; C) +Number is the value of the function. +Lambda is the parameter value.UFI removed a double bookmark +C is a logical value that determines the form of the function. C = 0 calculates the density function, and C = 1 calculates the distribution. +Example +=EXPON.DIST(3;0.5;1) returns 0.7768698399. +
diff --git a/source/text/scalc/01/04060182.xhp b/source/text/scalc/01/04060182.xhp index c3b2767b07..26219db087 100644 --- a/source/text/scalc/01/04060182.xhp +++ b/source/text/scalc/01/04060182.xhp @@ -155,7 +155,6 @@ =GAMMAINV(0.8;1;1) yields 1.61.
-
GAMMA.INV function @@ -389,6 +388,26 @@ =HYPGEOMDIST(2;2;90;100) yields 0.81. If 90 out of 100 pieces of buttered toast fall from the table and hit the floor with the buttered side first, then if 2 pieces of buttered toast are dropped from the table, the probability is 81%, that both will strike buttered side first.
+
+ + HYPGEOM.DIST function + sampling without replacement + + mw added one entry + + HYPGEOM.DIST + Returns the hypergeometric distribution. + Syntax + HYPGEOM.DIST(X; NSample; Successes; NPopulation; Cumulative) + X is the number of results achieved in the random sample. + NSample is the size of the random sample. + Successes is the number of possible results in the total population. + NPopulation is the size of the total population. + Cumulative : 0 or False calculates the probability density function. Other values or True calculates the cumulative distribution function. + Examples + =HYPGEOM.DIST(2;2;90;100;0) yields 0.8090909091. If 90 out of 100 pieces of buttered toast fall from the table and hit the floor with the buttered side first, then if 2 pieces of buttered toast are dropped from the table, the probability is 81%, that both will strike buttered side first. + =HYPGEOM.DIST(2;2;90;100;1) yields 1. +
diff --git a/source/text/scalc/01/04060184.xhp b/source/text/scalc/01/04060184.xhp index 1cd71a220c..6dcdeac556 100644 --- a/source/text/scalc/01/04060184.xhp +++ b/source/text/scalc/01/04060184.xhp @@ -384,6 +384,21 @@ oldref="109">Example =POISSON(60;50;1) returns 0.93.
+
+ + POISSON.DIST function + + + POISSON.DIST + Returns the Poisson distribution. + Syntax + POISSON.DIST(Number; Mean; C) + Number represents the value based on which the Poisson distribution is calculated. + Mean represents the middle value of the Poisson distribution. + C (optional) = 0 or False calculates the density function; C = 1 or True calculates the distribution. When omitted, the default value True is inserted when you save the document, for best compatibility with other programs and older versions of %PRODUCTNAME. + Example + =POISSON.DIST(60;50;1) returns 0.9278398202. +
PERCENTILE function diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp index d0ea9cd787..7baa691a8d 100644 --- a/source/text/scalc/01/04060185.xhp +++ b/source/text/scalc/01/04060185.xhp @@ -546,6 +546,26 @@ =WEIBULL(2;1;1;1) returns 0.86. See also the Wiki page.
+
+ + WEIBULL.DIST function + + + WEIBULL.DIST + Returns the values of the Weibull distribution. + The Weibull distribution is a continuous probability distribution, with parameters Alpha > 0 (shape) and Beta > 0 (scale). + If C is 0, WEIBULL.DIST calculates the probability density function. + If C is 1, WEIBULL.DIST calculates the cumulative distribution function. + Syntax + WEIBULL.DIST(Number; Alpha; Beta; C) + Number is the value at which to calculate the Weibull distribution. + Alpha is the shape parameter of the Weibull distribution. + Beta is the scale parameter of the Weibull distribution. + C indicates the type of function. + Example + =WEIBULL.DIST(2;1;1;1) returns 0.8646647168. + See also the Wiki page. +
-- cgit