This function returns values along a linear trend. This function fits a straight line to the arrays known x and y values. Trend returns the y values along that line for the array of specified new x values.

Syntax

TREND(y,x,newx,constant)

Arguments

This function has these arguments:

Argument	Description
y	Set of y values that are known in the relationship y=mx+b
x	(Optional) X is an optional set of x values that may be known in the relationship y=mx+b
newx	New x values for which this functions returns the corresponding y values
constant	Logical value that specifies whether to force the constant b to equal 0

Remarks

If constant is true or omitted then b is calculated normally. If constant is false then b is equal to 0 and the m values are adjusted so that y=mx.

If x is omitted then x defaults to the array {1,2,3...}, that has the same dimensions as y.

If newx is omitted then it defaults to x.

Use the INDEX function to get individual elements from the returned array.

Data Types

Accepts an array. Returns an array.

Examples

TREND(A2:A7,C2:C7,A9:A10)

Version Available

This function is available in product version 2.0 or later.

See Also

AVEDEV | AVERAGEA | FREQUENCY | DEVSQ | GROWTH | INDEX | MEDIAN | VAR | Statistical Functions