Table of Contents
The HYPGEOMDIST function in Google Sheets is used to calculate the probability of a specific number of successes in a certain number of trials, given a specific population size and sample size. To use this function, you need to enter the number of successes, the sample size, the population size, and the cumulative value into the function’s syntax. The result will be a decimal value representing the probability. This function is especially useful in analyzing data and making statistical predictions. It can be accessed by typing “HYPGEOMDIST” into a cell in Google Sheets and following the required format.
HYPGEOMDIST
Calculates the probability of drawing a certain number of successes in a certain number of tries given a population of a certain size containing a certain number of successes, without replacement of draws.
Sample Usage
HYPGEOMDIST(4,12,20,40)
HYPGEOMDIST(A2,A3,A4,A5)
Syntax
HYPGEOMDIST(num_successes, num_draws, successes_in_pop, pop_size)
num_successes– The desired number of successes.num_draws– The number of permitted draws.successes_in_pop– The total number of successes in the population.pop_size– The total size of the population
Notes
BINOMDISTdescribes the probability of drawing a certain number of successes in a certain number of tries given a population of a certain size containing a certain number of successes, with replacement of draws.
See Also
NORMSINV: Returns the value of the inverse standard normal distribution function for a specified value.
NORMSDIST: Returns the value of the standard normal cumulative distribution function for a specified value.
NORMINV: Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation.
NORMDIST: The NORMDIST function returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation.
NEGBINOMDIST: Calculates the probability of drawing a certain number of failures before a certain number of successes given a probability of success in independent trials.
LOGNORMDIST: Returns the value of the log-normal cumulative distribution with given mean and standard deviation at a specified value.
LOGINV: Returns the value of the inverse log-normal cumulative distribution with given mean and standard deviation at a specified value.
EXPONDIST: Returns the value of the exponential distribution function with a specified lambda at a specified value.
BINOMDIST: Calculates the probability of drawing a certain number of successes (or a maximum number of successes) in a certain number of tries given a population of a certain size containing a certain number of successes, with replacement of draws.
Examples
[wpcc-iframe height=”300″ src=”https://docs.google.com/spreadsheet/pub?key=0As3tAuweYU9QdFc4Zzcwb0VlelE4dDh4UUY5d3NzUFE&output=html” width=”500″]
Cite this article
stats writer (2024). How do I use the HYPGEOMDIST function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-use-the-hypgeomdist-function-in-google-sheets/
stats writer. "How do I use the HYPGEOMDIST function in Google Sheets?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-use-the-hypgeomdist-function-in-google-sheets/.
stats writer. "How do I use the HYPGEOMDIST function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-use-the-hypgeomdist-function-in-google-sheets/.
stats writer (2024) 'How do I use the HYPGEOMDIST function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-use-the-hypgeomdist-function-in-google-sheets/.
[1] stats writer, "How do I use the HYPGEOMDIST function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I use the HYPGEOMDIST function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.