# 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 KWoods http://www.RivieraCouches.co.uk |

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, 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? | ||

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