Randi R -

How do I generate random numbers from a normal distribution in excel? I
want to generate a set of random numbers with a normal distribution of
(mean=162.7, standard deviation=6.2) <

For a dynamic worksheet function approach, in general use

=NORMINV(RAND(),Mean,StDev)

and for your specific case

=NORMINV(RAND(),162.7,6.2)

Both NORMINV and RAND are numerically improved in Excel 2003 (and NORMINV is
considerably slower).

For more info, browse to Google Groups and search for "Excel random normal"
(without the quotes).

- Mike
www.mikemiddleton.com