Statistical Functions

Statistical functions allow you to calculate advanced statistics in Essbase.

Table 18-14 List of Statistical Functions

Function	Calculated Value
@CORRELATION	The correlation coefficient between two parallel data sets
@COUNT	The number of values in the specified data set
@MEDIAN	The median, or middle number, in the specified data set
@MODE	The mode, or the most frequently occurring value, in the specified data set
@RANK	The rank of the specified member or value in the specified data set
@STDEV	The standard deviation, based upon a sample, of the specified members
@STDEVP	The standard deviation, based upon the entire population, of the specified members
@STDEVRANGE	The standard deviation, crossed with a range of members, of the specified members
@VARIANCE	The variance, based upon a sample, of the specified data set
@VARIANCEP	The variance, based upon the entire population, of the specified data set