Description

Reads an existing array and returns statistics.

Syntax

ArrayStats Data, Min, Max, Average, StandardDeviation, MinLoc, MaxLoc

Parameters

Data() as Double

Array containing data.

Min As Double

Minimum value from array.

Max As Double

Maximum value from array.

Average As Double

Average value of data in array.

StandardDeviation As Double

Standard deviation of data in array.

MinLoc() As Long

Array containing indicies of the data minimum. This array is 1D with two elements: MinLoc(0) & MinLoc(1). MinLoc(0) contains the Y-index while MinLoc(1) contains the X-index.

MaxLoc() As Long

Array containing indicies of the data maximum. This array is 1D with two elements: MaxLoc(0) & MaxLoc(1). MaxLoc(0) contain the Y-index while MaxLoc(1) contains the X-index.

Remarks

Routine reads a data array and returns minimum, maximum, average, standard deviation, and indicies of the min/max. MinLoc(0) and MaxLoc(0) contain the Y-indicies while MinLoc(1) and MaxLoc(1) contain the X-indicies.

See Also