HYPGEOM.DIST - The function returns the hyperbolic distribution in Excel

The following article introduces you to the HYPGEOM.DIST function - one of the functions in the statistical group is very popular in Excel.

HYPGEOM.DIST - The function returns the hyperbolic distribution in Excel Picture 1

Description: The function returns the hypergeometric distribution, using this function for whether finite set of vowismooix observations can be successful or not.

Syntax: HYPGEOM.DIST (sample_s, number_sample, population_s, number_pop, cumulative)

Inside:

- sample_s: Number of successes in the sample, a required parameter.

- number_sample: The size of the sample, is a required parameter.

- population_s: Number of successes, required.

- number_pop: Size of the collection, is the required parameter.

- cumulative: A logical value that determines the form of the function, which is an optional parameter consisting of the following values:

+ cumulative = True -> returns the cumulative distribution function.

+ cumulative = False -> returns the probability density function.

Attention:

- Any arguments of functions that are not whole numbers -> they are truncated into integers.

- If any argument value is not a number form -> the function returns the #VALUE! Error value

- If sample_s <0 or sample_s is bigger than the smaller of two: number_sample or population_s -> the function returns the #NUM! Error value

- If sample_s is smaller than the bigger of the two: 0 and ( number_sample - number_population + population_s ) -> the function returns the #NUM! Error value !

- If number_sample ≤ 0 or number_sample> number_population -> the function returns the #NUM! Error value

- If population_s ≤ 0 or population_s> number_population -> the function returns the #NUM! Error value

- If number_pop ≤ 0  -> the function returns the #NUM! Error value

- The hyperbolic distribution equation is:

[Pleft ({X = x} right) = hleft ({x; n, M, N} right) = frac {{left ({begin {array} {* {20} {c}}
M
x
end {array} } right) left ({begin {array} {* {20} {c}}
{N - M,}
{n - x}
end {array}} right)}} {{left ({begin {array} {* {20} {c}}
N
n
end {array}} right)}}]

Inside:

+ x = sample_s

+ n = number_sample

+ M = population_s

+ N = number_pop

- The HYPGEOM.DIST function is for sampling but does not replace a finite set.

For example:

Calculate the cumulative hypercapacity and probability distribution function with the data in the following data table:

HYPGEOM.DIST - The function returns the hyperbolic distribution in Excel Picture 2

- Calculate the value of cumulative super multiple function. In a cell to calculate, enter the formula : = HYPGEOM.DIST (D6, D7, D8, D9, D10)

HYPGEOM.DIST - The function returns the hyperbolic distribution in Excel Picture 3

- Press Enter -> the value of cumulative super multiple function is:

HYPGEOM.DIST - The function returns the hyperbolic distribution in Excel Picture 4

- Calculate the value of the probability super function. In a cell to calculate, enter the formula : = HYPGEOM.DIST (D6, D7, D8, D9, D11)

HYPGEOM.DIST - The function returns the hyperbolic distribution in Excel Picture 5

- Press Enter -> probability super function value is:

HYPGEOM.DIST - The function returns the hyperbolic distribution in Excel Picture 6

Above are instructions and some specific examples when using HYPGEOM.DIST function in Excel.

Good luck!