View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Reid Robert Reid is offline
external usenet poster
 
Posts: 6
Default VBA module/function to generate random numbers with specified mean and SD

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.