Results 1 to 4 of 4
Like Tree1Thanks
  • 1 Post By Debsta

Thread: find probability using Excel

  1. #1
    Newbie
    Joined
    Jul 2017
    From
    USA
    Posts
    18

    find probability using Excel

    Hello,

    Could someone kindly review solutions and let me know if it's correct? The problems have to be done using Excel functions.

    find probability using Excel-screenshot-2018-09-23-09.54.13.png Here are the final solutions.

    find probability using Excel-screenshot-2018-09-23-09.53.29.png Here is the formula used for A.

    find probability using Excel-screenshot-2018-09-23-09.53.50.pngHere is the formula used for B.

    Thank you,
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Newbie
    Joined
    Jul 2017
    From
    USA
    Posts
    18

    Re: find probability using Excel

    Just to clarify, the answer for A is zero, and the answer for B is 1.
    Follow Math Help Forum on Facebook and Google+

  3. #3
    MHF Contributor
    Joined
    Oct 2009
    From
    Brisbane
    Posts
    1,081
    Thanks
    327

    Re: find probability using Excel

    Quote Originally Posted by RBB22 View Post
    Just to clarify, the answer for A is zero, and the answer for B is 1.
    If the probability is 0, then the event is impossible.

    If the probability is 1, then the event is certain.


    Do your results seem correct to you?
    Thanks from DenisB
    Follow Math Help Forum on Facebook and Google+

  4. #4
    Senior Member
    Joined
    Jun 2014
    From
    NJ
    Posts
    287
    Thanks
    101

    Re: find probability using Excel

    You're using the NORM.DIST function incorrectly. The first argument is the value whose cumulative probability you want to determine, which should be either 9.8 (to get the probability that a sample will be undersized) or 10.2 (to get the probability that a sample will not be over-sized). From that you should be able to determine the probability that any one sample is defective. Then the next step is to determine the mean and standard deviation for the expected number of defective parts in a batch of 1000 (you should be familiar with the binomial distribution). And then finally you should be able to determine the probability that 50 or more parts would be defective out of the batch of 1000. Hope this helps.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Using Excel to find the eqaution of a curve
    Posted in the Geometry Forum
    Replies: 1
    Last Post: Jul 18th 2012, 07:45 PM
  2. Dice Probability in an Excel Spreadsheet
    Posted in the Statistics Forum
    Replies: 7
    Last Post: Jul 3rd 2012, 01:57 PM
  3. Help w/ Excel spreadsheet & probability
    Posted in the Statistics Forum
    Replies: 1
    Last Post: May 19th 2010, 10:51 PM
  4. Replies: 1
    Last Post: Apr 15th 2010, 08:40 PM
  5. Any good probability (in excel) learning resources?
    Posted in the Advanced Statistics Forum
    Replies: 0
    Last Post: Aug 7th 2009, 04:53 PM

Search Tags


/mathhelpforum @mathhelpforum