BinomDist ( successes ; trials ; probability ; cumulative )
Rate this function: Average rating: 3.6 (53 votes) Discuss this Custom Function
Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net
Returns the binomial probability distribution of obtaining the number of successes out of a fixed number of trials, where the result of each trial can be only success or failure, and the probability of success is constant throughout the experiment. BinomDist can calculate the probability that two out of the next three babies born will be male.
Sample Input:
BinomDist ( 10 ; 20 ; 0.5 ; 0 )
BinomDist ( 10 ; 20 ; 0.5 ; 1 ) 

Sample Output:
0.1761970520019531
0.5880985260009766 

Description:
Returns the binomial probability distribution of obtaining the number of successes out of a fixed number of trials, where the result of each trial can be only success or failure, and the probability of success is constant throughout the experiment. BinomDist can calculate the probability that two out of the next three babies born will be male.
Depending on the cumulative parameter, the BinomDist function returns either the individual probability of obtaining exactly the number of successes, or the cumulative probability of obtaining at most the number of successes.
The BinomDist function parameters are:
successes  the number of successes in trials;
trials  the number of independent trials;
probability  probability of success in each trial;
cumulative  a logical value that determines the form of the function: if cumulative is TRUE, BinomDist returns the cumulative distribution function, which is the probability of obtaining at most the number of successes; if FALSE, it returns the probability mass function, which is the probability of obtaining exactly the number of successes.
Example:
The flip of a coin can only result in 'heads' or 'tails'. The probability of any individual flip being 'heads' is 0.5.
The probability of getting exactly 10 'heads' results out of 20 flips is:
BinomDist ( 10 ; 20 ; 0.5 ; 0 ) = 17.62%
The probability of getting 10 or less 'heads' results out of 20 flips is:
BinomDist ( 10 ; 20 ; 0.5 ; 1 ) = 58.81%
Note: these functions are not guaranteed
or supported by BrianDunning.com. Please contact the individual
developer with any questions or problems.
This is my Custom Function and I want to
edit it
Discuss:Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

Newest Custom Functions:
1. 
ProperAllWords ( text ) 

(Thu, Dec 14, 5:19pm) 
2. 
MatchExist ( SourceTable.Field ; DestTable.Field ; ReturnField ) 

(Thu, Dec 14, 1:07pm) 
3. 
BVR_Format ( bvr ) 

(Wed, Dec 13, 5:32pm) 
4. 
NumberToHexadecimal(NumberValue) 

(Fri, Dec 08, 8:54am) 
5. 
Get_BaseTable 

(Thu, Dec 07, 4:27pm) 
6. 
JSONCreateVarsFromKeys ( json ; namespace ) 

(Wed, Dec 06, 8:21pm) 
7. 
GetTableNzme ( field ) 

(Tue, Dec 05, 9:16pm) 
8. 
TimeFormatAsText ( theTime ) 

(Mon, Nov 13, 1:59pm) 


Thank you so much. I am not a statistician, but I am taking a course in Statistics at the monet, and I have an assignment to submit, I was wondering about the fucntion of cumulative TRUE or FALSE. Your explanation is first to understand.
Thank you.
My email address in case: michaelshafik@hotmail.com
Michael Shafik, Monterey, CA
January 12, 2013 5:12pm