QUARTILE

Syntax

QUARTILE (Dimension, Values, Quartile, {Type}, {Condition})

Description

The QUARTILE function returns a quartile of Values.

The Quartile argument sets which quartile (0, 1 ,2 , 3, or 4) is calculated. If Type is zero or omitted, QUARTILE calculates a population quartile; otherwise, QUARTILE calculates a sample quartile. If Condition is omitted, the function uses all Values. If Condition is included, the function uses only those Values for which Condition is true.

Returns

The QUARTILE function returns a quartile of Values. The Quartile argument sets the quartile (0, 1 ,2 , 3, or 4) that is calculated. If Type is zero or omitted, QUARTILE calculates a population quartile; otherwise, QUARTILE calculates a sample quartile. If Condition is omitted, the function uses all Values. If Condition is included, the function uses only those Values for which Condition is true.

Example

For example, suppose that an analytic model contains a data cube called SCORES that uses dimensions called STUDENTS and TESTS.

The following formula calculates the third quartile of the scores for each test.

QUARTILE(STUDENTS, SCORES, 3)

The following formula calculates the second quartile (also known as the median) of the first ten students:

QUARTILE(STUDENTS, SCORES, 2, MEMBER(STUDENTS) <= 10)