Returns numbers in a linear trend matching known data points, using the least squares method.
Name | Type | Description |
arg1 | ApiRange | Array.<number> | A range or array of y-values from the y = mx + b equation. |
arg2 | ApiRange | Array.<number> | An optional range or array of x-values from the y = mx + b equation, an array of the same size as an array of y-values. |
arg3 | ApiRange | Array.<number> | A range or array of new x-values for which this function will return corresponding y-values. |
arg4 | boolean | A logical value: the constant b is calculated normally if this parameter is set to true or omitted, and b is set equal to 0 if the parameter is false. |