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

JustGiving - Sponsor me now!

 

sbGenNormDist

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:

sbGenNormDist_01_Screen
sbGenNormDist_01_Code

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.

Sulprobil   Get it done   Contact   Disclaimer   Impressum   Download