summaryrefslogtreecommitdiff
path: root/source/text/scalc/01/04060182.xhp
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@edx.srv.br>2014-07-20 11:09:11 -0300
committerCaolán McNamara <caolanm@redhat.com>2014-07-21 08:07:42 +0000
commit19da9bb07bd4cdedc266e614d0aecb6569a81df1 (patch)
treeebfb035840ff8ac8bd79a4321bf0e12bc09316f3 /source/text/scalc/01/04060182.xhp
parent76e8934ce147560cd18db1f62885e05d4d9e530e (diff)
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>
Diffstat (limited to 'source/text/scalc/01/04060182.xhp')
-rw-r--r--source/text/scalc/01/04060182.xhp21
1 files changed, 20 insertions, 1 deletions
diff --git a/source/text/scalc/01/04060182.xhp b/source/text/scalc/01/04060182.xhp
index c3b2767b0..26219db08 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"/>