Answered You can hire a professional tutor to get the answer.
Probabilities for the binomial distribution can be calculated in Excel using the BINOM.DIST function.
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
