Brian Dunning's FileMaker Custom Functions

RandomStandardNormal

Returns random values from the Standard Normal distribution

  Average rating: 4.9 (28 votes) Log in to vote

Jeremy Bante   Jeremy Bante

https://github.com/jbante/

Share on Facebook Share on Twitter

  Sample input:
List (
RandomStandardNormal;
RandomStandardNormal;
RandomStandardNormal;
RandomStandardNormal;
RandomStandardNormal;
RandomStandardNormal;
RandomStandardNormal;
RandomStandardNormal;
RandomStandardNormal;
RandomStandardNormal
)
  Sample output:
1.41073264267008954613
-1.06287261458087525206
1.18226332551437196569
1.17248409573849158254
.44625235292511570306
-.83852348552055913166
.58817557434873573743
.68408067748026104281
1.09879428082311429906
-.34097400226953125095

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

When called repeatedly, RandomStandardNormal creates values consistent with a normally distributed random variable with mean of 0 and standard deviation of 1.

 

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.