Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Normal distrobution? how is it done

  1. Jul 31, 2004 #1
    normal distrobution???? how is it done!!!

    Problem:
    suppose that the heights of men are normally ditributed with a mean of 174 cm and a standard deviation of 10cm and the heights of women are normally distrobuted with a mean of 165cm and a standard deviation of 3 cm. If a man and woman are selected independently at random, find the probability that the woman is taller than the man.

    1.use a random normal generator to simulate the situation.
    2.explain your simulation method clearly so that someone else can follow it.
    3.Carry out at least 50 trials on spreadsheet 1.(hint: the decision command =IF(B2>A2,"Yes","No") may be useful).
    4.use your trials to answer the question.

    anyone know how to do this on Ms excel because i have never done it b4?and what is meant by "use a random normal generator to simulate the situation".
    does anyone know some important points that should be listed in the tool and the trial?.
    and what are those commands, like the one in question 3 are there more of them that I should know?.

    could someone please help me?
     
  2. jcsd
  3. Jul 31, 2004 #2

    HallsofIvy

    User Avatar
    Staff Emeritus
    Science Advisor

    A "random normal generator" is an algorithm that gives a list of random numbers according to the standard normal distribution rather than the uniform distribution (which is what most random number generators give). I don't know if there is such a thing in Excel. Here is a link to a page that gives an algorithm:
    http://www.cast.uark.edu/~kkvamme/ACN37.htm
    (From the "Archeological Computing newsletter"!)
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Have something to add?