Stats

All returned values are from a referenced Stats structure, which is inserted in the spreadsheet when the ComputeStats function is created. For more information, see ComputeStats.

Function

Description

GetLatest(Stats)

Returns the most recent value used to compute the statistics.

GetMax(Stats)

Returns the largest value used to compute the statistics.

GetMean(Stats)

Returns the mean (average) of the values.

GetMin(Stats)

Returns the smallest value used to compute the statistics.

GetErrorCount(Stats)

Returns the total number of errors from the referenced value.

GetNumSamples(Stats)

Returns the total number of samples used for calculations.

GetRange(Stats)

Returns the range between the minimum and maximum values.

GetSDev(Stats)

Returns the standard deviation of the values.

GetSum(Stats)

Returns the sum of the values.

GetVariance(Stats)

Returns the variance in the values.