The following article introduces you to the HYPGEOM.DIST function - one of the functions in the statistical group is very popular in Excel.
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:
- Calculate the value of cumulative super multiple function. In a cell to calculate, enter the formula : = HYPGEOM.DIST (D6, D7, D8, D9, D10)
- Press Enter -> the value of cumulative super multiple function is:
- Calculate the value of the probability super function. In a cell to calculate, enter the formula : = HYPGEOM.DIST (D6, D7, D8, D9, D11)
- Press Enter -> probability super function value is:
Above are instructions and some specific examples when using HYPGEOM.DIST function in Excel.
Good luck!