You stare raptly at a collection of stock returns and ask:
Just RIGHT-click on the picture and Save Target to download a .ZIP'd file.
There's an explanation sheet which looks something like THIS
P.S. The spreadsheet may change from time to time ... without notice
On the "Explain" sheet is the formula:
=Mean+Volatility*SQRT(-2 * LN(RAND()))*COS(2*PI() *RAND())
for generating Normally distributed random numbers.
That's the Box-Muller transformation which goes like so:
If X and Y are two uniformly distributed, independent random variables lying between 0 and 1, then:Nice, eh?
Since generating the original spreadsheet displayed above ... it's changed