essbase Statistical Functions

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

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