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.
