Difference between revisions of "Manuals/calci/BINOMDIST"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font size="3"><font face="Times New Roman">BINOMDIST (ns, t, ps, c)</font></font> <font size="3"><font face="Time...")
 
Line 1: Line 1:
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''BINOMDIST (ns, t, ps, c)'''</div><br/>
  
<font size="3"><font face="Times New Roman">BINOMDIST (ns, t, ps, c)</font></font>
+
Where ns is the number of successes in trials.
  
<font size="3"><font face="Times New Roman">Where ns is the number of successes in trials.</font></font>
+
t is the number of independent trials.
  
<font size="3"><font face="Times New Roman">t is the number of independent trials.</font></font>
+
ps is the probability of success on each trial and '''c''' is a logical value that determines the form of the function.
 +
It calculates the individual term binomial distribution probability.
 +
ns and t are integers.
 +
When ns or t or ps is nonnumeric BINOMDIST displays error.
 +
When ns is less than 0 or greater than t, BINOMDIST shows NaN.
  
<font size="3"><font face="Times New Roman">ps is the probability of success on each trial and '''c''' is a logical value that determines the form of the function. </font></font>
+
When ps is less than 0 or greater than 1, BINOMDIST calculates the wrong result.
  
</div>
+
Formula
----
+
The binomial probability mass function is:
<div id="1SpaceContent" class="zcontent" align="left">
 
  
<font size="3"><font face="Times New Roman">It calculates the individual term binomial distribution probability.</font></font>
 
  
</div>
 
----
 
<div id="7SpaceContent" class="zcontent" align="left">
 
 
<font size="3">·</font>        <font size="3"><font face="Times New Roman">ns and t are integers. </font></font>
 
 
<font size="3">·</font>        <font size="3"><font face="Times New Roman">When ns or t or ps is nonnumeric BINOMDIST displays error. </font></font>
 
 
<font size="3">·</font>        <font face="Times New Roman"><font size="3">When ns is less than 0 or greater than t, BINOMDIST shows NaN.</font></font>
 
 
<font size="3">·</font>        <font size="3"><font face="Times New Roman">When ps is less than 0 or greater than 1, BINOMDIST calculates the wrong result.</font></font>
 
 
<font size="3"><font face="Times New Roman"></font></font>
 
 
<font size="3"><font face="Times New Roman"></font></font>
 
 
<font size="3"><font face="Times New Roman">
 
 
<font size="3" face="Times New Roman">Formula</font>
 
 
<font size="3">·</font>        <font size="3"><font face="Times New Roman">The binomial probability mass function is: </font></font>
 
 
<font size="3" face="Times New Roman"></font>
 
  
 
<font size="3"><font face="Times New Roman">                                                where:        </font></font><font size="3"><font face="Times New Roman">       is COMBIN(n,x).</font></font>
 
<font size="3"><font face="Times New Roman">                                                where:        </font></font><font size="3"><font face="Times New Roman">       is COMBIN(n,x).</font></font>

Revision as of 04:16, 11 November 2013

BINOMDIST (ns, t, ps, c)


Where ns is the number of successes in trials.

t is the number of independent trials.

ps is the probability of success on each trial and c is a logical value that determines the form of the function. It calculates the individual term binomial distribution probability. ns and t are integers. When ns or t or ps is nonnumeric BINOMDIST displays error. When ns is less than 0 or greater than t, BINOMDIST shows NaN.

When ps is less than 0 or greater than 1, BINOMDIST calculates the wrong result.

Formula The binomial probability mass function is:


                                                where:               is COMBIN(n,x).

The cumulative binomial distribution is:


BINOMDIST

Syntax

Remarks

Examples

Description

Column1 Column2 Column3 Column4
Row1 4 12 0.3 FALSE
Row2 0.2311
Row3
Row4
Row5
Row6
'

i.e. = BINOMDIST (4, 12, 0.3, FALSE) is 0.2311