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...")
 
 
(64 intermediate revisions by 4 users not shown)
Line 1: Line 1:
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''BINOMDIST (numbers, trials, probability, cumulative)'''</div><br/>
  
<font size="3"><font face="Times New Roman">BINOMDIST (ns, t, ps, c)</font></font>
+
*<math>numbers</math> is the number of successes in trials.
 +
*<math>trials</math> is the number of independent trials.
 +
*<math>probability</math> is the probability of success on each trial.
 +
*<math>cumulative</math> is a logical value that determines the form of the function.
 +
**BINOMDIST(), returns the individual term binomial distribution probability.
  
<font size="3"><font face="Times New Roman">Where ns is the number of successes in trials.</font></font>
+
==Description==
  
<font size="3"><font face="Times New Roman">t is the number of independent trials.</font></font>
+
*This function gives the individual element Binomial Distribution Probability.
 +
*We can use this function when the following conditions are satisfied:
 +
#A number of tests <math>n</math> should be fixed.
 +
#Each test must be independent.
 +
#Each test represents only two results(Success/Failure)
 +
#No test has  any impact on any other test.
 +
For example, the number of ways to achieve 2 heads in a set of four tosses is "4 choose 2".
 +
*In BINOMDIST function, <math>numbers</math> is the number of successes  in trials.
 +
*<math>trials</math> is the number trials to be made, also <math>numbers</math> and <math>trials</math> should be integers.
 +
*<math>probability</math> is the number of probability of success on each independent trials.  
 +
*<math>cumulative</math> is the logical value like TRUE or FALSE. If it is TRUE  it will give the cumulative value or FALSE it will give the exact probability.
 +
This function gives result as "Error" when
 +
#<math>numbers</math> and <math>trials</math> are not an Integer.
 +
#<math>numbers,trials,probability</math> are not a numeric.
 +
#<math>numbers < 0</math> or <math>numbers > trials</math>
 +
#Also <math>probability < 0</math> or <math>probability >1</math>
 +
For Example: =BINOMDIST (4, 12, 0.3, FALSE) is 0.2311
  
<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>
+
*The binomial distribution with parameters n and p, we write <math> X \tilde{} B(n, p)</math>.
 +
*The probability of getting exactly <math> k </math> successes in <math> n </math> trials is given by the Probability Mass Function:
 +
<math> b(k;n,p)=Pr(X = k) = \binom{n}{k}p^{k}(1-p)^{n-k}</math> for k=0,1,2,3...n where  <math>\binom{n}{k}</math> is the COMBIN(n,k) i.e.<math> \binom{n}{k} = \frac{n!}{k!(n-k)}!</math>
  
</div>
+
*The Cumulative Binomial Distribution is:<math>B(x;n,p) = Pr(X \le x) =\sum_{i=0}^x  \binom{n}{i}p^{i}(1-p)^{(n-i)}</math>
----
 
<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>
+
==ZOS==
  
</div>
+
*The syntax is to calculate <math>BINOMDIST(numbers,trials,probability,cumulative)</math>
----
+
*<math>numbers</math> is the number of successes in trials.
<div id="7SpaceContent" class="zcontent" align="left">
+
*<math>trials</math> is the number of independent trials.
 +
*<math>probability</math> is the probability of success on each trial.
 +
*<math>cumulative</math> is indicating the form of the function.
 +
*For e.g.BINOMDIST(9,12,0.2,false)
 +
{{#ev:youtube|v=3PWKQiLK41M|280|center|Binomial Distribution}}
  
<font size="3">·</font>        <font size="3"><font face="Times New Roman">ns and t are integers. </font></font>
+
==Example==
  
<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>
+
#Toss a coin for 12 times. What is the probability of getting exactly 7 heads.
 +
#*Here ns=7,ts=12,and ps=1/2=0.5
  
<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>
+
#The LMB Company manufactures tires.  They claim that only .007 of LMB tires are defective.  What is the probability of finding 2 defective tires in a random sample of 50 LMB tires?
 +
#*Here ns=2,ts=50 and ps=0.007
  
<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>
+
{| id="TABLE3" class="SpreadSheet blue"
 +
|- class="even"
 +
| Questions
 +
! ns
 +
! ts
 +
! ps
 +
! cu
 +
! Result
 +
|-
 +
|- class="odd"
 +
|Question 1
 +
|7
 +
|12
 +
|0.5(1/2)
 +
|FALSE
 +
|0.193359375
 +
|- class="even"
 +
|Question2
 +
|2
 +
|15
 +
|0.007
 +
|FALSE
 +
|0.00469597319803066
 +
|- class="odd"
 +
|Question3
 +
|2
 +
|10
 +
|0.2
 +
|TRUE
 +
|0.6777995264000007
 +
|- class="even"
  
<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>
+
==Related Videos==
  
<font size="3">·</font>        <font size="3"><font face="Times New Roman">The binomial probability mass function is: </font></font>
+
{{#ev:youtube|WWv0RUxDfbs|280|center|Binomial Distribution}}
  
<font size="3" face="Times New Roman"></font>
+
==See Also==
  
<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>
+
*[[Manuals/calci/COMBIN | COMBIN]]
 +
*[[Manuals/calci/FACT | FACT]]
  
<font size="3"><font face="Times New Roman">The cumulative binomial distribution is: </font></font>
+
==References==
 +
[http://en.wikipedia.org/wiki/Binomial_distribution  Binomial Distribution]
  
</font></font></div>
 
----
 
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">BINOMDIST</div></div>
 
----
 
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
----
 
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
 
----
 
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
----
 
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
----
 
<div id="2SpaceContent" class="zcontent" align="left"><div>
 
  
{| id="TABLE1" class="SpreadSheet blue"
+
*[[Z_API_Functions | List of Main Z Functions]]
|- class="even"
 
| class=" " |
 
| Column1
 
| class="            " | Column2
 
| class="    " | Column3
 
| class="sshl_f" | Column4
 
|- class="odd"
 
| class=" " | Row1
 
| class=" " | 4
 
| class=" " | 12
 
| class=" " | 0.3
 
| class="sshl_f " | FALSE
 
|- class="even"
 
| class="  " | Row2
 
| class="sshl_f" | 0.2311
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|- class="odd"
 
| Row3
 
| class="sshl_fSelectTD SelectTD " |
 
<div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="  " |
 
|- class="even"
 
| Row4
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|
 
| class=" " |
 
|- class="odd"
 
| class="sshl_f" | Row5
 
| class="sshl_f" |
 
| class="  " |
 
|
 
|
 
|- class="even"
 
| class=" " | Row6
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|
 
| class="sshl_f" |
 
|}
 
  
<div align="left"></div>''''''</div></div>
+
*[[ Z3 |  Z3 home ]]
----
 
<div id="5SpaceContent" class="zcontent" align="left">i.e. = BINOMDIST (4, 12, 0.3, FALSE) is 0.2311</div>
 
----
 
<div id="8SpaceContent" class="zcontent" align="left"></div>
 
----
 

Latest revision as of 02:30, 25 August 2020

BINOMDIST (numbers, trials, probability, cumulative)


  • is the number of successes in trials.
  •  is the number of independent trials.
  •  is the probability of success on each trial.
  • is a logical value that determines the form of the function.
    • BINOMDIST(), returns the individual term binomial distribution probability.

Description

  • This function gives the individual element Binomial Distribution Probability.
  • We can use this function when the following conditions are satisfied:
  1. A number of tests should be fixed.
  2. Each test must be independent.
  3. Each test represents only two results(Success/Failure)
  4. No test has any impact on any other test.
For example, the number of ways to achieve 2 heads in a set of four tosses is "4 choose 2".
  • In BINOMDIST function, is the number of successes in trials.
  • is the number trials to be made, also and should be integers.
  • is the number of probability of success on each independent trials.
  • is the logical value like TRUE or FALSE. If it is TRUE it will give the cumulative value or FALSE it will give the exact probability.

This function gives result as "Error" when

  1. and are not an Integer.
  2. are not a numeric.
  3. or
  4. Also or
For Example: =BINOMDIST (4, 12, 0.3, FALSE) is 0.2311
  • The binomial distribution with parameters n and p, we write .
  • The probability of getting exactly successes in trials is given by the Probability Mass Function:

for k=0,1,2,3...n where is the COMBIN(n,k) i.e.

  • The Cumulative Binomial Distribution is:

ZOS

  • The syntax is to calculate
  • is the number of successes in trials.
  • is the number of independent trials.
  • is the probability of success on each trial.
  • is indicating the form of the function.
  • For e.g.BINOMDIST(9,12,0.2,false)
Binomial Distribution

Example

  1. Toss a coin for 12 times. What is the probability of getting exactly 7 heads.
    • Here ns=7,ts=12,and ps=1/2=0.5
  1. The LMB Company manufactures tires. They claim that only .007 of LMB tires are defective. What is the probability of finding 2 defective tires in a random sample of 50 LMB tires?
    • Here ns=2,ts=50 and ps=0.007
Questions ns ts ps cu Result
Question 1 7 12 0.5(1/2) FALSE 0.193359375
Question2 2 15 0.007 FALSE 0.00469597319803066
Question3 2 10 0.2 TRUE 0.6777995264000007

Related Videos

Binomial Distribution

See Also

References

Binomial Distribution