diff options
| author | Olivier Hallot <olivier.hallot@edx.srv.br> | 2014-07-20 11:09:11 -0300 |
|---|---|---|
| committer | Caolán McNamara <caolanm@redhat.com> | 2014-07-21 08:07:42 +0000 |
| commit | 19da9bb07bd4cdedc266e614d0aecb6569a81df1 (patch) | |
| tree | ebfb035840ff8ac8bd79a4321bf0e12bc09316f3 /source/text/scalc/01/04060182.xhp | |
| parent | 76e8934ce147560cd18db1f62885e05d4d9e530e (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.xhp | 21 |
1 files changed, 20 insertions, 1 deletions
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"/> |