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
Search JabSto ::

Custom Search