Manuals/calci/COMBIN

COMBIN(Number,Numberchosen)


  • is the number of items.
  • is the number of items in each arrangement.

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
  1. The   &   are non numeric
  2. 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 Section

  • The syntax is to calculate COMBIN in ZOS is COMBIN(Number,Numberchosen)
    •   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)
Combination

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

See Also

References

Combination