Multivariate Hypergeometric Distribution Formula in Excel

Copper Contributor

Im trying to make a hypergeometric calculator using Excel, however I have come to a problem in that I have a formula using Σ and it is not feasible for me to write all the things I want to sum up into different cells, as that would be way too many Cell to fill with the formula.

The Formula is akin to this:


However I want the number of draws,successes etc. to be variable

Can someone help me implement Σ into my Excel sheet?

1 Reply
matLab may helpful to do this kind of calculation rather than Excel