how to use a trendline equation in excel

If const is FALSE, the intercept is set equal to 0.

If const is TRUE or omitted, the intercept is calculated normally,.

const (optional) is a boolean value specifying whether to force the parameter b (intercept) to equal 0:.

Use the results of the ÂLINEST to predict sales. The formula is the intercept in F2 plus the slope in E2 times this rows month number. In column D, enter a formula to calculate the predicted sales trendline. If known_x's is omitted, it is assumed to be the array that is the same size as known_y's. Excel returns both the slope and the y-intercept.

known_x's (optional) are independent data values.

known_y's (required) are dependent data values,.

The syntax is as below: TREND (knownys, knownxs, newxs, const) The const parameter determines how the b value in the line equation y ax + b is calculated. To calculate the linear trendline values, Excel offers the array function TREND () (see the notes above about array functions) that returns values along a linear trend: TREND is a statistic function in Excel that takes the known Ys and the known Xs, creates a trend line, and then projects new Ys for given Xs using that trend line.

If the count of known_y's is different from known_x's, the INTERCEPT () and SLOPE () functions returns #N/A.

If there is only one value in known_y's or known_x's, the INTERCEPT () and SLOPE () functions will return #DIV/0!.

The SLOPE () function returns the slope (the parameter a) of a linear regression line based on known_y's and known_x's data:

known_x's (required) are independent data values (see an example below) - a range or array of numeric values.

known_y's (required) are dependent data values - a range or array of numeric values,.

In other words, using the known_x's and known_y's data, it returns the value y of the function for x = 0: The INTERCEPT () function calculates the y value at which the linear trendline crosses the y-axis. Excel offers the following functions to calculate trendline parameters:

How to use a trendline equation in excel