Skewed Random Number Generator

[alshutch]

I am trying to generate 15000 random numbers that have similar charities to the same number of historical data points. The data is approximately from the t distribution, with the only exception being that it has skewness of -.21.

Does anybody have any vba code that will accomplish these results? Perhaps a custom function?

 

[shg]

Do you have any experience using this function?

None at all.

I created 15000 datapoints using RANDSTDIST(21,-.21) and the skewness of the data was -.05.

I wouldn't expect it to be exactly -0.21, but don't know how to calculate the probability of it being that far off. What happens if you calculate another set? And another?

More importantly do you know of any way to get this function into excel?

Gnumeric is open source. If you post the source code for the function, someone may be able to port it to VBA.