Using Excel to simulate standard random normal variable について・・・
We commonly model asset returns under the idea they are normally distributed. In this tutorial, I explain how we can do this with the following Excel function: = NORMSINV((RAND()). The 'S' indicates a standard normal distribution; by definition, 'standard' refers to a distribution with zero mean and one (1.0) standard deviation. Alternatively, we can use =NORMINV(RAND(),0,1) to achieve the same effect. Then I use this random variable for a very simple Monte Carlo Sim: to simulate a stock price
|
