|
||
|
Viewing By Month : April 2007 / Main
April 1, 2007An 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.
|
||