Brian Dunning's FileMaker Custom Functions

Standard_Deviation ( Field ; MaxLoopCount ; StartIndex ; StdDeviation ; ArithMeanValue )

Calculate the standard deviation of a set of numbers.

  Average rating: 4.1 (39 votes) Log in to vote

Kevin Woods   Kevin Woods
KWoods
http://www.RivieraCouches.co.uk

Share on Facebook Share on Twitter

  Sample input:
Standard_Deviation ( Table1::NumberField ; Get( FoundCount ) ; 1 ; 0 ; Arithmetic_Mean ( Table1::NumberField ; Get( FoundCount ) ; 1 ; 0 ) ) ;
  Sample output:
1.5

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

Calculates the standard deviation of a set of numbers, by recursively calling this function for each row in a Found Set.
Use the Arithmetic_Mean function to calculate the ArithMeanValue.

 

Comments

comment   comment, VR
Aug 28, 2010
How is this and the Arithmetic_Mean function preferable to using a summary field defined as Standard Deviation or Average - or the corresponding Stdev() and Average() aggregate functions?
 

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.