Technical data

Chapter 11 Using Built-in Functions in Analytic M odels

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

QUARTILE(STUDENTS, SCORES, 3)

The following f

ormula calculates the second quartile (also known as the median) of the first ten students:

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

RAND

Syntax

RAND()

Description

The RAND funct

ion returns a random decimal number greater than or equal to zero and less than one.

The RAND function uses an industrial strength random number generator with an extremely long period.

Thus, it is suitable for use in statistical simulation.

The PeopleSoft Analytic Calculation Engine RAND function does not cause a cube to be calculated during

every recalculation, unlike in Microsoft Excel. Formulas that use RAND typically refer to some other data in

the analytic model, and the analytic calculation engine recalculates the cube only when the other data changes.

If you use the RAND function to populate a cube with data for demos or testing — and you do not refer to

other cubes — the data in the cube does not change unless you edit the formula or calculate the data cube.

Returns

A random deci

mal number greater than or equal to zero and less than one.

Example

RAND() returns 0.938119738.

RATE

Syntax

RATE(NPer, Pmt, PV, FV, {Type})

Description

The RATE function returns the rate required to accumulate a future value of FV when the present value is PV,

the number of periods is NPer, and the payment is Pmt.IfType is omitted or zero, RATE assumes that the

investment is an ordinary annuity. If Type is nonzero, RATE assumes that the investment is an annuity due.

Note. Enter negative amounts for money out of your pocket, or positive amounts for money coming to you.

Returns

The RATE function returns the rate required to accumulate a future value of FV when the present value is PV,

the number of periods is NPer, and the payment is Pmt.IfType is omitted or zero, RATE assumes that the

investment is an ordinary annuity. If Type is nonzero, RATE assumes that the investment is an annuity due.

Note. Enter negative amounts for money out of your pocket, or positive amounts for money coming to you.