LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
gatosonreyendo
 
Posts: n/a
Default draw random from normal distribution

for a little simulation i need to draw random numbers from a normal
distribution with a given mean (0.025) and std dev (0.3373).

Having read some earlier posts i tried =norminv(rand(), mean, std dev).
Apparently, this is not the right formula: it returns regularly values in the
50%s which should not happen from my 2.5% mean. I also found the box-muller
method. How could i transform the random draws from the standard normal
distribution into the ones i need?

Is there another formula i could use?

Thanks a lot in advance
Gerald.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
Make Histogram and Normal distribution. Ed (from UK and useless with comuters!) Charts and Charting in Excel 2 November 19th 05 06:03 PM
normal distribution curve Chris Treanor Charts and Charting in Excel 1 September 29th 05 03:33 AM
how do i draw a distribution chart in excel travish19 Charts and Charting in Excel 3 January 15th 05 01:18 AM
bell-shape normal distribution curve SM Charts and Charting in Excel 6 December 11th 04 08:29 PM


All times are GMT +1. The time now is 12:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"