Statistical Functions
Statistical calculation functions in Essbase calculate advanced statistical values, such as correlation, standard deviation, median, mode, rank, or variance. These functions are often used in sales and marketing applications.
Table 3-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 |