Brian Dunning's FileMaker Custom Functions

RandomNormal ( mean ; standardDeviation )

Returns random values from a Normal distribution

  Average rating: 4.6 (26 votes) Log in to vote

Jeremy Bante   Jeremy Bante

https://github.com/jbante/

Share on Facebook Share on Twitter

  Sample input:
List (
RandomNormal ( 10 ; 5 );
RandomNormal ( 10 ; 5 );
RandomNormal ( 10 ; 5 );
RandomNormal ( 10 ; 5 );
RandomNormal ( 10 ; 5 );
RandomNormal ( 10 ; 5 );
RandomNormal ( 10 ; 5 );
RandomNormal ( 10 ; 5 );
RandomNormal ( 10 ; 5 );
RandomNormal ( 10 ; 5 )
)
  Sample output:
12.8121477353090264763
6.80013376037962405065
-.9270458939025267044
15.97839559769003699405
13.3547458035417962665
14.232829181391028885
11.8846139666424785869
15.3922026635464704116
13.93060055013993875615
8.98694383476083344855

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

When called repeatedly, RandomNormal returns values consistent with a normally distributed random variable with mean and standard deviation given by the parameters.

This function is dependent on the RandomStandardNormal function.

 

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.