From 0e6d0e8907c46f3d3dcaf3f06add2496beaf16a8 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Sat, 19 Jul 2014 12:11:45 -0300 Subject: Fix fdo#80447: Help pages for MS BINOM functions MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Covers BIMOM.DIST and BINOM.INV Change-Id: If1f3ef61dfa5e23c6b88818439be2932eb98aabe Reviewed-on: https://gerrit.libreoffice.org/10409 Reviewed-by: Caolán McNamara Tested-by: Caolán McNamara --- source/text/scalc/01/04060181.xhp | 30 ++++++++++++++++++++++++++++++ 1 file changed, 30 insertions(+) diff --git a/source/text/scalc/01/04060181.xhp b/source/text/scalc/01/04060181.xhp index 24d7963365..4768af7dfe 100644 --- a/source/text/scalc/01/04060181.xhp +++ b/source/text/scalc/01/04060181.xhp @@ -258,6 +258,36 @@ =BINOMDIST(A1;12;0.5;1) shows the cumulative probabilities for the same series. For example, if A1 = 4, the cumulative probability of the series is 0, 1, 2, 3 or 4 times Heads (non-exclusive OR). +
+BINOM.DIST function + +BINOM.DIST +Returns the individual term binomial distribution probability. +Syntax +BINOM.DIST(X; Trials; SP; C) +X is the number of successes in a set of trials. +Trials is the number of independent trials. +SP is the probability of success on each trial. +C = 0 calculates the probability of a single event and C = 1 calculates the cumulative probability. +Example + + =BINOM.DIST(A1;12;0.5;0) shows (if the values 0 to 12 are entered in A1) the probabilities for 12 flips of a coin that Heads will come up exactly the number of times entered in A1. + + =BINOM.DIST(A1;12;0.5;1) shows the cumulative probabilities for the same series. For example, if A1 = 4, the cumulative probability of the series is 0, 1, 2, 3 or 4 times Heads (non-exclusive OR). +
+
+BINOM.INV function + +BINOM.INV +Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. +Syntax +BINOM.INV(Trials; SP; Alpha) +Trials The total number of trials. +SP is the probability of success on each trial. +AlphaThe border probability that is attained or exceeded. +Example +=BINOM.INV(8;0.6;0.9) returns 7, the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. +
CHISQINV function -- cgit v1.2.3