Std deviation
Std deviation ( series ) : Real
Parameter | Type | Description | |
---|---|---|---|
series | Field, Array | → | Data for which to return the standard deviation |
Function result | Real | ← | Standard deviation of series |
Description
Std deviation returns the standard deviation of series. If series is an indexed field, the index is used to find the standard deviation.
You can pass an array (one or two dimensions) in series. In this case, the array must be of the Integer, Longint or Real type.
Example 1
The following example is an object method for the variable vDeviate. The object method assigns the standard deviation for a data series to vDeviate:
vDeviate:=Std deviation([Table1]DataSeries)
The following method is called to print the records in the selection and to activate break processing:
ALL RECORDS([Table1])
ORDER BY([Table1];[Table1]DataSeries;>)
BREAK LEVEL(1)
ACCUMULATE([Table1]DataSeries)
OUTPUT FORM([Table1];"PrintForm")
PRINT SELECTION([Table1])
Note: The parameter to the BREAK LEVEL command should be equal to the number of breaks in your report. For more information about break processing, refer to the printing commands.
Example 2
This example gets the standard deviation of a series of values placed in an array:
ARRAY REAL($ArrGrades;0)
QUERY([Exams];[Exams]Exam_Date=!01/07/11!)
SELECTION TO ARRAY([Exams]Exam_Grade;$ArrGrades)
vStdDev:=Std deviation($ArrGrades)
See also
Average
Sum
Sum squares
Variance
Properties
Command number | 26 |
Thread safe | ✓ |