TREND

TREND(arg1, arg2, arg3, arg4) → { number }

Returns numbers in a linear trend matching known data points, using the least squares method.

Parameters:

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.

Returns:

Type
number