Function Math Statistics Class

DeviationsSquared

Square of deviations of numeric values from the mean.

Signature (Visual Basic / VBA)

Public Function DeviationsSquared( _
    ParamArray vValues() As Variant _
    ) As Variant

Code Example

    DeviationsSquared(12, 34, 56) = 968
    DeviationsSquared(SampleData) = 51283.8695652174

Parameters

Parameter Description
vValues The values that are to be processed. Can be numbers, one-dimensional numeric arrays, one-dimensional Variant arrays, one-dimensional Variant arrays with embedded arrays, or any combination of these. The current setting of the StatVarType Property determines which numeric data types are recognized by this function.

Return Value

Function returns the square of deviations of the numeric values. Function returns Null if none of the arguments are numeric.