Difference between revisions of "Manuals/calci/COMBIN"
Jump to navigation
Jump to search
| Line 12: | Line 12: | ||
*A combination is denoted by ncr or(n r). | *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 (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 |
| − | 2. The N&R<0 or N<R | + | *2. The N&R<0 or N<R |
| − | When we are giving the N&R values in decimals ,it will convert in to Integers. | + | *When we are giving the N&R values in decimals ,it will convert in to Integers. |
| − | + | *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 R is negative. | *COMBIN(5,-2)=NAN, because R is negative. | ||
Revision as of 00:52, 18 November 2013
COMBIN(N,R)
- 'N' is the number of items.
- 'R' is the number of items in each arrangement.
Description
- This function gives the combination of N objects.
- 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.
- Also if the order doesn't a matter, it is a combination.
- If order is the matter it is a permutation.
- 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 (n r)=n!/r!(n-r)!, where n!=1*2*3*...*n& r<=n.
- This function will give the result is Error when
- 1. The N&R are non numeric
- 2. The N&R<0 or N<R
- When we are giving the N&R values in decimals ,it will convert in to Integers.
- For e.g.
- COMBIN(5.4,2)=10 is equivalent to COMBIN(5,2)
- COMBIN(5,-2)=NAN, because R 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 |