AverageDeviation Property

AverageDeviation returns the average deviation of the data values in the column from which the statistics were calculated. Returns a variant. This is a read-only property.

Syntax

object. AverageDeviation(Col)

Parameter	Type	Description
Col	Long	optional, default=1

Example

This example demonstrates how to return the standard deviation of data values in column C.

Debug .Print "Average Deviation "; Stats.AverageDeviation(3)

Used by: WksStatistics object