Changes

Jump to navigation Jump to search
no edit summary
Line 1: Line 1: −
<div style="font-size:30px">'''COMBIN(number,Numberchosen)'''</div><br/>
+
<div style="font-size:30px">'''COMBIN(Number,Numberchosen)'''</div><br/>
    
*<math>Number</math> is the number of items.
 
*<math>Number</math> is the number of items.
Line 5: Line 5:     
==Description==
 
==Description==
*This function gives the combination of <math>Number</math> objects.  
+
*This function gives the combination of the given number of objects.  
*i.e An arrangement of <math>Numberchosen</math> objects without any repetition, selected from <math>Number</math> different objects is called a combination of <math>Number</math> objects taken <math>Numberchosen</math> at a time.
+
*Let Number be "n" and Number chosen be "r".
 +
*So the Combinations is an arrangement of <math>r</math> objects without any repetition, selected from <math>n</math> different objects is called a combination of <math>n</math> objects taken <math>r</math> 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 not a matter, it is a Combination.  
 
*If the order is a matter it is a Permutation.
 
*If the order is a matter it is a Permutation.
*Let Number be "n" and Number chosen be "r".
+
*A combination is denoted by nCr or <math>\binom{n}{r}</math> or <math>C(n,r)</math>.  
*A combination is denoted by nCr or <math>\binom{n}{r}</math>.  
   
*A formula for the number of possible combinations of <math>r</math> objects from a set of <math>n</math> objects is:
 
*A formula for the number of possible combinations of <math>r</math> objects from a set of <math>n</math> objects is:
 
  <math>\binom{n}{r}=\frac{n!}{r!(n-r)!}</math>  
 
  <math>\binom{n}{r}=\frac{n!}{r!(n-r)!}</math>  
Line 28: Line 29:  
**<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)
    
==Examples==
 
==Examples==
writer
6,694

edits

Navigation menu