Difference between revisions of "Manuals/calci/COMBIN"
Jump to navigation
Jump to search
Line 2: | Line 2: | ||
*<math>Number</math> is the number of items. | *<math>Number</math> is the number of items. | ||
− | *<math> | + | *<math>NumberChosen</math> is the number of items in each arrangement. |
+ | **COMBIN() returns the number of combinations for a given number of objects. | ||
==Description== | ==Description== | ||
Line 24: | Line 25: | ||
==ZOS== | ==ZOS== | ||
− | *The syntax is to calculate COMBIN in ZOS is <math>COMBIN(Number, | + | *The syntax is to calculate COMBIN in ZOS is <math>COMBIN(Number,NumberChosen)</math> |
**<math>Number</math> is the number of items. | **<math>Number</math> is the number of items. | ||
− | **<math> | + | **<math>NumberChosen</math> is the number of items in each arrangement. |
**For e.g.,COMBIN(20..23,6..7) | **For e.g.,COMBIN(20..23,6..7) | ||
**COMBIN(4,2)*COMBIN(10,5) | **COMBIN(4,2)*COMBIN(10,5) | ||
Line 34: | Line 35: | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
− | | COMBIN(Number, | + | | COMBIN(Number,NumberChosen) |
! Number | ! Number | ||
! Numberchosen | ! Numberchosen |
Revision as of 16:19, 18 June 2018
COMBIN(Number,Numberchosen)
- is the number of items.
- is the number of items in each arrangement.
- COMBIN() returns the number of combinations for a given number of objects.
Description
- This function gives the combination of the given number of objects.
- Let Number be "n" and Number chosen be "r".
- So the Combinations is an arrangement of objects without any repetition, selected from different objects is called a combination of objects taken at a time.
- For example consider three colors, like Blue,Yellow,Pink.There are three combinations of two can be drawn from the set:Blue and Yellow,Blue and Pink,or Yellow and Pink.
- If the order is not a matter, it is a Combination.
- If the order is a matter it is a Permutation.
- A combination is denoted by or or .
- A formula for the number of possible combinations of objects from a set of objects is:
where & .
- This function will give Error Result when
- The & are non numeric
- The & or
- When we are giving the & values in decimals, it will truncated into Integers.
- For e.g.
- COMBIN(5.4,2)=10 is equivalent to COMBIN(5,2)
- COMBIN(5,-2)=NAN, because is negative.
ZOS
- The syntax is to calculate COMBIN in ZOS is
- is the number of items.
- is the number of items in each arrangement.
- For e.g.,COMBIN(20..23,6..7)
- COMBIN(4,2)*COMBIN(10,5)
Examples
COMBIN(Number,NumberChosen) | Number | Numberchosen | RESULT |
---|---|---|---|
COMBIN(12,3) | 12 | 3 | 220 |
COMBIN(4,4) | 4 | 4 | 1 |
COMBIN(4,0) | 4 | 0 | 1 |
Related Videos
See Also
References