VBA module/function to generate random numbers with specified mean and SD
BTW - the generated numbers have to be = 0 (positive numbers)
"Robert Reid" wrote in message
...
Hi all,
As basis for a school assignment I need to generate 20 random numbers that
have a prespecified mean and standard deviation ( I don't believe they
have to be normally distrubted).
Can anyone help?
The output would preferably be to Worksheets("Sheet1").Range("A1:A20")
though an array would also work.
Thanks.
|