Gerald -

for a little simulation i need to draw random numbers from a normal
distribution with a given mean (0.025) and std dev (0.3373). Having read
some earlier posts i tried =norminv(rand(), mean, std dev). Apparently,
this is not the right formula: it returns regularly values in the 50%s
which should not happen from my 2.5% mean. <

P(X=.50) = 1 - NORMDIST(.50,.025,.3373,1) = .08 approximately

That is, approximately 8% of the random values should be greater than 50%.
(It should happen.)

Both NORMINV and RAND are much improved in Excel 2003 (and NORMINV is much
slower due to its increased numerical accuracy), so
NORMINV(RAND(),mean,stdev) may be satisfactory for your needs.

For more information, see "Description of the effects of the improved
statistical functions for the Analysis ToolPak in Excel 2003 and in Excel
2004 for Mac," at
http://support.microsoft.com/default...b;en-us;829208
specifically, the "Random Number Generation" section

and "Description of the RAND function in Excel 2003" at
http://support.microsoft.com/kb/828795/

and "Excel Statistical Functions: NORMINV" at
http://support.microsoft.com/default...b;en-us;827358

- Mike
www.mikemiddleton.com

"gatosonreyendo" wrote in message
...
for a little simulation i need to draw random numbers from a normal
distribution with a given mean (0.025) and std dev (0.3373).

Having read some earlier posts i tried =norminv(rand(), mean, std dev).
Apparently, this is not the right formula: it returns regularly values in
the
50%s which should not happen from my 2.5% mean. I also found the
box-muller
method. How could i transform the random draws from the standard normal
distribution into the ones i need?

Is there another formula i could use?

Thanks a lot in advance
Gerald.