Main Profile

At A Glance

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
Length: 08:56

Contact

Questions about Using Excel to simulate standard random normal variable

Want more info about Using Excel to simulate standard random normal variable? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question