Using RANDBETWEEN with NORMINV

Question

I am trying to generate a series of random values ranging from a lower limit of 5 to an upper limit of 8, with mean of 5.5 and standard deviation of 0.67.

Using this formula:

=NORMINV(RANDBETWEEN(5,8),5.5,0.67)

I am receiving the #NUM! error. Can someone please help me?

score 0 · Accepted Answer · answered Mar 26 '15 at 02:29

0

You might try:

=IF(OR(NORMINV(RAND(),5.5,0.67)<5,NORMINV(RAND(),5.5,0.67)>8),"",NORMINV(RAND(),5.5,0.67))

answered Mar 26 '15 at 02:29

pnuts

58,317
11
87
139

1

Thanks! Will tweak my way around there! – mkv Mar 27 '15 at 02:52

Using RANDBETWEEN with NORMINV

1 Answers1