
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 specied range contains a non-numeric object.
AMORT
Amortization. Calculates the principal, interest, and balance of a loan over a specied 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 specied, 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 conguration 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 Finance app
functions on page 410 for details. Note that only the rst four are required. fix is the number of decimal
places to be used in the displayed results.
STAT1
The STAT1 function provides a range of one-variable statistics based on lists of data.
STAT1(input_range, [mode], [configuration])
Input_range is the data source, such as A1:D8.
Mode denes how the input is treated.
The valid values for mode are as follows:
1 = Single data. Each column is treated as an independent dataset.
2 = Frequency data. Columns are used in pairs and the second column is treated as the frequency of
appearance of the rst column.
If more than one column is specied, they are each treated as a dierent input data set. If only one row is
selected, it is treated as 1 data set. If two columns are selected, the mode defaults to frequency.
App menu 389
Komentarze do niniejszej Instrukcji