Difference between revisions of "Manuals/calci/COMBIN"

From ZCubes Wiki
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>Numberchosen</math> is the  number of items in each arrangement.  
+
*<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,Numberchosen)</math>
+
*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>Numberchosen</math> is the  number of items in each arrangement.
+
**<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,Numberchosen)
+
| COMBIN(Number,NumberChosen)
 
! Number
 
! Number
 
! Numberchosen
 
! Numberchosen

Revision as of 17: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
  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

  • 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)
Combin

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

COMBIN

See Also

References

Combination