You stare raptly at a collection of stock returns and ask:
Just RIGHTclick 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 BoxMuller transformation which goes like so: If X and Y are two uniformly distributed, independent random variables lying between 0 and 1, then:Nice, eh? P.S.
Since generating the original spreadsheet displayed above ... it's changed
