Statistical Functions
Statistical functions allow you to calculate advanced statistics in Essbase.
Table 17-14 List of Statistical Functions
| Function | Calculated Value |
|---|---|
|
The correlation coefficient between two parallel data sets |
|
|
The number of values in the specified data set |
|
|
The median, or middle number, in the specified data set |
|
|
The mode, or the most frequently occurring value, in the specified data set |
|
|
The rank of the specified member or value in the specified data set |
|
|
The standard deviation, based upon a sample, of the specified members |
|
|
The standard deviation, based upon the entire population, of the specified members |
|
|
The standard deviation, crossed with a range of members, of the specified members |
|
|
The variance, based upon a sample, of the specified data set |
|
|
The variance, based upon the entire population, of the specified data set |