Microsoft Office Tutorials and References

In Depth Information

**COS**

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

with combinations.

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.

NUMBER

The number of items in each combination.

ITEMS

Figure 10.9

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.

=COS(number)

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().