Difference between revisions of "Manuals/calci/COMBIN"
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
==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 doesn't a matter, it is a combination. | + | *Also if the order doesn't a matter, it is a combination. |
| − | If order is the matter it is a permutation. | + | *If order is the matter it is a permutation. |
| − | A combination is dnoted by ncr or(n r). | + | *A combination is dnoted 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. |
*CHIDIST(-2,1)=Error,because x is negative. | *CHIDIST(-2,1)=Error,because x is negative. | ||
Revision as of 05:41, 12 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 dnoted 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.
- CHIDIST(-2,1)=Error,because x is negative.
- CHIDIST(2,-1)=Error, because df<1
Examples
| CHIDIST(x,df) | x | df | RESULT |
|---|---|---|---|
| CHIDIST(18,2) | 18 | 2 | 0.0001234098 |
| CHIDIST(15,1) | 15 | 1 | 0.0001075112 |
| CHIDIST(2,1) | 2 | 1 | 0.157299207050 |
| CHIDIST(-2,1) | (-)2 | 1 | error |
| CHIDIST(2,-1) | 2 | (-)1 | error |