STDEV

Syntax

STDEV (Dimension, Values, {Type}, {Condition})

Description

The STDEV function returns the standard deviation of Values. If Type is zero or omitted, STDEV calculates a population standard deviation; otherwise, STDEV calculates a sample standard deviation. If Condition is omitted, the function uses all Values. If Condition is included, the function uses only those Values where Condition is true.

Example

Suppose that an analytic model contains a data cube called SALES that uses dimensions called PEOPLE and MONTHS.

Use this formula to calculate the standard deviation over time for each person:

STDEV(MONTHS, SALES, 0)

Use this formula to calculate the standard deviation of sales over 5000 for each month:

STDEV(PEOPLE, SALES, 0, SALES > 5000)