Public Function AverageDeviation( _
ParamArray vValues() As Variant _
) As Variant AverageDeviation(12, 34, 56) = 14.6666666666667
AverageDeviation(SampleData) = 18.9163516068053See also: MedianDeviation Function
Average Function
StandardDeviation Function
StandardDeviationPopulation Function
Variance Function
VariancePopulation Function
DeviationsSquared Function
StatVarType Property
AVEDEV Function (Microsoft Excel)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. Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.