| | | This function returns the probability of a given number of sample successes, given the sample size, population successes, and population size. |
| | | You should use this function for problems with a finite population, where each observation is either a success or a failure, and where each subset of a given size is chosen with equal likelihood. |
| | | All arguments are truncated to integers. |
| | | If any argument is nonnumeric, then #VALUE! is returned. |
| | | If "sample_s" < 0 or "sample_s" is greater than the lesser of "number_sample" or "population_s", then #NUM! is returned. |
| | | If "sample_s" < ("number_sample" - "number_population" + "population_s"), then #NUM! is returned. |
| | | If "number_sample" < 0, then #NUM! is returned. |
| | | If "number_sample" > "number_population", then #NUM! is returned. |
| | | If "population_s" < 0, then #NUM! is returned. |
| | | If "population_s" > "number_population", then #NUM! is returned. |
| | | If "number_population" < 0, then #NUM! is returned. |
| | | The accuracy of this function was improved in Excel 2003. For more information please refer to this Knowledge Base Article (828515). |
| | | | A | | 1 | =HYPGEOMDIST(1,4,8,20) = 0.363 | | 2 | =HYPGEOMDIST(1,2,3,4) = 0.5 | | 3 | =HYPGEOMDIST(5,10,10,20) = 0.3 | | 4 | =HYPGEOMDIST(5,10,5,20) = 0 | | 5 | =HYPGEOMDIST(-1,4,8,20) = #NUM! | | 6 | =HYPGEOMDIST(6,4,8,20) = #NUM! |
| |
