mercredi 25 mars 2015

Using RANDBETWEEN with NORMINV

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