Monte Carlo Simulation

Excel Help for Monte Carlo Simulation in Excel Portfolio Optimization Template

Monte Carlo Simulation

Rate this: (3/5 from 1 vote)

	For each uncertain variable (one that has a range of possible values), you define the possible values with a probability distribution. The type of distribution you select is based on the conditions surrounding that variable. Distribution types include: Normal, Triangular, Uniform or Lognomal When you run the monte carlo simulation, which randomly generates values for uncertain variables over and over to simulate a model, WHAT DISTRIBUTION YOU USE AND WHY?  What would happen if other distribution type is used? Thank You
	Posted by pacmancarle on 25 Apr 2007

Replies - Displaying 1 to 1 of 1

Order Replies By: Most recent | Chronological | Highest Rated

	Normal distribution Rate this: (4/5 from 2 votes) The distribution used is the normal distribution because it is assumed under the portfolio optimization that the standard deviation of returns is normally distributed around the average return. i.e. it is the same below and above the average.
	Excel Business Forums Administrator
	Posted by Excel Helper on 25 Apr 2007

Displaying page 1 of 1