Creating a random skewed distribution

[RSjohnson82]

Good evening,

I am creating a monte-carlo simulation using NORM.INV distribution based on a mean and standard deviation.

However, the distribution of the data that these numbers are based on is skewed; which doesn't get reflected, as only using mean/sd produces a symmetrical distribution.

Is there a way I can add the =skew of the distribution into the randomly generated number?

Any help appreciated, thanks.

 

[sijpie]

Does this help? Monte Carlo Simulation with skewed distribution

I have used a C function in the past (which I got on the web from some australian Uni) to generate skewed distribution. I converted it to VBA. But it is hidden soemwhere in the dungeons.

 

[Sulprobil]

You can approximate your desired distribution with a triangular distribution (with a known skew) or with a step-wise linear distribution, for example.