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?
Aucun commentaire:
Enregistrer un commentaire