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 <caolanm@redhat.com>
Tested-by: Caolán McNamara <caolanm@redhat.com>

4 files changed, 71 insertions, 1 deletions

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 @@
          <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 c3b2767b07..26219db087 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 1cd71a220c..6dcdeac556 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 d0ea9cd787..7baa691a8d 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 &gt; 0 (shape) and Beta &gt; 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"/>