Forum Discussion
Corrosive725
Mar 18, 2023Copper Contributor
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?
1 Reply
- peiyezhuBronze ContributormatLab may helpful to do this kind of calculation rather than Excel