
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 and the standard deviation, you would enter
=STAT1(A25:A37,”h n σ”). What the conguration string is indicating here is that row headings are
required (h), and just the number of data-points (n) and the standard deviation (σ) will be displayed.
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 specied range contains a non-numeric object.
388 Chapter 22 Functions and commands
Komentarze do niniejszej Instrukcji