Hi all,
I'm happy if someone can help on this. I wish to generate value a < x < b from some distribution eg. normal distribution where a = -50, b= 50.
Below code is for uniform distribution
Randomize
value = Rnd() * (b - a) + a
Range("b5").Offset(i - 1, 0).value = value
And I need different truncated distribution where I had solved inverse cdf manually eg. exponential distribution = 1/alpha*LN(1-RND()).