Statistical Functions

Statistical functions calculate advanced statistical values, such as correlation or variance. These functions are often used in sales and marketing applications.

Table 2-14 Statistical Functions

Function	Return Value
@CORRELATION	The correlation coefficient between two parallel data sets
@COUNT	The number of data values in the specified data set
@MEDIAN	The median (middle value) of the specified data set
@MODE	The mode (the most frequently occurring value) in the specified data set
@RANK	The rank (position in the sorted data set) of the specified members or the specified value among the values in the specified data set.
@STDEV	The standard deviation of the specified data set
@STDEVP	The standard deviation of the specified data set, calculated over the entire population
@STDEVRANGE	The standard deviation of all values of the specified member across the specified data set. The specified mbrName is crossed with a range list to obtain the sample across which the standard deviation is calculated.
@VARIANCE	The statistical variance of the specified data set (expList), based upon a sample of a population
@VARIANCEP	The statistical variance of the specified data set (expList), based upon the entire population