Filter
Top Products
Functions and commands 353
For example if you specify "h n Σ x", the first column will
contain row headers, the first row will be the number of items
in the input data, the second the sum of the items and the third
the mean of the data. If you do not specify a configuration
string, a default string will be used.
Notes:
The STAT1 f function only updates the content of the
destination cells when the cell that contains the formula is
calculated. This means that if the spreadsheet view contains
at the same time results and inputs, but not the cell that
contains the call to the STAT1 function, updating the data will
not update the results as the cell that contains STAT1 is not
recalculated (since it is not visible).
The format of cells that receive headers is changed to have
Show " " set to false.
The STAT1 function will overwrite the content of destination
cells, potentially erasing data.
Examples:
STAT1(A25:A37)
STAT1(A25:A37,”h n x
”).
REGRS Attempts to fit the input data to a specified function (default is
linear).
REGRS(Input range,[model],
["configuration"])
• Input range: specifies the data source; for example
A1:D8. It must contain an even number of columns. Each
pair will be treated as a distinct set of datapoints.
• model: specifies the model to be used for the regression:
1y= sl*x+int
2y= sl*ln(x)+int
3y= int*exp(sl*x)
4y= int*x^sl
5y= int*sl^x
6y= sl/x+int