# ComputeStats

Calculates statistics for a referenced value.

Inputs

The ComputeStats function Functions are tools that are available in Spreadsheet for processing and analyzing acquisitions or other results. You can add functions to your Spreadsheet job to create tool chains and produce results for specific applications. has the following syntax:

ComputeStats(Event, Value, Reset)

See the table for a description of the available parameters.

Parameter | Description
Event | Specifies the event on which to increment the counter. This parameter needs to refer to any event with a timestamp, for example, one of the following: A cell containing an Event function. A cell containing a Button function.
Value | Specifies a required reference to the cell containing the source of the data to be computed. If no cell is referenced, the function returns a #ERR for all results.
Reset | Forces the computations to reset at the next event trigger.
0 = OFF (default) | Do not reset computations
1 = ON | Reset computations

Outputs

Returns | A Statistics Vision Data Access functions data structure containing the computed statistics is automatically inserted into the spreadsheet as a results table. The results table shows #ERR if any of the input parameters are invalid.
Label | Function | Description
Latest | GetLatest(Stats) | The most recent value.
Min | GetMin(Stats) | The smallest value used to compute the statistics.
Max | GetMax(Stats) | The largest value used to compute the statistics.
Mean | GetMean(Stats) | The mean (average) of the values.
Sum | GetSum(Stats) | The sum of the values.
StdDev (Standard Deviation) | GetSDev(Stats) | The standard deviation of the values.
Range | GetRange(Stats) | The range between the minimum and maximum values.
NumError | GetErrorCount(Stats) | The total number of errors from the referenced value.
NumSamples | GetNumSamples(Stats) | The total number of samples used for calculations.