Thank you Sir!
Works great!!!

"Lars-Åke Aspelin" wrote:

On Mon, 4 Aug 2008 21:15:01 -0700, Albert
wrote:

Hello!
I'm trying to get a list of 10,000 numbers with average 0.5 and a starndard
deviation 0.2.
Does someone know how to do this? Any ideas?
I'd like a function to create "random" numbers but with function parameters
"Average" and "StDev".
I thank you in advance...
Albert C.


Try this formula in any cell

=NORMINV(RAND(),0.5,0.2)

Copy the formula down, or in any other preferred direction, to get
your 10000 numbers.

Hope this helps / Lars-Åke