Filter
Top Products
350 Functions and commands
• 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 modes 1–6)
– int (intercept, only valid for modes 1–6)
– cor (correlation, only valid for modes 1–6)
– cd (Coefficient of determination, only valid for modes
1–6, 8–10)
– sCov (Sample covariance, only valid for modes 1–6)
– pCov (Population covariance, only valid for modes
1–6)
– L (L parameter for mode 7)
– a (a parameter for modes 7-–11)
– b (b parameter for modes 7-–11)
– c (c parameter for modes 8–11)
– d (d parameter for modes 8, 10–11)
– e (e parameter for mode 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)
PredY Returns the predicted Y for a given x.
PredY(mode, x, parameters)
• Mode governs the regression model used:
1 y= sl*x+int
2 y= sl*ln(x)+int
3 y= int*exp(sl*x)
4 y= int*x^sl