Statistical Functions |
Table: Statistical Functions lists the OLAP DML functions for statistical calculation.
Statistical Functions
| Statement | Description |
|---|---|
| CATEGORIZE
|
Groups the values of a numeric expression into categories. |
| CORRELATION
|
Returns the correlation coefficients for the pairs of data values in two expressions. |
| NORMAL
|
Returns a random value from a normal distribution with a specified mean and standard deviation. The result returned by NORMAL is dimensioned by all the dimensions of the mean and standard deviation expressions. |
| RANDOM
|
Produces a number that is randomly distributed between specified low and high boundaries. |
| STDDEV
|
Calculates the standard deviation of the values of an expression. |