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

For information on how to use the Excel help option or visit the website:

https://support.office.com/en-us/article/BINOM-DIST-function-c5ae37b6-f39c-4be2-94c2-

509a1480770c

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