Hi All,

I'm attempting to build a Monte Carlo simulation that simulates the potential prices for airline tickets. The model I've designed uses the Norm.Inv function where the mean is the average ticket price, the standard deviation is just an assumption of the spread, and the probability is RAND(). So =Norm.inv(Rand(),100,10) for example. This gives me a nice bell curve once repeated 1000 times or so.

The problem is, airline prices are note equally distributed and tend to be positively skewed, i.e. there is higher probabilities that a lower price ticket will be sold rather than a higher one. How do I skew the distribution to reflect this? Am I using the correct distribution?

What I would love is for the skew to be a variable input (one number) that I can change to see how the model is reacting to it.

Thoughts? Comments?

Thanks,