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.
However I want the number of draws,successes etc. to be variable
Can someone help me implement Σ into my Excel sheet?
1 Reply
Sort By
- peiyezhuBronze ContributormatLab may helpful to do this kind of calculation rather than Excel