Run a Multiple Regression in Excel

Excel is a great option for running multiple regressions when a user doesn't have access to advanced statistical software.  The process is fast and easy to learn.

Steps

  1. Open Microsoft Excel.
  2. Check to see if the "Data Analysis" ToolPak is active by clicking on the "Data" tab. If you don't see the option, you will need to enable the add-in, as follows:
    • Open the "File" menu (or press Alt+F) and select "Options"
    • Click "Add-Ins" on the left side of the window
    • Click "Go" next to the "Manage: Add-ins" option at the bottom of window
    • In the new window, check the box next to "Analysis ToolPak", then click "OK"
    • The add-in is now enabled
  3. Enter your data, or open your data file.  Data must be arranged in immediately adjacent columns and labels should be in the first row of each column.
  4. Select the "Data" tab, then click "Data Analysis" in the "Analysis" grouping (most likely at or near the far right of Data tab options).
  5. Input the dependent (Y) data by first placing the cursor in the "Input Y-Range" field, then highlighting the column of data in the workbook.
  6. The independent variables are entered by first placing the cursor in the "Input X-Range" field, then highlighting multiple columns in the workbook (e.g. $C$1:$E$53).
    • NOTE:  The independent variable data columns MUST be adjacent one another for the input to occur properly.
    • If you are using labels (which should, again, be in the first row of each column), click the box next to "Labels".
    • The default confidence level is 95%.  If you wish to change this value, click the box next to "Confidence Level" and modify the adjacent value.
    • Under "Output Options", add a name in the "New Worksheet Ply" field.
  7. Select the desired options in the "Residuals" category.  Graphical residual outputs are created by with the "Residual Plots" and "Line Fit Plots" options.
  8. Click "OK" and the analysis will be created.

Related Articles

Retrieved from "https://kipkis.com/index.php?title=Run_a_Multiple_Regression_in_Excel&oldid=275933"