Excel's BINOM.DIST function can be used to compute
A)bin width for histograms
B)binomial probabilities
C)cumulative binomial probabilities
D)both binomial probabilities and cumulative binomial probabilities are correct.

Question

Quizplus · Accepted Answer

The BINOM.DIST function in Excel can be used to compute both binomial probabilities (i.e., the probability of a certain number of successes in a certain number of trials) and cumulative binomial probabilities (i.e., the probability of getting a certain number of successes or fewer in a certain number of trials). Therefore, option D is the correct choice. Option A is incorrect because bin width for histograms is not related to the BINOM.DIST function. Option B is partially correct, but it does not account for the fact that the function can compute cumulative probabilities as well. Option C is also partially correct, but it fails to mention that the function can also compute non-cumulative probabilities.

Excel's BINOM.DIST Function Can Be Used to Compute