Difference between revisions of "Manuals/calci/CRITBINOM"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left">   '''CRITBINOM (t, prob, alpha)''' '''Where ‘t’ is the number of Bernoulli trials, ‘Prob’ is the probabi...")
 
 
(20 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">  
+
<div style="font-size:30px">'''CRITBINOM(trials,probabilitys,alpha,accuracy)'''</div><br/>
 +
*<math>trials</math> is the number of independent trials.
 +
*<math>probabilitys</math> is the  probability of success in one trial.
 +
*<math>alpha</math> is the criterion value.
 +
*<math>accuracy</math> gives accurate value of the solution.
 +
**CRITBINOM(), returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.
  
−
'''CRITBINOM (t, prob, alpha)'''
+
==Description==
 +
*The smallest value in Cumulative Binomial Distribution probability result is the Critbinom.
 +
*This function is the inverse of the Cumulative Binomial Distribution.
 +
*For example, the Critbinom function could be used to find the smallest number of through the dice for which there is a 40% chance of at least 10 six's.
 +
*In CRITBINOM(trials,probabilitys,alpha,accuracy), <math>trials</math> is the number of independent trials that are to be done (if <math>trials</math> value is in decimal then it is converted to an integer).
 +
*<math>probabilitys</math> is the  probability of success in one trial and <math>alpha</math> is the criterion value of the Cumulative Binomial Distribution (must be between 0 and 1).
 +
*<math>accuracy</math> gives accurate value of the solution.
 +
*This function gives the result as error when
 +
1.Any one of the argument is non-numeric.
 +
2.<math>trials<0</math>,or <math>probabilitys<0</math> or <math>probabilitys>1</math>
 +
3.<math>alpha<0</math> or <math>alpha>1</math>.
  
−
'''Where ‘t’ is the number of Bernoulli trials, ‘Prob’ is the probability of a success on each trial and ‘alpha’ is the criterion value.'''
+
==ZOS==
 +
*The syntax is to calculate CRITBINOM in ZOS is <math>CRITBINOM(trials,probabilitys,alpha,accuracy)</math>.
 +
**<math>trials</math> is the number of independent trials.
 +
**<math>probabilitys</math> is the probability of success in one trial.
 +
**<math>alpha</math> is the criterion value.
 +
**<math>accuracy</math> gives accurate value of the solution.
 +
*For e.g.,CRITBINOM(5..8,0.5,0.4,0.02)
 +
{{#ev:youtube|VqXa3JGsSvY|280|center|CRITBINOM }}
  
−
</div>
+
==Examples==
−
----
 
−
<div id="1SpaceContent" class="zcontent" align="left">
 
  
−
This function is to determine the quality assurance applications. It returns, the cumulative binomial distribution is greater than or equal to a criterion value.
+
#CRITBINOM(5,0.6,0.4) = 3
 +
#CRITBINOM(8,0.1,0.25) = 1
 +
#CRITBINOM(20,0.75,0.65) = 16
 +
#CRITBINOM(20,1,1.5) = #N/A (ALPHA IN BETWEEN 0 AND 1 REQUIRED)
 +
#CRITBINOM(9.5,0.4,0.35) = 3
 +
#CRITBINOM(12,-0.25,0.3) = #N/A (PROBABILITY IN BETWEEN 0 AND 1 REQUIRED)
  
−
</div>
+
==Related Videos==
−
----
 
−
<div id="7SpaceContent" class="zcontent" align="left"> 
 
  
−
* This function accepts all numeric values.
+
{{#ev:youtube|L6YX3ug1znM|280|center|Cumulative Probability}}
−
* Trials should be grater than 0.
 
−
* Prob and alpha should be between 0 and 1
 
  
−
</div>
+
==See Also==
−
----
+
*[[Manuals/calci/BINOMDIST  | BINOMDIST ]]
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
+
*[[Manuals/calci/NEGBINOMDIST  | NEGBINOMDIST ]]
 +
*[[Manuals/calci/COMBIN  | COMBIN ]]
 +
*[[Manuals/calci/FACT  | FACT ]]
 +
==References==
 +
[http://en.wikipedia.org/wiki/Binomial_distribution  Binomial Distribution]
  
−
CRITBINOM
 
  
−
</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="5SpaceContent" class="zcontent" align="left">
 
  
−
Lets see an example,
 
  
−
CRITBINOM(t,prob,alpha)
+
*[[Z_API_Functions | List of Main Z Functions]]
  
−
'''B'''
+
*[[ Z3 |  Z3 home ]]
−
 
 
−
8
 
−
 
 
−
0.65
 
−
 
 
−
0.80
 
−
 
 
−
<nowiki>=CRITBINOM(B2,B3,B4)</nowiki>
 
−
 
 
−
</div>
 
−
----
 
−
<div id="2SpaceContent" class="zcontent" align="left">
 
−
 
 
−
{| id="TABLE3" class="SpreadSheet blue"
 
−
|- class="even"
 
−
| class=" " |
 
−
| class="  " | Column1
 
−
| class="  " | Column2
 
−
| class="  " | Column3
 
−
| class="                                                          " |
 
−
|- class="odd"
 
−
| class=" " | Row1
 
−
| class=" " | 8
 
−
| class="      " |
 
−
<div id="2EditDiv" class="tab active">=CRITBINOM(B2,B3,B4)C3</div><div id="2Space_Handle" class="zhandles"></div><div id="2Space_Copy" class="zhandles"></div>
 
−
| class="sshl_f" |
 
−
|
 
−
|- class="even"
 
−
| class="  " | Row2
 
−
| class=" " | 0.65
 
−
| class="SelectTD" |
 
−
|
 
−
|
 
−
|- class="odd"
 
−
| Row3
 
−
| class="sshl_f " | 0.80
 
−
| class="sshl_f  " |
 
−
|
 
−
|
 
−
|- class="even"
 
−
| Row4
 
−
| class="        " |
 
−
| class="sshl_f   " |
 
−
| class=" " |
 
−
|
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
| class="sshl_f" |
 
−
| class="sshl_f  " |
 
−
| class=" " |
 
−
|
 
−
|- class="even"
 
−
| class="sshl_f" | Row6
 
−
| class="sshl_f" |
 
−
| class="sshl_f  " |
 
−
| class=" " |
 
−
|
 
−
|}
 
−
 
 
−
<div align="left">[[Image:calci1.gif]]</div></div>
 
−
----
 

Latest revision as of 04:32, 25 August 2020

CRITBINOM(trials,probabilitys,alpha,accuracy)


  • is the number of independent trials.
  • is the probability of success in one trial.
  • is the criterion value.
  • gives accurate value of the solution.
    • CRITBINOM(), returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.

Description

  • The smallest value in Cumulative Binomial Distribution probability result is the Critbinom.
  • This function is the inverse of the Cumulative Binomial Distribution.
  • For example, the Critbinom function could be used to find the smallest number of through the dice for which there is a 40% chance of at least 10 six's.
  • In CRITBINOM(trials,probabilitys,alpha,accuracy), is the number of independent trials that are to be done (if value is in decimal then it is converted to an integer).
  • is the probability of success in one trial and is the criterion value of the Cumulative Binomial Distribution (must be between 0 and 1).
  • gives accurate value of the solution.
  • This function gives the result as error when
1.Any one of the argument is non-numeric.
2.,or  or 
3. or .

ZOS

  • The syntax is to calculate CRITBINOM in ZOS is .
    • is the number of independent trials.
    • is the probability of success in one trial.
    • is the criterion value.
    • gives accurate value of the solution.
  • For e.g.,CRITBINOM(5..8,0.5,0.4,0.02)
CRITBINOM

Examples

  1. CRITBINOM(5,0.6,0.4) = 3
  2. CRITBINOM(8,0.1,0.25) = 1
  3. CRITBINOM(20,0.75,0.65) = 16
  4. CRITBINOM(20,1,1.5) = #N/A (ALPHA IN BETWEEN 0 AND 1 REQUIRED)
  5. CRITBINOM(9.5,0.4,0.35) = 3
  6. CRITBINOM(12,-0.25,0.3) = #N/A (PROBABILITY IN BETWEEN 0 AND 1 REQUIRED)

Related Videos

Cumulative Probability

See Also

References

Binomial Distribution



Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/CRITBINOM&oldid=215055"