HP Prime Graphing NW280AAABA Calculates the arithmetic mean of a range of numbers, Finance app

Models: Prime Graphing NW280AAABA

1 616
Download 616 pages 24.49 Kb
Page 357
Image 357

AVERAGE

Calculates the arithmetic mean of a range of numbers.

 

AVERAGE([input])

 

For example, AVERAGE(B7:B23) returns the arithmetic

 

mean of the numbers in the range B7 to B23. You can also

 

specify a block of cells, as in AVERAG(B7:C23).

 

An error is returned if a cell in the specified range contains a

 

non-numeric object.

AMORT

Amortization. Calculates the principal, interest, and balance

 

of a loan over a specified period. Corresponds to pressing

 

in the Finance app.

 

AMORT(Range, NbPmt, IPYR, PV, PMTV[, PPYR=12,

 

CPYR=PPYR, GSize=PPYR, BEG=0, fix=current],

 

"configuration"])

 

Range: the cell range where the results are to be placed. If

 

only one cell is specified, then the range is automatically

 

calculated starting from that cell.

Configuration: a string that controls what results are shown and the order in which they appear. An empty string

""displays the default: all results, including headers. The options in the configuration string are separated by spaces.

h – show row headers

H – show column headers

S – show the start of the period E – show the end of the period

P – show the principal paid this period

B – show the balance at the end of the period I – show the interest paid this period

All the other input parameters (except fix) are Finance app Numeric view variables; see page 440 for details. Note that only the first four are required. fix is the number of decimal places to be used in the displayed results.

Functions and commands

351

Page 357
Image 357
HP Prime Graphing NW280AAABA manual Calculates the arithmetic mean of a range of numbers, Finance app