TREND Function Explained
The TREND function in Microsoft Excel is used to calculate a linear trend line through a given set of y-values and x-values and extend it to new x-values. It returns an array of values that correspond to the predicted y-values based on the linear trend. It can also be used to calculate the slope and intercept of the trend line.
TREND Function Syntax
TREND(known_y's, [known_x's], [new_x's], [const])
- known_y’s: An array or range of dependent y-values that are already known.
- known_x’s: An array or range of independent x-values that are already known.
- new_x’s: An array or range of new x-values for which you want TREND to return corresponding y-values.
- const: A logical value specifying whether to force the constant b0 in the equation (TREND returns the y-values for the given x-values at the given power of x, with the constant b0).