# ComputeStats

Calculates statistics for a referenced value.

Inputs

Parameter | Description
Event | Specifies the event on which to increment the counter. This parameter needs to be a reference 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.