Results 1 to 3 of 3

Math Help - Norm Dist (excel)

  1. #1
    Newbie
    Joined
    Sep 2008
    Posts
    3

    Norm Dist (excel)

    Let X ~Normal(200, 60). Use Excel (Use the functions NORMDIST or NORMSINV, and fill in the dialogue box appropriately) to find the following.

    k such that P(X>k)=0.01?

    This is the only one giving me problems I use the normdist formula in excel and i enter the mean std deviation and the value (True/False) but I don't see how I can solve for a specific value, unless i just keep doing trial and error and i know this is not the right way to go about it.

    thanks for any help.
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor
    Joined
    Aug 2007
    From
    USA
    Posts
    3,111
    Thanks
    2
    You must simply ponder the defintions of the functions until it soaks in.

    p(X>k) = 0.01 is the same as p(X<=k) = 0.99

    =NORMSINV(0.99) gives 2.326348
    Note: =NORMSINV(0.01) = -2.326348 and symmetry can be used to achieve the same result.

    I'll let you fill in the last blank.

    =NORMDIST(WhatGoesHere,200,60,1)

    Figure out what the last "1" is, too.
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Newbie
    Joined
    Sep 2008
    Posts
    3
    I can't work out what goes there, but i get that the one is the same as writing true.

    But I am lost.

    I have another question and I think that I am supposed to use the same idea,

    A machine fills bottles of soft drink to a mean volume of 510 ml with a standard deviation of 10 ml. Assume the the volumes of the bottles are normally distributed. The label on the bottle specifies a volume of 500ml.

    What percentage of bottles is under-filled?

    I have found this to be 0.158655

    In order to reduce the percentage of under-filled bottles to 1%, the company decides to adjust the standard deviation of the volumes filled by the machine. What should the new standard deviation be?

    Am I right in thinking that I am supposed to use the same process as in the first question?
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Field norm and ideal norm
    Posted in the Number Theory Forum
    Replies: 2
    Last Post: July 22nd 2010, 08:47 PM
  2. Replies: 3
    Last Post: July 13th 2010, 06:37 PM
  3. Transform of norm dist. into Z question
    Posted in the Statistics Forum
    Replies: 3
    Last Post: April 27th 2010, 10:53 PM
  4. Replies: 2
    Last Post: November 7th 2009, 12:13 PM
  5. Euclidean Norm and Maximum Norm
    Posted in the Differential Geometry Forum
    Replies: 1
    Last Post: October 7th 2009, 04:26 AM

Search Tags


/mathhelpforum @mathhelpforum