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