AVEDEV

Calculates the average of the absolute value of deviations from the mean for a given set of data.

AVEDEVG

Calculates the average of the absolute value of deviations from the mean for a given set of data, grouped by periods.

DEVSQ

Calculates the sum of the squared deviations from the mean for a given set of data.

DEVSQG

Calculates the sum of the squared deviations from the mean for a given set of data, grouped by periods.

STDEV

Calculates the standard deviation for a given set of data.

STDEVG

Calculate the standard deviation for a given set of data, grouped by periods.

STDEVP

Calculates the standard deviation for a given set of data representing an entire population.

STDEVPG

Calculates the standard deviation for a given set of data representing an entire population, grouped by periods.

GEOMEAN

Calculates the geometric mean for a set of numeric values.

GEOMEANG

Calculates the geometric mean for a set of numeric values, grouped by periods.

HARMEAN

Calculates the harmonic mean for a set of numeric values.

HARMEANG

Calculates the harmonic mean for a set of numeric values, grouped by periods.

TRIMMEAN

Calculates the mean (average) while excluding outliers.

TRIMMEANG

Calculates the mean (average) while excluding outliers, grouped by periods.

MEDIAN

Calculates the median (middle number) in a group of supplied numbers.

MEDIANG

Calculates the median (middle number) in a group of supplied numbers, grouped by periods.

MODE

Returns the most frequently occurring number in a numeric data set.

CORREL

Calculates the correlation coefficient between 2 numeric data sets.

CORRELG

Calculates the correlation coefficient between 2 numeric data sets, grouped by period

COVAR

Calculates the covariance, the average of the products of deviations for two data sets.

COVARG

Calculates the covariance, the average of the products of deviations for two data sets, grouped by periods.
