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(),

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

= 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