** Syntax**. TREND(

** Definition**. This function returns values along a linear trend. TREND() fits a straight line (using the method of least squares) to the

**Arguments**

. The y-values you already know from the relationship*known_y’s*(required)*y*=*mx*+*b*:If the

*known_y’s*array consists of a single column, then each column in the*known_x’s*array is interpreted as a separate variable.If the

*known_y’s*array consists of a single row, then each row in the*known_x’s*array is interpreted as a separate variable.

. The x-values you already know from the relationship*known_x’s*(optional)*y*=*mx*+*b*:The

*known_x’s ...*

Start Free Trial

No credit card required