HypGeomDist ( sampleSuccesses ; sampleSize ; populationSuccesses ; ... )
Rate this function: Average rating: 4.0 (37 votes) Discuss this Custom Function
Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net
Returns the hypergeometric probability distribution of obtaining the number of successes in a sample, based on the success rate of the general population. Given the overall failure rate of a production line, HypGeomDist can calculate the probability of 3 items being defective in a shipment containing 100 items.
Sample Input:
HypGeomDist ( 1 ; 4 ; 8 ; 20 ; 0 )
HypGeomDist ( 1 ; 4 ; 8 ; 20 ; 1 ) 

Sample Output:
0.3632610939112487
0.4654282765737874 

Description:
Returns the hypergeometric probability distribution of obtaining the number of successes in a sample, based on the success rate of the general population. Given the overall failure rate of a production line, HypGeomDist can calculate the probability of 3 items being defective in a shipment containing 100 items.
Depending on the cumulative parameter, the HypGeomDist 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 HypGeomDist function parameters are:
sampleSuccesses  the number of successes in the sample;
sampleSize  the size of the sample;
populationSuccesses  the number of successes in the population;
populationSize  the size of the population ;
cumulative  a logical value that determines the form of the function: if cumulative is TRUE, HypGeomDist returns the cumulative probability of obtaining at most the number of successes; if FALSE, it returns the probability of obtaining exactly the number of successes.
Example:
A box of chocolates contains 20 pieces. Eight pieces contain a hazelnut. If a person selects 4 pieces at random, the probability of exactly 1 piece containing a hazelnut is:
HypGeomDist ( 1 ; 4 ; 8 ; 20 ; 0 ) = 36.33%
The probability of 1 piece or less containing a hazelnut is:
HypGeomDist ( 1 ; 4 ; 8 ; 20 ; 1 ) = 46.54%
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:There are no comments yet. Be the first to post a comment about this Custom Function! Please try to keep it brief & to the point. Anyone can post:

Newest Custom Functions:
1. 
PreviousMonthEndDate ( myDate ) 

(Wed, Mar 07, 3:35am) 
2. 
PreviousMonthName (myDate) 

(Wed, Mar 07, 3:33am) 
3. 
FmTableFields ( tableName ; fieldsInclude ; fieldsExclude ; classExclude ; typeExclude ; prefixExclude ) 

(Fri, Mar 02, 6:32am) 
4. 
sql.getTable ( fullyQualifiedFieldObject ) 

(Thu, Feb 22, 8:36am) 
5. 
sql.getField ( fullyQualifiedFieldObject ) 

(Thu, Feb 22, 8:34am) 
6. 
FilterOut ( ListA ; ListB ) 

(Wed, Feb 21, 6:11pm) 
7. 
Char0 ( ) 

(Sun, Feb 18, 2:35am) 
8. 
CreateVCardFile ( FirstName ; LastName ; CompanyName ; Phone ; Email ; WEB ; hAddress1 ; hAddress2 ; hZip ; hCity ; hCountry ; wAddress1 ; wAddress2 ; wZip ; wCity%2 

(Sun, Feb 18, 1:50am) 

