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(-)
New commits:
commit 19da9bb07bd4cdedc266e614d0aecb6569a81df1
Author: Olivier Hallot <olivier.hal...@edx.srv.br>
Date: Sun Jul 20 11:09:11 2014 -0300
Fix fdo#80451: New DIST functions from Excel
EXPON.DIST, HYPGEOM.DIST, POISSON.DIST and WEIBULL.DIST
Change-Id: I10ca3013e430c53a03d4795d0c47cbaaeb7b9adb
Reviewed-on: https://gerrit.libreoffice.org/10423
Reviewed-by: Caolán McNamara <caol...@redhat.com>
Tested-by: Caolán McNamara <caol...@redhat.com>
diff --git a/source/text/scalc/01/04060181.xhp
b/source/text/scalc/01/04060181.xhp
index 4768af7..04994d1 100644
--- a/source/text/scalc/01/04060181.xhp
+++ b/source/text/scalc/01/04060181.xhp
@@ -507,6 +507,22 @@
<paragraph xml-lang="en-US" id="par_id3150357" role="paragraph"
l10n="U" oldref="123">
<item type="input">=EXPONDIST(3;0.5;1)</item> returns
0.78.</paragraph>
</section>
+<section id="expondotdist">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2950603">
+ <bookmark_value>EXPON.DIST function</bookmark_value>
+ <bookmark_value>exponential distributions</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_EXP_DIST_MS"
id="bm_id2952962" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2950603" role="heading" level="2"
l10n="U" oldref="115">EXPON.DIST</paragraph>
+<paragraph xml-lang="en-US" id="par_id2949563" role="paragraph" l10n="U"
oldref="116"><ahelp hid="HID_FUNC_EXP_DIST_MS">Returns the exponential
distribution.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id2953789" role="heading" level="3"
l10n="U" oldref="117">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id2950987" role="code" l10n="U"
oldref="118">EXPON.DIST(Number; Lambda; C)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2954663" role="paragraph" l10n="U"
oldref="119"><emph>Number</emph> is the value of the function.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2954569" role="paragraph" l10n="U"
oldref="120"><emph>Lambda</emph> is the parameter
value.</paragraph><comment>UFI removed a double bookmark</comment>
+<paragraph xml-lang="en-US" id="par_id2947332" role="paragraph" l10n="U"
oldref="121"><emph>C</emph> is a logical value that determines the form of the
function. <emph>C = 0</emph> calculates the density function, and <emph>C =
1</emph> calculates the distribution.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2946133" role="heading" level="3"
l10n="U" oldref="122">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id2950357" role="paragraph" l10n="U"
oldref="123"><item type="input">=EXPON.DIST(3;0.5;1)</item> returns
0.7768698399.</paragraph>
+</section>
</sort>
<section id="relatedtopics">
<embed href="text/scalc/01/04060100.xhp#drking"/>
diff --git a/source/text/scalc/01/04060182.xhp
b/source/text/scalc/01/04060182.xhp
index c3b2767..26219db 100644
--- a/source/text/scalc/01/04060182.xhp
+++ b/source/text/scalc/01/04060182.xhp
@@ -155,7 +155,6 @@
<paragraph xml-lang="en-US" id="par_id3153331" role="paragraph"
l10n="U" oldref="55">
<item type="input">=GAMMAINV(0.8;1;1)</item> yields
1.61.</paragraph>
</section>
-
<section id="gammadotinv">
<bookmark xml-lang="en-US" branch="index"
id="bm_id2914841"><bookmark_value>GAMMA.INV function</bookmark_value>
</bookmark>
@@ -389,6 +388,26 @@
<paragraph xml-lang="en-US" id="par_id3154904" role="paragraph"
l10n="U" oldref="131">
<item type="input">=HYPGEOMDIST(2;2;90;100)</item> 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.</paragraph>
</section>
+<section id="hypgeomdotdist">
+ <bookmark xml-lang="en-US" branch="index" id="bm_id2952801">
+ <bookmark_value>HYPGEOM.DIST function</bookmark_value>
+ <bookmark_value>sampling without replacement</bookmark_value>
+ </bookmark>
+ <comment>mw added one entry</comment>
+ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_HYP_GEOM_DIST_MS"
id="bm_id2953910" localize="false"/>
+ <paragraph xml-lang="en-US" id="hd_id2952801" role="heading" level="2"
l10n="U" oldref="122">HYPGEOM.DIST</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2959341" role="paragraph" l10n="U"
oldref="123"><ahelp hid="HID_FUNC_HYP_GEOM_DIST_MS">Returns the hypergeometric
distribution.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2954697" role="heading" level="3"
l10n="U" oldref="124">Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2955388" role="code" l10n="U"
oldref="125">HYPGEOM.DIST(X; NSample; Successes; NPopulation;
Cumulative)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2954933" role="paragraph" l10n="U"
oldref="126"><emph>X</emph> is the number of results achieved in the random
sample.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2953106" role="paragraph" l10n="U"
oldref="127"><emph>NSample</emph> is the size of the random sample.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2946992" role="paragraph" l10n="U"
oldref="128"><emph>Successes</emph> is the number of possible results in the
total population.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2948826" role="paragraph" l10n="U"
oldref="129"><emph>NPopulation </emph>is the size of the total
population.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2948827" role="paragraph" l10n="U"
oldref="129"><emph>Cumulative </emph>: 0 or False calculates the probability
density function. Other values or True calculates the cumulative distribution
function.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2950529" role="heading" level="3"
l10n="U" oldref="130">Examples</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2954904" role="paragraph" l10n="U"
oldref="131"><item type="input">=HYPGEOM.DIST(2;2;90;100;0)</item> 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.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2954905" role="paragraph" l10n="U"
oldref="131"><item type="input">=HYPGEOM.DIST(2;2;90;100;1)</item> yields
1.</paragraph>
+</section>
</sort>
<section id="relatedtopics">
<embed href="text/scalc/01/04060100.xhp#drking"/>
diff --git a/source/text/scalc/01/04060184.xhp
b/source/text/scalc/01/04060184.xhp
index 1cd71a2..6dcdeac 100644
--- a/source/text/scalc/01/04060184.xhp
+++ b/source/text/scalc/01/04060184.xhp
@@ -384,6 +384,21 @@ oldref="109">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3150113" role="paragraph" l10n="U"
oldref="110">
<item type="input">=POISSON(60;50;1)</item> returns 0.93.</paragraph>
</section>
+<section id="poissondotdist">
+ <bookmark xml-lang="en-US" branch="index" id="bm_id2953985">
+ <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"
oldref="102">POISSON.DIST</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2954298" role="paragraph" l10n="U"
oldref="103"><ahelp hid="HID_FUNC_POISSON_DIST_MS">Returns the Poisson
distribution.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2959183" role="heading" level="3"
l10n="U" oldref="104">Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2946093" role="code" l10n="U"
oldref="105">POISSON.DIST(Number; Mean; C)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2947253" role="paragraph" l10n="U"
oldref="106"><emph>Number</emph> represents the value based on which the
Poisson distribution is calculated.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2951177" role="paragraph" l10n="U"
oldref="107"><emph>Mean</emph> represents the middle value of the Poisson
distribution.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2949200" role="paragraph" l10n="CHG"
oldref="108"><emph>C</emph> (optional) = 0 or False calculates the density
function; <emph>C</emph> = 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.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2959347" role="heading" level="3"
l10n="U" oldref="109">Example</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2950113" role="paragraph" l10n="U"
oldref="110"><item type="input">=POISSON.DIST(60;50;1)</item> returns
0.9278398202.</paragraph>
+</section>
<section id="percentile">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3153100"><bookmark_value>PERCENTILE function</bookmark_value>
</bookmark>
diff --git a/source/text/scalc/01/04060185.xhp
b/source/text/scalc/01/04060185.xhp
index d0ea9cd..7baa691 100644
--- a/source/text/scalc/01/04060185.xhp
+++ b/source/text/scalc/01/04060185.xhp
@@ -546,6 +546,26 @@
<item type="input">=WEIBULL(2;1;1;1)</item> returns
0.86.</paragraph>
<paragraph xml-lang="en-US" id="par_id0305200911372899"
role="paragraph" l10n="NEW">See also the <link
href="http://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_WEIBULL_function";>Wiki
page</link>.</paragraph>
</section>
+<section id="weibulldotdist">
+ <bookmark xml-lang="en-US" branch="index" id="bm_id2950941">
+ <bookmark_value>WEIBULL.DIST function</bookmark_value>
+ </bookmark>
+ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WEIBULL_DIST_MS"
id="bm_id3150405" localize="false"/>
+ <paragraph xml-lang="en-US" id="hd_id2950941" role="heading" level="2"
l10n="U" oldref="175">WEIBULL.DIST</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2954916" role="paragraph" l10n="U"
oldref="176"><ahelp hid="HID_FUNC_WEIBULL_DIST_MS">Returns the values of the
Weibull distribution.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="par_id2905200911372767" role="paragraph"
l10n="NEW">The Weibull distribution is a continuous probability distribution,
with parameters Alpha > 0 (shape) and Beta > 0 (scale). </paragraph>
+ <paragraph xml-lang="en-US" id="par_id2905200911372777" role="paragraph"
l10n="NEW">If C is 0, WEIBULL.DIST calculates the probability density
function.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2905200911372743" role="paragraph"
l10n="NEW">If C is 1, WEIBULL.DIST calculates the cumulative distribution
function.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2959393" role="heading" level="3"
l10n="U" oldref="177">Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2954478" role="code" l10n="U"
oldref="178">WEIBULL.DIST(Number; Alpha; Beta; C)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2951317" role="paragraph" l10n="U"
oldref="179"><emph>Number</emph> is the value at which to calculate the Weibull
distribution.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2958436" role="paragraph" l10n="U"
oldref="180"><emph>Alpha </emph>is the shape parameter of the Weibull
distribution.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2954668" role="paragraph" l10n="U"
oldref="181"><emph>Beta</emph> is the scale parameter of the Weibull
distribution.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2954825" role="paragraph" l10n="CHG"
oldref="182"><emph>C</emph> indicates the type of function.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2953794" role="heading" level="3"
l10n="U" oldref="183">Example</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2946077" role="paragraph" l10n="U"
oldref="184"><item type="input">=WEIBULL.DIST(2;1;1;1)</item> returns
0.8646647168.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2905200911372899" role="paragraph"
l10n="NEW">See also the <link
href="http://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_WEIBULL_function";>Wiki
page</link>.</paragraph>
+</section>
</sort>
<section id="relatedtopics">
<embed href="text/scalc/01/04060100.xhp#drking"/>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
