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

Just to add. Under "Data Analysis", you can select "Random Number
Generation."
You can pick a "Normal" distribution, along with Number of points, Mean, SD,
and Random Seed.

--
Dana DeLouis
Windows XP & Excel 2007


"Tanim" wrote in message
...
In Excel 2007, how can I create random numbers around a mean of 7 or some
other specific number?

I have to generate 36 random numbers around the mean of 6 with standard
deviation of 10.

Also how can I change the seed in 2007?

Your help is greatly appreciated.