Article updated on June 20, 2018

The TREND function calculates values along a linear trend. Fits a straight line (using the method of least squares) to the arrays known_y's and known_x's.

It returns the y-values along that line for the array of new_x's that you specify.

Array formula in cell D8:D11

=TREND(C3:C7,B3:B7,B8:B11)

Excel Function Syntax

TREND(known_y's, [known_x's], [new_x's], [const])

Arguments

nown_y's Required. The set of y-values you already know in the relationship y = mx + b.
[known_x's] Optional. An optional set of x-values that you may already know in the relationship y = mx + b. Default values are 1, 2, 3 ...
[new_x's] Optional. New x-values for which you want TREND to return corresponding y-values. If you omit new_x's, it is assumed to be the same as known_x's.
 [const] Optional. A logical value specifying whether to force the constant b to equal 0.

Comments

The following chart shows the TREND function plotted red.