Technical data

Chapter 11 Using Built-in Functions in Analytic M odels

This formula calculates the 50th percentile (also knows as median) of the first 10 students for each test.

Syntax

PI()

Description

The PI functio

n returns the value of PI (3.1415926536), the ratio of a circle’s circumference to its diameter.

The following formula calculates the area of a circle:

PI( ) * RADIUS ^ 2

Returns

The value of PI (3.1415926536), the ratio of a circle’s circumference to its diameter.

Example

The following

examples employ the PI function:

Example 1

PI()*7=21.99 (circumference of a circle with a diameter of 7).

Example 2

PI()*36^2=4071.50 (area of a circle with a radius of 36).

PMT

Syntax

PMT(Rate, NPer, PV, FV, {Type})

Description

The PMT function returns the payment required to repay a loan of PV, at an interest rate of Rate,wherethere

are NPer payments and an ending balance of FV.IfType is omitted or zero, PMT a ssumes that the loan is an

ordinary annuity. If Type is nonzero, PMT assumes that the loan is an annuity due.

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

Returns

The payment required to repay a loan of PV, at an interest rate of Rate, where there are NPer payments and an

ending balance of FV.IfType is omitted or zero, PMT assumes that the loan is a n ordinary annuity. If Type is

nonzero, PMT assumes that the loan is an annuity due.

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