Statistical Functions

Exponentiation. This function returns the exponential expression, x raised to the y power.

Syntax: exp(x,y)

Example: exp(2,6)

In this example, the calculation returns 64 (2⁶).

Natural logarithm A number's exponent to the base of the mathematical constant e, where e is approximately equal to 2.7.. This function returns the natural logarithm of the specified number.

Syntax: ln(x)

Examples: ln(64) returns 4.16

ln(1000) returns 6.90

Logarithm₁₀. This function returns the base 10 exponent of the specified number.

Syntax: log10(x)

Examples: log10(64) returns 1.81

log10(1000) returns 3

Square root. This function returns the standard square root of the specified number.

Syntax: sqrt(x)

Examples: sqrt(81) returns 9

sqrt(.25) returns .5

Standard deviation population. This function returns the Population Standard Deviation of the specified expression.

Syntax: stddevp [summary, dimension]

Example: stddevp(sum(value("Units")), "Customer")