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