| Line 1: |
Line 1: |
| | <div style="font-size:30px">'''COMBIN(N,R)'''</div><br/> | | <div style="font-size:30px">'''COMBIN(N,R)'''</div><br/> |
| | | | |
| − | *'N' is the number of items. | + | *<math>N</math> is the number of items. |
| − | *'R' is the number of items in each arrangement. | + | *<math>R</math> is the number of items in each arrangement. |
| | | | |
| | ==Description== | | ==Description== |
| | *This function gives the combination of N objects. | | *This function gives the combination of N objects. |
| − | *i.e.An arrangement of R objects without any repetition, | + | *i.e. An arrangement of R objects without any repetition, selected from N different objects is called a combination of N objects taken R at a time. |
| − | *selected from N different objects is called a combination of N objects taken R at a time.
| + | *Also if the order is not a matter, it is a Combination. |
| − | *Also if the order doesn't a matter, it is a combination. | + | *If order is a matter it is a Permutation. |
| − | *If order is the matter it is a permutation. | + | *A combination is denoted by nCr or <math>\binom{n}{r}</math>. |
| − | *A combination is denoted by ncr or(n r). | + | *A formula for the number of possible combinations of R objects from a set of N objects is <math>\binom{n}{r}=\frac{\fact{n}}{\frac{r}\frac{n-r}}(n r)=n!/r!(n-r)!, where n!=1*2*3*...*n& r<=n. |
| − | *A formula for the number of possible combinations of R objects from a set of N objects is (n r)=n!/r!(n-r)!, where n!=1*2*3*...*n& r<=n. | |
| | *This function will give the result is Error when | | *This function will give the result is Error when |
| | *1.The N&R are non numeric | | *1.The N&R are non numeric |