Difference between revisions of "Manuals/calci/COMBIN"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''COMBIN( | + | <div style="font-size:30px">'''COMBIN(n,r)'''</div><br/> |
| − | *<math> | + | *<math>n</math> is the number of items. |
| − | *<math> | + | *<math>r</math> is the number of items in each arrangement. |
==Description== | ==Description== | ||
| − | *This function gives the combination of | + | *This function gives the combination of <math>n</math> objects. |
| − | *i.e. An arrangement of | + | *i.e. 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. |
*Also if the order is not a matter, it is a Combination. | *Also if the order is not a matter, it is a Combination. | ||
*If order is a matter it is a Permutation. | *If order is a matter it is a Permutation. | ||
*A combination is denoted by nCr or <math>\binom{n}{r}</math>. | *A combination is denoted by nCr or <math>\binom{n}{r}</math>. | ||
| − | *A formula for the number of possible combinations of | + | *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> where <math>n!=1*2*3*...*n </math> & <math>r \le n</math>. |
*This function will give Error Result when | *This function will give Error Result when | ||
| − | + | #The <math>n & r</math> are non numeric | |
| − | + | #The <math>n & r < 0</math> or <math>n < r</math> | |
| − | *When we are giving the | + | *When we are giving the <math>n & r</math> values in decimals, it will automatically convert in to Integers. |
*For e.g. | *For e.g. | ||
**COMBIN(5.4,2)=10 is equivalent to COMBIN(5,2) | **COMBIN(5.4,2)=10 is equivalent to COMBIN(5,2) | ||
| − | **COMBIN(5,-2)=NAN, because | + | **COMBIN(5,-2)=NAN, because <math>r</math> is negative. |
==Examples== | ==Examples== | ||
Revision as of 23:35, 18 November 2013
COMBIN(n,r)
- is the number of items.
- is the number of items in each arrangement.
is the number of items.
is the number of items in each arrangement.Description
- This function gives the combination of objects.
- i.e. An arrangement of objects without any repetition, selected from different objects is called a combination of objects taken at a time.
- Also if the order is not a matter, it is a Combination.
- If order is a matter it is a Permutation.
- A combination is denoted by nCr 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
.
where 
& 
.- The Failed to parse (syntax error): {\displaystyle n & r} are non numeric
- The Failed to parse (syntax error): {\displaystyle n & r < 0} or
- When we are giving the Failed to parse (syntax error): {\displaystyle n & r} values in decimals, it will automatically convert in to Integers.
- For e.g.
- COMBIN(5.4,2)=10 is equivalent to COMBIN(5,2)
- COMBIN(5,-2)=NAN, because is negative.
Examples
| COMBIN(n,r) | n | r | RESULT |
|---|---|---|---|
| COMBIN(12,3) | 12 | 3 | 220 |
| COMBIN(4,4) | 4 | 4 | 1 |
| COMBIN(4,0) | 4 | 0 | 1 |