<-- Previous || Up || Next -->

Median Deviation Function
Math Statistics Class

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

Average deviation of numeric values from the median value.

    MedianDeviation(12, 34, 56) = 14.6666666666667
    MedianDeviation(12, 34, 56, 78) = 22
    MedianDeviation(SampleData) = 18.9130434782609
See also:
    Median Function
    AverageDeviation Function
    StatVarType Property
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 average deviation of numeric values from the median value. The median is the element in the middle of the sorted list of elements, or the average (mean) of the two middle elements if there is an even number of elements. Function returns Null if none of the arguments are numeric.

Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.