Excel Function : HYPGEOM.DIST
Returns the hypergeometric distribution
Microsoft Excel Reference Page
Syntax and Description of the HYPGEOM.DIST Excel Function
I have a excel function
HYPGEOM.DIST(sample_s, number_sample, population_s, number_population, False) which I am trying to get in python. Sample_s, number_sample, population_s, number_population are variables.
I am trying to get the same output with this python code:
from scipy import stats
z = stats.hypergeom(population_s, number_population, number_sample)
print(z.sf(sample_s - 1))
but I am not getting the same output.
I don't think
About HYPGEOM.DIST Excel Function
The HYPGEOM.DIST function returns the hypergeometric distribution. For example, if you have a deck of cards and draw five cards, the function can calculate the probability of drawing exactly two hearts.