Difference between revisions of "Manuals/calci/CRITBINOM"
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...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''CRITBINOM(ts,ps,alpha)'''</div><br/> |
| + | *<math>ts is the number of independent trials</math>. | ||
| + | *<math>ps is the probability of success in one trial</math>. | ||
| + | *<math>alpha is the criterion value</math>. | ||
| + | ==Description== | ||
| + | This function gives the smallest value for which the cumulative binomial distribution is a specified probability. | ||
| + | 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(ts,ps,alpha) ,ts is the number of independent trials that are to be done(the ts value is in decimal then it is converted in to integer) ,ps is the probability of success in one trial and alpha The criterion value of the Cumulative Binomial Distribution (must be between 0 and 1). | ||
| + | This function gives the result as error when | ||
| + | #Any one of the argument is nonnumeric. | ||
| + | #ts<0,or ps<0 or ps>1 | ||
| + | #alpha<0 or alpha>1 | ||
| + | ==Examples== | ||
| − | + | #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)=NAN | ||
| + | #CRITBINOM(9.5,0.4,0.35)=3 | ||
| + | #CRITBINOM(12,-0.25,0.3)=NAN | ||
| − | + | ==See Also== | |
| − | + | *[[Manuals/calci/BINOMDIST | BINOMDIST ]] | |
| − | + | *[[Manuals/calci/NEGBINOMDIST | NEGBINOMDIST ]] | |
| − | + | *[[Manuals/calci/COMBIN | COMBIN ]] | |
| − | + | *[[Manuals/calci/FACT | FACT ]] | |
| − | + | ==References== | |
| − | + | [http://en.wikipedia.org/wiki/Pearson_product-moment_correlation_coefficient| Correlation] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | * | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 00:37, 10 December 2013
CRITBINOM(ts,ps,alpha)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ts is the number of independent trials} .
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ps is the probability of success in one trial} .
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle alpha is the criterion value} .
Description
This function gives the smallest value for which the cumulative binomial distribution is a specified probability. 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(ts,ps,alpha) ,ts is the number of independent trials that are to be done(the ts value is in decimal then it is converted in to integer) ,ps is the probability of success in one trial and alpha The criterion value of the Cumulative Binomial Distribution (must be between 0 and 1). This function gives the result as error when
- Any one of the argument is nonnumeric.
- ts<0,or ps<0 or ps>1
- alpha<0 or alpha>1
Examples
- 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)=NAN
- CRITBINOM(9.5,0.4,0.35)=3
- CRITBINOM(12,-0.25,0.3)=NAN