Map and Table Calculation
STD( ) or STDEV function
Returns the standard deviation of a value column.
Syntax
STD(ValueColumn)
STDEV(ValueColumn)
Input
| ValueColumn |
is a value column |
| Domain type: |
any Value domain |
Output
Notes:
- The STD and STDEV function are aliases of each other.
- The standard deviation is calculated according to the following formula:
- The STD and STDEV
function can only be used on the command line of a table window; they cannot be used on the command line of the Main window.
- The STD and STDEV
function can also be performed through a dialog box, see Column
Statistics.
- When the input value is undefined, the record will be excluded from the calculation.
Tips:
- To calculate weighted standard deviations or standard deviations per class, see the AGGSTD function.
- The smaller the standard deviation, the less the values vary from the average.
- When the definition symbol = is used, a dependent output column is created; when the assignment symbol := is used, the dependency link is immediately broken after the output column has been calculated.
Usable in
TabCalc, TabCalc pocket line calculator
Examples
TabCalc example:
OutCol = STD(InCol)
OutCol = STDEV(InCol)
InCol |
OutCol |
-5 |
5.855 |
-2 |
5.855 |
-1 |
5.855 |
0 |
5.855 |
? |
5.855 |
4 |
5.855 |
8 |
5.855 |
9 |
5.855 |
11 |
5.855 |
TabCalc pocket line calculator example:
? STD(InCol) |
returns 5.855 |
? STDEV(InCol) |
returns 5.855 |
See also: