Difference between revisions of "Manuals/calci/COMBIN"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="4SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''COMBIN(n,r)'''</div><br/> |
| − | + | *'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== | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | | + | | CHIDIST(x,df) |
| − | + | ! x | |
| − | + | ! df | |
| − | + | ! RESULT | |
| − | + | |- | |
| − | | | ||
|- class="odd" | |- class="odd" | ||
| − | | | + | |CHIDIST(18,2) |
| − | | | + | |18 |
| − | | | + | |2 |
| − | | | + | |0.0001234098 |
| − | |||
|- class="even" | |- class="even" | ||
| − | | | + | |CHIDIST(15,1) |
| − | | | + | |15 |
| − | | | + | |1 |
| − | | | + | |0.0001075112 |
| − | |||
|- class="odd" | |- class="odd" | ||
| − | | | + | |CHIDIST(2,1) |
| − | | | + | |2 |
| − | + | |1 | |
| − | + | |0.157299207050 | |
| − | | | ||
| − | | | ||
|- class="even" | |- class="even" | ||
| − | | | + | |CHIDIST(-2,1) |
| − | | | + | |(-)2 |
| − | + | |1 | |
| − | | | + | |error |
| − | | | ||
|- class="odd" | |- class="odd" | ||
| − | | | + | |CHIDIST(2,-1) |
| − | + | |2 | |
| − | + | |(-)1 | |
| − | + | |error | |
| − | | | ||
| − | |- | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | | ||
|} | |} | ||
| − | + | ==See Also== | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | *[[Manuals/calci/CHITEST | CHITEST]] | |
| − | + | ==References== | |
| − | + | [http://en.wikipedia.org/wiki/Complex_number| Complex Numbers] | |
| − | |||
Revision as of 05:40, 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 |