Filter
Top Products
352 Functions and commands
STAT1 The STAT1 function provides a range of one-variable statistics.
It can calculate all or any of , Σ, Σ², s, s², σ, σ², serr,
, n, min, q1, med, q3, and max.
STAT1(Input range, [mode], [outlier
removal Factor], ["configuration"])
Input range is the data source (such as A1:D8).
Mode defines how to treat the input. The valid values are:
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 first column.
3 = Weight data. Columns are used in pairs and the
second column is treated as the weight of the first
column.
4 = One–Two data. Columns are used in pairs and the 2
columns are multiplied to generate a data point.
If more than one column is specified, they are each treated as
a different 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.
Outlier Removal Factor: This allows for the removal of any
datapoint that is more than n times the standard deviation
(where n is the outlier removal factor). By default this factor is
set to 2.
Configuration: indicates which values you want to place in
which row and if you want row or columns headers. Place the
symbol for each value in the order that you want to see the
values appear in the spreadsheet. The valid symbols are:
x
x
i
x–
2
H (Place column headers) h (Place row headers)
x
ΣΣ
²
ss²σ
σ²serr n minq1
med q3 max
x
i
x–
2