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=...")
 
 
(53 intermediate revisions by 5 users not shown)
Line 1: Line 1:
−
<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">
+
<div style="font-size:30px">'''COMBIN(Number,Numberchosen)'''</div><br/>
  
−
Syntax
+
*<math>Number</math> is the number of items.
 +
*<math>NumberChosen</math> is the  number of items in each arrangement.
 +
**COMBIN() returns the number of combinations for a given number of objects.
  
−
</div></div>
+
==Description==
−
----
+
*This function gives the combination of the given number of objects.
−
<div id="4SpaceContent" align="left"><div class="ZEditBox" align="justify">
+
*Let Number be "n" and Number chosen be "r".
 +
*So the Combinations is 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.
 +
*For example consider three colors, like Blue,Yellow,Pink.There are three combinations of two can be drawn from the set:Blue and Yellow,Blue and Pink,or Yellow and Pink.
 +
*If the order is not a matter, it is a Combination.
 +
*If the order is a matter it is a Permutation.
 +
*A combination is denoted by <math>^nC_r</math> or <math>\binom{n}{r}</math> or <math>C(n,r)</math>.
 +
*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
 +
#The <math>n</math> & <math>r</math> are non numeric
 +
#The <math>n</math> & <math>r < 0 </math> or <math>n < r</math>
 +
*When we are giving the <math>n</math> & <math>r</math> values in decimals, it will truncated into Integers.
 +
*For e.g.
 +
**COMBIN(5.4,2)=10 is equivalent to COMBIN(5,2)
 +
**COMBIN(5,-2)=#N/A (NUMBERCHOSEN > 0), because <math>r</math> is negative.
  
−
Remarks
+
==ZOS==
 +
*The syntax is to calculate COMBIN in ZOS is <math>COMBIN(Number,NumberChosen)</math>
 +
**<math>Number</math> is the number of items.
 +
**<math>NumberChosen</math> is the  number of items in each arrangement.
 +
**For e.g.,COMBIN(20..23,6..7)
 +
**COMBIN(4,2)*COMBIN(10,5)
 +
**COMBIN(12.3,3) gives 220, though COMBIN(12.3d,3n) gives 238.5995. Here, the use of higher number types (like big number, decimal, etc.) different logic is triggered. In base plain numbers and Number objects, the numbers are truncated.
  
−
</div></div>
+
{{#ev:youtube|cQXPq6y8bOw|280|center|Combin}}
−
----
 
−
<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="  " |
+
| COMBIN(Number,NumberChosen)
−
<div id="6Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
+
! Number
−
| Column1
+
! Numberchosen
−
| class="  " | Column2
+
! RESULT
−
| class="  " | Column3
+
|-
−
| class="  " | Column4
 
−
|- class="odd"
 
−
| class=" " | Row1
 
−
| class=" " | 35
 
−
| class="sshl_f " | 8
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|- class="even"
 
−
| class="  " | Row2
 
−
| class="sshl_f" | 23535820
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
 
|- class="odd"
 
|- class="odd"
−
| Row3
+
|COMBIN(12,3)
−
| class="sshl_f SelectTD SelectTD" |
+
|12
−
<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>
+
|3
−
| class="sshl_f" |
+
|220
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
 
|- class="even"
 
|- class="even"
−
| Row4
+
|COMBIN(4,4)
−
| class="sshl_f" |
+
|4
−
| class="sshl_f" |
+
|4
−
| class="sshl_f" |
+
|1
−
| class="sshl_f" |
 
 
|- class="odd"
 
|- class="odd"
−
| class=" " | Row5
+
|COMBIN(4,0)
−
| class="sshl_f" |
+
|4                                     
−
| class="sshl_f" |
+
|0
−
| class="sshl_f" |
+
|1
−
| class="sshl_f" |
 
−
|- class="even"
 
−
| Row6
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
 
|}
 
|}
 +
a=34!C!3
 +
5984
 +
 +
COMBIN(PERMUT(34, 3n), 3) (For Big Integer) OR a=34n!P!3!C!3 = 7713313203904
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|Bzuj8ItKT5w|280|center|COMBIN}}
 +
 +
==See Also==
  
−
<div align="left">[[Image:calci1.gif]]</div></div>
+
*[[Manuals/calci/FACT | FACT]]
−
----
+
*[[Manuals/calci/PERMUT | PERMUT ]]
−
<div id="9SpaceContent" class="zcontent" align="left"> 
 
  
−
Lets see an example in (Column1, Row 1 and Column 2, Row2)
+
==References==
 +
[http://en.wikipedia.org/wiki/Combination  Combination]
  
−
COMBIN (A, B)
 
  
−
COMBIN (C1R1, C2R1)''''''
 
  
−
That is COMBIN (35, 8) is 23535820
+
*[[Z_API_Functions | List of Main Z Functions]]
  
−
</div></div>
+
*[[ Z3 |  Z3 home ]]
−
----
 
−
</div></div></div></div></div></div></div>
 

Latest revision as of 03:18, 24 February 2022

COMBIN(Number,Numberchosen)


  • is the number of items.
  • is the number of items in each arrangement.
    • COMBIN() returns the number of combinations for a given number of objects.

Description

  • This function gives the combination of the given number of objects.
  • Let Number be "n" and Number chosen be "r".
  • So the Combinations is an arrangement of objects without any repetition, selected from different objects is called a combination of objects taken at a time.
  • For example consider three colors, like Blue,Yellow,Pink.There are three combinations of two can be drawn from the set:Blue and Yellow,Blue and Pink,or Yellow and Pink.
  • If the order is not a matter, it is a Combination.
  • If the order is a matter it is a Permutation.
  • A combination is denoted by or 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
  1. The & are non numeric
  2. The & or
  • When we are giving the & values in decimals, it will truncated into Integers.
  • For e.g.
    • COMBIN(5.4,2)=10 is equivalent to COMBIN(5,2)
    • COMBIN(5,-2)=#N/A (NUMBERCHOSEN > 0), because is negative.

ZOS

  • The syntax is to calculate COMBIN in ZOS is
    • is the number of items.
    • is the number of items in each arrangement.
    • For e.g.,COMBIN(20..23,6..7)
    • COMBIN(4,2)*COMBIN(10,5)
    • COMBIN(12.3,3) gives 220, though COMBIN(12.3d,3n) gives 238.5995. Here, the use of higher number types (like big number, decimal, etc.) different logic is triggered. In base plain numbers and Number objects, the numbers are truncated.
Combin

Examples

COMBIN(Number,NumberChosen) Number Numberchosen RESULT
COMBIN(12,3) 12 3 220
COMBIN(4,4) 4 4 1
COMBIN(4,0) 4 0 1 
a=34!C!3 
5984

COMBIN(PERMUT(34, 3n), 3) (For Big Integer) OR a=34n!P!3!C!3 = 7713313203904

Related Videos

COMBIN

See Also

References

Combination


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/COMBIN&oldid=216905"