HP Prime Graphing Wireless Calculator Instrukcja Użytkownika Strona 437

  • Pobierz
  • Dodaj do moich podręczników
  • Drukuj
Przeglądanie stron 436
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 specied range contains a non-numeric object.
AMORT
Amortization. Calculates the principal, interest, and balance of a loan over a specied 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 specied, 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 conguration 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 denes 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 specied, they are each treated as a dierent 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
Przeglądanie stron 436
1 2 ... 432 433 434 435 436 437 438 439 440 441 442 ... 700 701

Komentarze do niniejszej Instrukcji

Brak uwag