Filter
Top Products
354 Functions and commands
7 y= L/(1 + a*exp(b*x))
8y= a*sin(b*x+c)+d
9y= cx^2+bx+a
10 y= dx^3+cx^2+bx+a
11 y = e x^4+dx^3+cx^2+bx+a
• Configuration: a string which indicates which values you
want to place in which row and if you want row and
columns headers. Place each parameter in the order that
you want to see them appear in the spreadsheet. (If you
do not provide a configuration string, a default one will
be provided.) The valid parameters are:
– H (Place column headers)
– h (Place row headers)
– sl (slope, only valid for models 1–6)
– int (intercept, only valid for models 1–6)
– cor (correlation, only valid for models 1–6)
– cd (Coefficient of determination, only valid for models
1–6, 8–10)
– sCov (Sample covariance, only valid for models 1–6)
– pCov (Population covariance, only valid for models
1–6)
– L (L parameter for model 7)
– a (a parameter for models 7-–11)
– b (b parameter for models 7-–11)
– c (c parameter for models 8–11)
– d (d parameter for models 8, 10–11)
– e (e parameter for model 11)
– py (place 2 cells, one for user input and the other to
display the predicted y for the input)
– px (place 2 cells, one for user input and the other to
display the predicted x for the input)
Example: REGRS(A25:B37,2)