INTRODUCTION
COMBIN function comes under the MATH AND TRIG category in Excel.
COMBIN function returns the number of possible combinations with the specified number of items.
COMBIN function performs the calculation based on the COMBINATION concept of MATHEMATICS.
LET US UNDERSTAND THE COMBINATION CONCEPT FIRST.
Suppose , there are three different persons and we need to create a group of two persons.
Now if we need to find out ,in how many ways two out of three persons can be chosen to make a group of two.
Suppose there are three persons
A,B and C.
So different groups can be
AB
AC
BC
i.e. There can be three groups.
In Mathematics the direct formula for the same calculation is
nCr where n is the number of items. r is the size of group.
nCr is elaborated as n!/(n-r)!r!
where n!=nx n-1 x n-2 x n-3x ….1
Now , let us put the above mentioned example into the formula.
In the above example
n=3
r=2
so Number of combinations= 3!/2!1!
=3×2/2
=3
which is exactly same result what we got when we tried to calculate the same manually.
PURPOSE OF COMBIN FUNCTION IN EXCEL
COMBIN function returns the number of possible combinations with the specified number of items.
PREREQUISITES TO LEARN COMBIN
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in Excel.
- Some information about the financial terms is an advantage for the use of such formulas.
- Of course, Excel software.
Helpful links for the prerequisites mentioned aboveWhat Excel does? How to use formula in Excel?
SYNTAX: COMBIN FUNCTION
The Syntax for the function is
=COMBIN(NUMBER OF ITEMS, NUMBER OF ITEMS IN SUBGROUP)NUMBER OF ITEMS Number of total itemsNUMBER OF ITEMS IN SUBGROUP Number of items which are to be chosen from the total items
EXAMPLE:COMBIN FUNCTION IN EXCEL
DATA SAMPLE
We will try to find out the different combination possible for two cases involving 3 numbers and 4 numbers and selecting
2 numbers from the group.
The analysis is done manually as well as using the COMBIN function.
STEPS TO USE COMBIN FUNCTION
To demonstrate the usage of the function in different ways, we have taken two examples which have 3 and 4 numbers respectively.
The groups are to be formed of 2 numbers each.
In manual examples, the grouping has been done manually and the groups are shown in the rows.
The same groups are put for testing under the function COMBIN.
The function used is
=COMBIN(3,2) and =COMBIN(4,2).
First case has 3 numbers and 2 is the size of the group.
Second case has 4 numbers and 2 is the size of the group.
which gives the same result as the manual cases.
KNOWLEDGE BYTES
COMBINATION USING COMBIN FUNCTION
PERMUTATION AND COMBINATION , you must be acquainted with this word in higher mathematics.
We calculate the permutations for the different possible arrangements of the given number of items. It is calculated by
n!/(n-r)!.
where n!= n x n-1 x n-2 x…..1
So, when we need to make groups, we need not take into consideration, the number of permutations between the same number of selection as AB and BA are same when we talk about combination.
So for combination the formula is converted into
n!/(n-r)!.r!