View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tanim Tanim is offline
external usenet poster
 
Posts: 2
Default RANDOM # around a MEAN with STANDARD DEVIATION

I have tried it but it kept highlighting the 6 for some reason and the
formula isn't working. I can't get out of the formula box.

"joeu2004" wrote:

On Sep 11, 7:08 pm, Tanim wrote:
I have to generate 36 random numbers around the mean of 6 with
standard deviation of 10.


=norminv(rand(), 6, 10)