Quote:

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