I am a supporter of St. Joseph's hospice. If you find this site useful or if it helped you, consider a small donation to St. Joseph's, please.

Information on
St. Joseph's

To generate a standard normal distribution you can use =NORMSINV(RAND()).

If you need a normal distribution with a mean of 7 and a standard deviation of 10 then use =NORMINV(RAND(),7,10).

But: Your normal distribution will not show a mean of exactly 7 (and a standard deviation of exactly 10) unless the number of draws approaches infinity. If you want to ensure a mean of 7 and a standard deviation of 10 then shift an originally generated series of random numbers to this mean and zoom it to the required standard deviation:

If you are interested in downloading a 25 KB Excel 2010 © sample file which contains the code shown here, go to my Download page, please.

If you need to generate a huge amount of random numbers with (on average!) a given standard deviation: