Probabilities for the binomial distribution can be calculated in Excel using the BINOM.DIST function.

This Excel function is especially useful when the value of n is large or p is not available in binomial

tables. Suppose that X follows a binomial distribution, where n = 100 and p = .45. Use Excel to find:

a) The probability that X = 50. Hint, use FALSE for the cumulative argument.

b) The probability that X 50. Hint, use TRUE for the cumulative argument.

c) The probability that X > 50.

d) The probability that 40 X 55.

Include the Excel function used and its result