COMBIN (combinations)

<< Click to Display Table of Contents >>

COMBIN (combinations)

Syntax:

COMBIN(n, k)

Description:

This returns the number of combinations of size k in a population of size n.

In plain language: n items are available in total. From these, a subset of exactly k items is to be drawn. This function calculates how many different subsets there can be.

n is the total number of items. n must be > k.

k is the number of items in each combination. k must be > 0 and < n.

n and k should be integers. If this is not the case, PlanMaker automatically truncates the decimal places.

Example:

Let's consider a lottery in which 6 balls are drawn from 49 different numbered balls.

How many combinations are possible?

COMBIN(49, 6) returns 13983816

Thus, there are 13,983,816 possible combinations.

See also:

PERMUT, BINOM.DIST.RANGE/BINOM.DIST/BINOMDIST