Tuesday, November 12, 2013

Generate normal random number in Excel

Using Rand() function gives you a random number between 0 and 1. If you are to generate a random number which follows the normal distribution probability curve, then you can use the following code:-

= NormInv(Rand(), Mean, Stdev)

In place of Mean and Stdev, enter mean of the distribution and standard deviation of the distribution

No comments :

Post a Comment