Combination

Purpose

Returns the number of ways to uniquely choose numberOfChoices items from a set of size setSize.

Format

Combination(setSize;numberOfChoices)

Parameters

numberOfChoices - any numeric expression or field containing a non-negative numeric expression

Data type returned

number

Originated in

FileMaker Pro 7.0

Description

This function is useful in statistics, combinatorics, and polynomial expansions. The values returned by this function are referred to as combination coefficients. They form Pascalâ€™s triangle.

Examples

Combination(5;2) returns 10 for a set consisting of {a, b, c, d, e} because the unique choices when choosing two at a time are {ab, ac, ad, ae, bc, bd, be, cd, ce, de}.

(13 * 12 * Combination(4;2) * Combination(4;3)) / Combination(52;5) returns 0.00144057..., which is the probability of being dealt a full-house in 5-card poker (less than a 1% chance).

Was this topic helpful? Send feedback.