The HYPGEOMDIST function in Google Sheets calculates the probability of drawing a specific number of successes without replacement from a finite population.

Here's how the function's arguments are used:

num_successes: This is the number of successes you want to calculate the probability for.

num_draws: It represents the total number of draws or samples taken from the population.

successesinpop: This denotes the total number of successes in the population.

pop_size: This is the size of the population.

The HYPGEOMDIST function uses the hypergeometric distribution to compute the probability.

This distribution is commonly used when sampling without replacement from a finite population, where the probability of success changes with each draw.

The syntax for the HYPGEOMDIST function in Google Sheets is as follows:

HYPGEOMDIST(numsuccesses, numdraws, successesinpop, pop_size)

It will return the probability of observing exactly numsuccesses successes in numdraws draws from a population of size popsize, given that there are successesin_pop successes in the population.

Note that the HYPGEOMDIST function assumes that the draws are made without replacement, meaning that once an item is drawn, it is not put back into the population for subsequent draws.