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 |