Viewing By Month : April 2007 / Main
April 1, 2007
An easier way to generate Gaussian random numbers in Excel.
One of the more widely viewed QAs on our web site is a macro that lets you generate Gaussian random numbers in Excel. It just occurred to me that this can be done in a simple Excel formula (that combines the RAND function with the inverse of the Normal distribution function), bypassing the need to create the lengthy macro. Details.