How to generate a random number for a normal distribution between a max and min

Hello,

I would appreciate any help that you could give me for the following :

I would like to generate a random number within a normal distribution but only within a set MAX and MIN value.

I know the formula for a random number in a normal distribution is NORMINV (RAND(),mean,S.D.) but how can I tell Excel that I only want the value between a set MIN & MAX? I have the same question for a Weibull distribution, however I assume the solution will the similar.

Thank you for any input.

Mark

Sweep,

Thanks for the reply. I was not aware of a RANDBETWEEN() function. Is this available on all Excel versions? I do not seem to have it.

Thanks again.

Sweep,

That worked great for the normal distribution. But I am not sure how to apply the RandBetween to the Weibull.

The formula that I have for the Weibull is c*(-LN(1-RAND())^(1/m)

where c is the scale and m is the shape. Since my between range is 0.75 to 1.5, the formula returns an error (LN of a negative number).

Would you know how to resolve this?

Thank you.

I just checked the distribution of the RANDBETWEEN, and it does not seem to be giving me a normal distribution. When I try with just a RAND(), the distribution is normal but then it is not cut off at my desired limits.

Formula : =NORMINV(RANDBETWEEN(15,85)/100,4.2,0.38)




Chart.jpg