Filter
Top Products
Functions and commands 349
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, [ mode],
["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.
• Mode: specifies the mode 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
7y= L/(1 + a*exp(b*x))
8 y= a*sin(b*x+c)+d
9y= cx^2+bx+a
10 y= dx^3+cx^2+bx+a
11y= ex^4+dx^3+cx^2+bx+a