Probability Assignment | Professional Writing Services
January 20th, 2020
Probabilities for the binomial distribution can be calculated in Excel using the BINOM.DIST function.
Don't use plagiarized sources. Get Your Assignment on
Probability Assignment | Professional Writing Services
Just from $13/Page
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
Get Statistics homework help today