Stdev() returns the standard deviation of the values given by the expression over a number of records as defined by a group by clause.
Return data type: numeric
|expr||The expression or field containing the data to be measured.|
|distinct||If the word distinct occurs before the expression, all duplicates will be disregarded.|
Examples and results:
Add the example script to your app and run it. Then build a straight table with Type and MyStdev as dimensions.
crosstable LOAD recno() as ID, * inline [
25|2 ] (delimiter is '|');
Stdev(Value) as MyStdev
Resident Table1 Group By Type;
The results of the Stdev() calculation are: