Written by Determines the likelihood of obtaining a specific number of successful outcomes in a series of trials, based on a defined population size that includes a certain number of successes, without replacing the previously drawn samples.
Refer to HYPGEOMDIST function documentation.
Computes the harmonic mean of a data set.
Computes the geometric mean of a given dataset.
The GAUSS function calculates the probability that a random variable, sampled from a normal distribution, will lie between the mean and z standard deviations away (either above or below the mean).
Refer to GAMMA.INV for details.
Refer to GAMMA.DIST for details.
The GAMMA.INV function calculates the value of the inverse cumulative distribution function for the gamma distribution, using specified probability and parameters alpha and beta.
Calculates the gamma distribution, a continuous probability distribution characterized by two parameters.
Evaluates the Gamma function at a given input value.