Which Excel formula is utilized to compute hypergeometric probabilities?

Disable ads (and more) with a membership for a one time $4.99 payment

Prepare for the UCF QMB3200 Quantitative Business Tools II Exam. Study with comprehensive resources and practice multiple choice questions. Be exam-ready!

The formula used to compute hypergeometric probabilities in Excel is the one that correctly specifies the required arguments: the number of successes in the sample (x), the number of draws (n), the total number of successes in the population (r), the population size (N), and an optional argument for cumulative distribution (TRUE or FALSE).

This formula, =HYPGEOM.DIST(x, n, r, N, TRUE/FALSE cumulative), allows users to calculate either the probability mass function when the cumulative argument is set to FALSE or the cumulative distribution function when set to TRUE. This versatility makes it particularly useful for analyzing scenarios where the hypergeometric distribution applies, such as drawing without replacement from a finite population.

The other formulas listed do not accurately reflect the structure or syntax that Excel recognizes for hypergeometric calculations, either due to incorrect naming conventions or the arrangement of parameters. Understanding the proper use of the HYPGEOM.DIST function with its parameters is essential for effectively performing statistical analyses related to hypergeometric distributions.