Running a Multiple Regression in Excel

Fundamentals of Social Statistics by Adam J. McKee

The multiple regression function in Excel is no different than that we used to run a simple regression analysis (only one predictor variable) other than we are highlighting a range of columns rather than a single column for X.  The predictor variables must be adjacent columns.  If they are not entered that way, then you can simply cut and paste them into a new sheet to get the layout you want.  The first cell in every column can be a label.  This makes interpreting your results much easier.


[ Back | Contents | Next ]

Last Modified:  06/04/2021

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.