Written by Generates the likelihood that values within a range fall between two specified limits.
Calculates the hypergeometric distribution.
Calculates the likelihood that a randomly selected value from a specified set lies within designated limits, based on provided probabilities.
Refer to the function POISSON.DIST for detailed insights.
Determines the likelihood of experiencing a specified number of failures before achieving a designated number of successes, given a particular success probability across independent trials.
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.
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).
Calculates the gamma distribution, a continuous probability distribution characterized by two parameters.
Computes the left-tailed F probability distribution (a measure of diversity) for two distinct data sets based on specified input x. Also known as the Fisher-Snedecor distribution or Snedecor’s F distribution.