Conguration denes which values are in which row and whether the set has row or column headers. The
values in the spreadsheet appear in the order the symbol for each value was entered.
The valid values for conguration are as follows:
●
H (inserts column headers)
●
h (inserts row headers)
●
MeanX
●
Σ
●
Σ²
●
s
●
s²
●
σ
●
σ²
●
serr
●
ss
●
n
●
min
●
q1
●
med
●
q3
●
max
For example, if you specify "h n σ", in the resulting spreadsheet, the rst column contains row headers, the
rst row is the number of items in the input data, and the second row is the standard deviation of the
population.
Examples:
STAT1(A25:A37)
STAT1(A25:A37,"h n σ")
STAT2
The STAT2 function provides a range of two-variable statistics.
STAT2(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 pair of columns is treated as an independent dataset.
2 = Frequency data. Columns are used in groups of three, and the third column is treated as the frequency of
appearance of the paired columns.
390 Chapter 22 Functions and commands
Komentarze do niniejszej Instrukcji