diff options
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"/> |