If several x variables are used, known_y's must be a vector (one column or one row).

If only one x variable is used, known_y's and known_x's can be ranges of any shape but equal dimension.

Known_x's (optional) - one or more sets of the independent x-values. Known_y's (required) - a set of the dependent y-values that you already know. The syntax of the Excel TREND function is as follows: The Excel TREND function is used to calculate a linear trend line through a given set of dependent y-values and, optionally, a set of independent x-values and return values along the trend line.Īdditionally, the TREND function can extend the trendline into the future to project dependent y-values for a set of new x-values.

Trend formula with multiple sets of x-values.

Trendline analysis based on historical data.

How to use TREND function in Excel - formula examples.

Trend analysis can help you identify underlying patterns in the past and current data movements and project future behavior. These days when technologies, markets and customer needs are changing so rapidly, it is critical that you move with trends, and not against them.

The tutorial shows how to calculate trend in Excel by using the TREND function, how to create trends on a graph, and more.

Trend lines in excel 2016