The VARIANCE function returns a numeric value that approximates the variance of its arguments. The type of this function is numeric.
General Format
Arguments
- Argument-1 must be class numeric.
Returned Values
- The returned value is the approximation of the variance of the argument-1 series.
- The returned value is defined as the square of the standard deviation of the argument-1 series. (See the topic
The STANDARD-DEVIATION Function.)
- If the argument-1 series consists of only one value, or if the argument-1 series consists of all variable occurrence data items and the total number of occurrences for all of them is one, the returned value is zero.
- Floating-point format is used for numeric non-integer results.