View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Skinman Skinman is offline
external usenet poster
 
Posts: 54
Default random numbers but normal distribution

What about =RANDBETWEEN(3,7)/10
Skinman
"Albert" wrote in message
...
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.