RandHyperGeometric(select,total,success,number)

Generates number random hypergeometric trials.  RandHyperGeometric returns the number of successes when select selections are made, without replacement, from a total where success successes are present.

For example, five marbles are drawn, without replacement, from a bag of 10 marbles, six red and four green.  How many red marbles will be drawn?

You can simulate this problem thirty times using RandHyperGeometric(5,10,6,30) and you might generate the following data.

3, 2, 3, 4, 1, 4, 2, 3, 3, 3, 3, 3, 3, 5, 4, 4, 3, 3, 3, 3, 2, 3, 3, 3, 2, 3, 4, 2, 3, 3

Note:  If you type decimals using a comma (eg 3,2) you should enter this formula as RandHyperGeometric(5; 10; 6; 30)  - using the ; as a separator