Originally Posted by
brumby_3 - Find the binomial probability: P(25 < B(45, 0.2) < 35) I tried: =BINOMDIST(34,45,0.2,1)-BINOMDIST(26,45,0.2,1) And it comes out as error. Can someone please tell me what I'm doing wrong. __________________ In a new sheet, enter the numbers 0 through
n = 30 in column A. Type 0 in A1, 1 in A2 and 2 in A3, then highlight the three cells, and drag the small square in the
bottom right corner until cell A31 which should read 30. In cell B1 calculate P(X = 0)
where X is a binomial random variable with n = 30 and p = 0.4 . Use the command
=BINOMDIST(A1,30,0.4,FALSE). Copy down to cell B31. Can someone please explain to me what I do in cell B1? Like what exactly am I supposed to type?
The fourth parameter in BINOMDIS should be TRUE for the cumulative distribution.
RonL