Brian Dunning's FileMaker Custom Functions

RandNormal ( mean ; stdDev )

Generates a random number drawn from a normal (Gaussian) distribution with a given mean and standard deviation.

  Average rating: 4.2 (40 votes) Log in to vote

Michael Horak   Michael Horak
*COMMENT Visual Realisation
http://comment.cjb.net

Share on Facebook Share on Twitter

  Sample input:
RandNormal ( 0 ; 1 )

RandNormal ( 0 ; 1 )

RandNormal ( 0 ; 1 )
  Sample output:
-3.34772392391134908307

.0001790309728755547

3.326775098525

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Generates a random number drawn from a normal (Gaussian) distribution with a given mean and standard deviation, using the Box-Muller algorithm. A new random number is generated every time the formula is evaluated.

To draw a number from the "standard" normal distribution, use the values of 0 for mean and 1 for stdDev.

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.