HP Prime Graphing NW280AAABA FunctionNameinput,optional Parameters, =STAT1A25A37, As in SUMB7C23

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
	x σ”). 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.

350 Functions and commands