Predicting Y with Excel

Fundamentals of Social Statistics

 

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


[ Back | Contents | Next ]

Last Modified:  07/03/2018

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.