Table 1: Supported statistical functions
| Statistical function | Description |
|---|---|
| Average | The measure of central tendancy of a set of values computed by dividing the sum of the values by their number; commonly called the arithmetic mean. |
| Correlation Coefficient | The quantity that gives the quality of a least squares fitting to the original data. Also known as cross-correlation coefficient. |
| Count | The result of a tally that reveals the number of items in a set. |
| Covariance | The measure of the strength of the correlation between two sets of random variates. |
| Geometric Mean | The geometric mean of a set of positive data is defined as the product of all the members of the set, raised to a power equal to the reciprocal of the number of members. The geometric mean can only be calculated on elements whose values are greater than zero. |
| Harmonic Mean | The number of elements to be averaged divided by the sum of the reciprocals of the elements. The harmonic mean can only be calculated on elements whose values are greater than zero. |
| Maximum | The highest value among a set of items. |
| Median | The middle number in a set of ordered data. If the set contains an even number of items, the arithmetic mean of the 2 middle values will be returned. |
| Minimum | The lowest value among a set of items. |
| Mode | The value that has the largest number of observations, namely the most frequent value or values. The mode is not necessarily unique, unlike the arithmetic mean. |
| Root Mean Square | The square root of the arithmetical average of a set of squared instantaneous values. The root mean square is also known as the quadratic mean. |
| Standard Deviation | A measure of the degree of dispersion of sample or population data from the mean value. |
| Sum | The result of the addition of the values of a set of items. |
| Variance | The variance of a random sample or population variable is a non-negative number which gives an idea of how widely spread the values of the random variable are likely to be; the larger the variance, the more scattered the observations on average. |
With the exception of the CountFunction, null (Nothing in Visual Basic) and DBNull values will be ignored.