PDA

View Full Version : How do I draw random numbers from a Weibull distribution with known parameters?



T.W.Rikken
06-14-2019, 05:01 AM
Hello!

I want to draw random numbers from a Weibull distribution using VBA. I have multiple Weibull distribution with known shape and scale parameter which I want to draw random numbers from. For a normal distribution I used: Worksheetfunction.Round(Worksheetfunction.Norm_Inv(Rnd(), meand,standard deviation,0)
Now I would like something which generates random numbers from a Weibull function with known shape and scale parameter. Only I could not figur out how to do it.

Hope you can help me!
Thanks in advance!

Thom

Paul_Hossler
06-14-2019, 11:56 AM
https://www.vertex42.com/ExcelArticles/mc/GeneratingRandomInputs.html