Difference between revisions of "Manuals/calci/COMBIN"

From ZCubes Wiki
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 id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">
+
<div style="font-size:30px">'''COMBIN(n,r)'''</div><br/>
  
Syntax
+
*'N' is the number of items.
 +
*'R' is the  number of items in each arrangement.
  
</div></div>
+
==Description==
----
+
This function gives the combination of N objects.
<div id="4SpaceContent" align="left"><div class="ZEditBox" align="justify">
+
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.
  
Remarks
+
*CHIDIST(-2,1)=Error,because x is negative.
 
+
*CHIDIST(2,-1)=Error, because df<1
</div></div>
 
----
 
<div id="2SpaceContent" align="left"><div class="ZEditBox" align="justify">
 
 
 
Examples
 
 
 
</div></div>
 
----
 
<div id="8SpaceContent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman">''''''''''''<font size="6"> </font>''' '''''''''</font>'''</div></div>
 
----
 
<div id="11SpaceContent" align="left"><div class="ZEditBox mceEditable" align="justify">
 
 
 
<font size="5">Description</font>
 
 
 
</div></div>
 
----
 
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman"> <font size="6">COMBIN</font> </font>'''</div></div>
 
----
 
<div id="3SpaceContent" class="zcontent" align="left"><br /><div id="7Space" class="gamizbox" title="7Space"><div id="7SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="7SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="7SpaceRollupContent" align="center"></span></span></div><div id="7SpaceCover"><div id="7SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">
 
 
 
'''COMBIN''' (N, M)
 
 
 
'''Where N''' is the no. of items and M is the no. of items in the arrangement.
 
 
 
</div></div>
 
----
 
<div id="13SpaceContent" class="zcontent" align="left"><br /><br /><div id="1Space" class="gamizbox" title="1Space"><div id="1SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="1SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="1SpaceRollupContent" align="center"></span></span></div><div id="1SpaceCover"><div id="1SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">
 
 
 
·          COMBIN calculates an error value when the argument is nonnumeric.
 
 
 
·          The number of combinations is as follows, where N(no. of items) = n and M(no. of items in the arrangement) = k:
 
 
 
Formula:-
 
 
 
</div></div>
 
----
 
<div id="14SpaceContent" class="zcontent" align="left"><br /><br /><br /><div id="5Space" class="gamizbox" title="5Space"><div id="5SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="5SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="5SpaceRollupContent" align="center"></span></span></div><div id="5SpaceCover"><div id="5SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">
 
 
 
It calculates the number of combinations for the known items.
 
 
 
</div></div>
 
----
 
<div id="12SpaceContent" class="zcontent" align="left"><br /><br /><br /></div></div>
 
----
 
<div id="6SpaceContent" class="zcontent" align="left">
 
  
 +
==Examples==
 
{| id="TABLE3" class="SpreadSheet blue"
 
{| id="TABLE3" class="SpreadSheet blue"
 
|- class="even"
 
|- class="even"
| class="  " |
+
| CHIDIST(x,df)
<div id="6Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
+
! x
| Column1
+
! df
| class="  " | Column2
+
! RESULT
| class="  " | Column3
+
|-
| class="  " | Column4
 
 
|- class="odd"
 
|- class="odd"
| class=" " | Row1
+
|CHIDIST(18,2)
| class=" " | 35
+
|18
| class="sshl_f " | 8
+
|2
| class="sshl_f" |
+
|0.0001234098
| class="sshl_f" |
 
 
|- class="even"
 
|- class="even"
| class="  " | Row2
+
|CHIDIST(15,1)
| class="sshl_f" | 23535820
+
|15
| class="sshl_f" |
+
|1
| class="sshl_f" |
+
|0.0001075112
| class="sshl_f" |
 
 
|- class="odd"
 
|- class="odd"
| Row3
+
|CHIDIST(2,1)
| class="sshl_f SelectTD SelectTD" |
+
|2                                     
<div id="6Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="6Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
+
|1
| class="sshl_f" |
+
|0.157299207050
| class="sshl_f" |
 
| class="sshl_f" |
 
 
|- class="even"
 
|- class="even"
| Row4
+
|CHIDIST(-2,1)
| class="sshl_f" |
+
|(-)2
| class="sshl_f" |
+
|1
| class="sshl_f" |
+
|error
| class="sshl_f" |
 
 
|- class="odd"
 
|- class="odd"
| class=" " | Row5
+
|CHIDIST(2,-1)
| class="sshl_f" |
+
|2                                     
| class="sshl_f" |
+
|(-)1
| class="sshl_f" |
+
|error
| class="sshl_f" |
 
|- class="even"
 
| Row6
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
 
|}
 
|}
  
<div align="left">[[Image:calci1.gif]]</div></div>
+
==See Also==
----
 
<div id="9SpaceContent" class="zcontent" align="left"> 
 
 
 
Lets see an example in (Column1, Row 1 and Column 2, Row2)
 
 
 
COMBIN (A, B)
 
 
 
COMBIN (C1R1, C2R1)''''''
 
  
That is COMBIN (35, 8) is 23535820
+
*[[Manuals/calci/CHITEST | CHITEST]]
  
</div></div>
+
==References==
----
+
[http://en.wikipedia.org/wiki/Complex_number| Complex Numbers]
</div></div></div></div></div></div></div>
 

Revision as of 06: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

See Also

References

Complex Numbers