« Controls : PushButton | Main | Freezing row & column headers »

September 22, 2004

Random numbers: Normal Distribution I

The RAND function returns a random number with even distribution between 0 and 1. Here are examples of how to use this function...
  • For a random number of even distribution between 0 and 100 =RAND()*100
  • For a random number of even distribution between -10 and 10 =(RAND()*20)-10
However, if we want nornally distributed random numbers, we need to implement a formula or a macro. Examples of both are presented here.

normal.jpg

Posted by Dave at September 22, 2004 05:11 AM

Comments

Very neatly presented. The only helpful Excel illustration on the first page of my Google search, and just what I wanted.
Keith

Posted by: Anonymous at March 15, 2005 04:05 PM

Post a comment




Remember Me?