Related Topics: | ||
Description: Returns the number of combinations for a given number of objects. Use COMBIN to determine the total possible number of groups for a given number of items.
Syntax: COMBIN(Number, Number_chosen)
Number is the number of items.
Number_chosen is the number of items in each combination.
Remarks:
Both arguments must be numerical integers >= 0 and Number >= Number_chosen.
A combination is any set or subset of items, regardless of their internal order. Combinations are distinct from permutations, for which the internal order is significant.
The number of combinations is calculated as follows:
where:
When used in a RENO flowchart, the parameters must evaluate to numerical values. They can include:
Numerical values
Standard operands (+, -, *, /)
Predefined mathematical functions (exp, log, sin, etc.)
References to any analysis workbooks
Example:
Determine the possible two-person teams that can be formed from 8 candidates.
COMBIN(8,2) = 28
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.