Microsoft Office Tutorials and References
In Depth Information
The ITEMS argument is the number of items in each combination and it must be between zero
and the value of the number argument for the function to work correctly. Although
noninteger values can be used in the COMBIN function, they have no mathematical significance,
and they are automatically rounded to integers.
Combinations are similar to permutations in that groupings of objects are made from a larger
set of objects. However, with permutations, the internal order is significant, while it is not
Notice the example in Figure 10.9. An example of the similar PERMUT function (see Chapter
11, “Statistical Functions”) is also shown. In the example, there are 8 linemen, 6 receivers,
4 running backs, and 2 quarterbacks on a given football team. How many different ways can
a team of 11 offensive players be chosen if 5 linemen, 3 receivers, 4 running backs, and
1 quarterback are used? The answer: 13,440.
The number of items.
The number of items in each combination.
Use the COMBIN
function to return the
number of combinations
that can be used with
different sets of data.
COS The COS function returns the cosine of the given angle.
The NUMBER argument is the angle in radians for which you want the cosine.
As with all normal trigonometric functions in Excel, you can convert the result from radians
to degrees by multiplying it by 180/PI().