Q IO. If you want to find probabiliy of gettmg exactly 3 successes in 5 trnk wih a success a) 3, 0.2, TRUE) b) -BINOM.DIST(5, 3, 0.2, FALSE) c) -BINOM.DIST(3, 5, 0.2, TRUE) d) -BINOM.DIST(3, 5, 0.2, FALSE)

The correct answer is d) -BINOM.DIST(3, 5, 0.2, FALSE).

Here's why:

The BINOM.DIST function in Excel calculates the probability of a fixed number of successes in a certain number of trials, given a certain probability of success.

The syntax of the function is BINOM.DIST(number_s, trials, probability_s, cumulative).

• number_s is the number of successes we want to find the probability for. In this case, it's 3.
• trials is the number of trials, which is 5 here.
• probability_s is the probability of success on each trial. Here, it's 0.2.
• cumulative is a logical value that determines the form of the function. If cumulative is TRUE, then BINOM.DIST returns the cumulative distribution function, which is the probability that there are at most number_s successes. If cumulative is FALSE, then BINOM.DIST returns the probability mass function, which is the probability that there are exactly number_s successes. In this case, since we want the probability of exactly 3 successes, cumulative should be FALSE.

So, the correct function is BINOM.DIST(3, 5, 0.2, FALSE).