Thread: RANDOM # around a MEAN with STANDARD DEVIATION
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
  
Posts: 2,059
Default RANDOM # around a MEAN with STANDARD DEVIATION
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)


Reply With QuoteReply With Quote