To predict the value of Y given new values of X, use the TREND function. The TREND function returns an array containing a predicted Y value for each new value of X.
Note that the TREND function returns an array. The results will not be displayed properly of you just select “OK” to close the Function Arguments dialog box. You must press CONTROL + SHIFT + ENTER at the same time to get it right.
Key Terms
Regression, Regression Equation, Regression Line, Slope, Intercept, Causal Relationship
Important Symbols
Last Modified: 06/03/2021