Microsoft Office Tutorials and References

In Depth Information

**Understanding Excel Functions**

6

chapter

Building Formulas

Statistical Functions

The following table lists some common statistical functions:

Function

Description

AVERAGE(number1,number2,...)

Returns the average of the arguments

COUNT(number1,number2,...)

Counts the numbers in the argument list

MAX(number1,number2,...)

Returns the maximum value of the arguments

MEDIAN(number1,number2,...)

Returns the median value of the arguments

MIN(number1,number2,...)

Returns the minimum value of the arguments

MODE(number1,number2,...)

Returns the most common value of the arguments

STDEV(number1,number2,...)

Returns the standard deviation based on a sample

STDEVP(number1,number2,...)

Returns the standard deviation based on an entire population

Financial Functions

Most of the Excel financial functions use the following arguments:

Argument

Description

rate

The fixed rate of interest over the term of the loan or investment

nper

The number of payments or deposit periods over the term of the loan or investment

pmt

The periodic payment or deposit

pv

The present value of the loan (the principal) or the initial deposit in an investment

fv

The future value of the loan or investment

type

The type of payment or deposit: 0 (the default) for end-of-period payments or deposits; 1 for beginning-of-period

payments or deposits

The following table lists some common financial functions:

Function

Description

FV(rate,nper,pmt,pv,type)

Returns the future value of an investment or loan

IPMT(rate,per,nper,pv,fv,type)

Returns the interest payment for a specified period of a loan

NPER(rate,pmt,pv,fv,type)

Returns the number of periods for an investment or loan

PMT(rate,nper,pv,fv,type)

Returns the periodic payment for a loan or investment

PPMT(rate,per,nper,pv,fv,type)

Returns the principal payment for a specified period of a loan

PV(rate,nper,pmt,fv,type)

Returns the present value of an investment

RATE(nper,pmt,pv,fv,type,guess)

Returns the periodic interest rate for a loan or investment