Forum Discussion

Corrosive725's avatar
Corrosive725
Copper Contributor
Mar 18, 2023

Multivariate Hypergeometric Distribution Formula in Excel

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%5E%7B+%5Cmin%284%2C10-M-P%29%7D+%5Cfrac%7B+%5Cbinom%7B4%7D%7BM%7D+%5Cbinom%7B4%7D%7BP%7D+%5Cbinom%7B4%7D%7BT%7D+%5Cbinom%7B48%7D%7B10-M-P-T%7D+%7D%7B+%5Cbinom%7B60%7D%7B10%7D+%7D+%3D+12.6%5C%25.&bg=ffffff&fg=000000&s=0

 

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

Can someone help me implement Σ into my Excel sheet?

Resources