random numbers but normal distribution

[Albert]

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.

 

[Skinman]

What about =RANDBETWEEN(3,7)/10
Skinman

 

[Lars-Åke Aspelin]

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

 

[Jerry W. Lewis]

That would be Uniform, not Normal.

Jerry

What about =RANDBETWEEN(3,7)/10
Skinman

 

[Albert]

Thank you Sir!
Works great!!!

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