VAR

Syntax

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

Description

The VAR function returns the variance of Values. If Type is zero or omitted, VAR calculates a population variance; otherwise, VAR calculates a sample variance. 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 SCORES that uses dimensions called STUDENTS and TESTS.

Use the following formula to calculate the variance of the tests for each student:

VAR(TESTS, SCORES)

Use the following formula to calculate the variance of scores over 75 percent for each test:

VAR(STUDENTS, SCORES, 0, SCORES > 0.75)