Hp Prime Graphing Calculator Manuel d'utilisateur télécharger pdf (Page 356)

100

101

350 Functions and commands

The syntax for many, but not all, the spreadsheet functions

follows this pattern:

functionName(input,[optional

parameters])

Input is the input list for the function. This can be a cell range

reference, a simple list or anything that results in a list of

values.

One useful optional parameter is Configuration. This is a

string that controls which values are output. Leaving the

parameter out produces the default output. The order of the

values can also be controlled by the order that they appear in

the string.

For example:

=STAT1(A25:A37)

produces the following

default output, based on the

numerical values in cells

A25 through A37.

However, if you just wanted

to see the number of data-

points, the mean, and the

standard deviation, you

would enter

=STAT1(A25:A37,”h n

”). What the

configuration string is

indicating here is that row headings are required (h), but just

return the number of data-points (n), the mean (x

), and the

standard deviation (). See page 352 for details on the

configuration string for this command.

SUM Calculates the sum of a range of numbers.

SUM([input])

For example, SUM(B7:B23) returns the sum of the numbers

in the range B7 to B23. You can also specify a block of cells,

as in SUM(B7:C23).

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

non-numeric object.

1 2 ... 351 352 353 354 355 356 357 358 359 360 361 ... 615 616

Commentaires sur ces manuels

Pas de commentaire

Hp Prime Graphing Calculator Manuel d'utilisateur Page 356

Commentaires sur ces manuels

Produits connexes et manuels pour PDAs Hp Prime Graphing Calculator