Results 1 to 6 of 6

Math Help - binomial probability

  1. #1
    Member
    Joined
    Jul 2008
    Posts
    212

    binomial probability

    - 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?
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Grand Panjandrum
    Joined
    Nov 2005
    From
    someplace
    Posts
    14,972
    Thanks
    4
    Quote Originally Posted by brumby_3 View Post
    - 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

    Follow Math Help Forum on Facebook and Google+

  3. #3
    Member
    Joined
    Jul 2008
    Posts
    212
    it still doesn't work. I get the same answer which is 4.92803E-09


    ?????? lol

    And same with the second half of my question - I keep getting a funny looking number with an E in it.
    Follow Math Help Forum on Facebook and Google+

  4. #4
    Grand Panjandrum
    Joined
    Nov 2005
    From
    someplace
    Posts
    14,972
    Thanks
    4
    Quote Originally Posted by brumby_3 View Post
    it still doesn't work. I get the same answer which is 4.92803E-09


    ?????? lol

    And same with the second half of my question - I keep getting a funny looking number with an E in it.
    Ahh.. you said it comes out as error, not that you thought the answer was wrong!

    What makes you think that that is wrong?

    The mean number of successes in 45 trials with p=0.2 is 9, 25 is a long way above 9, so far in fact that for most purposes the cumulative probability of 25 or fewer successes is indistinguishable from 1.

    (Note BINOMDIS runs out of prescission before you get to 34 triaks in this case, and the cumulative returned is greater than 1, but that should not metter)

    Also:

    P(25 < B(45, 0.2) < 35)=Q(34)-Q(25)

    where Q denote the cumulative distribution, not:

    P(25 < B(45, 0.2) < 35)=Q(34)-Q(26)

    which is what you have.

    RonL
    Follow Math Help Forum on Facebook and Google+

  5. #5
    Member
    Joined
    Jul 2008
    Posts
    212
    So it's right? Even with the E- in it? O_O
    Follow Math Help Forum on Facebook and Google+

  6. #6
    Grand Panjandrum
    Joined
    Nov 2005
    From
    someplace
    Posts
    14,972
    Thanks
    4
    Quote Originally Posted by brumby_3 View Post
    it still doesn't work. I get the same answer which is 4.92803E-09


    ?????? lol

    And same with the second half of my question - I keep getting a funny looking number with an E in it.
    That is not an error it is standard exponential notation (same as most calculators and all numerical programming languages):

    4.92803E-09 means 4.92803 \times 10^{-9}

    RonL
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. [SOLVED] Binomial Probability
    Posted in the Statistics Forum
    Replies: 2
    Last Post: March 5th 2011, 01:27 PM
  2. Replies: 0
    Last Post: December 6th 2010, 04:57 PM
  3. Binomial Probability
    Posted in the Statistics Forum
    Replies: 4
    Last Post: February 6th 2008, 03:51 PM
  4. binomial probability
    Posted in the Statistics Forum
    Replies: 7
    Last Post: October 31st 2007, 02:56 PM
  5. New to Binomial and Probability
    Posted in the Advanced Statistics Forum
    Replies: 3
    Last Post: October 24th 2007, 09:49 AM

Search Tags


/mathhelpforum @mathhelpforum