Although Excel has a variety of commands for generating Normally distributed random variables, the Box-Muller technique is useful in the absence of Excel paraphernalia. Box-Muller Transformation goes like so:
Let X and Y be two uniformly distributed, independent random
variables lying between 0 and 1 and define:
Then
Hence
|