{{getMsg('Help_YouAreHere')}}:
/
{{page.title}}
{{page.title}}
{{$root.getMsg("downLoadHelpAsPdf")}}
{{helpModel.downloadHelpPdfDataStatus}}
StdDev
Returns the standard deviation of the field values or array elements, which is calculated by taking the square root of the variance of the field values or array elements.
Usage:
StdDev( fld ) StdDev( fld, condFld ) StdDev( fld, condFld, cond ) StdDev( array )
Parameters:
| fld | The name of a field whose values should be used to calculate the standard deviation. |
|---|---|
| condFld | The name of the field that groups the values of fld (if fld isn't an array). |
| cond | A string declaring the type of grouping to be used on condFld. This only makes sense for groups based on Date, DateTime, Time, and Boolean fields. See Summary Field Conditions for a list of strings you can use here. |
| array | The name of an array variable whose values should be used to calculate the standard deviation. |
Returns:
Numeric Value
Examples:
StdDev({data.Temperatur}, {data.Region})
//returns the value of variance for a field Temperature grouped by Region.
// connection of values, average and variance local numbervar array dataset1 := [3,3,3,3,3]; local numbervar array dataset2 := [1,2,3,4,5];
average(dataset1); // is 3 average(dataset2); // is 3 as well!
StdDev(dataset1); // is 0 because all values match the average StdDev(dataset2); // is 1.58 because the values are scattered
Notes:
-
If the values in fld should be grouped, a group based on condFld is needed. If the group does not exist in the report, you can add it using i-net Designer or using API method: Engine.addGroup.
© Copyright 1996 - 2024, i-net software GmbH; All rights Reserved. Imprint
