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: https://s0.wp.com/latex.php?latex=%5Csum_%7BM%3D1%7D%5E4+%5Csum_%7BP%3D1%7D%5E4+%5Csum_%7BT%3D1%7D%5...

 

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