| 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== |