How to Run Multiple Regression Analysis in Excel: 8 Steps

Table of contents:

How to Run Multiple Regression Analysis in Excel: 8 Steps
How to Run Multiple Regression Analysis in Excel: 8 Steps

Video: How to Run Multiple Regression Analysis in Excel: 8 Steps

Video: How to Run Multiple Regression Analysis in Excel: 8 Steps
Video: How Chemical Equations are Formed? | Don't Memorise 2024, November
Anonim

You can easily run multiple regression analyzes using Excel when you don't have up-to-date statistical software. The analysis process is quick and easy to learn.

Step

Run a Multiple Regression in Excel Step 1
Run a Multiple Regression in Excel Step 1
Image
Image

Step 1. Open Microsoft Excel

Run a Multiple Regression in Excel Step 2
Run a Multiple Regression in Excel Step 2
Image
Image

Step 2. Check if the “Data Analysis” ToolPak is active by clicking on the “Data” label

If you don't see this option, perform the following steps to enable the add-in:

  • 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 the window.
  • Image
    Image

    Check the box next to " Analysis ToolPak " in the new window, then click "OK".

    Image
    Image
  • Image
    Image
    Image
    Image

    Now, your add-in is active.

Run a Multiple Regression in Excel Step 3
Run a Multiple Regression in Excel Step 3

Step 3. Enter the data, or open the data file

The data must be arranged in columns that are next to each other and the labels/titles are in the first row in each column.

Run a Multiple Regression in Excel Step 4
Run a Multiple Regression in Excel Step 4

Step 4. Select the "Data" label, then click " Data Analysis " in the " Analysis " group (it may be at or near the far right of the Data options label)

Image
Image
Run a Multiple Regression in Excel Step 5
Run a Multiple Regression in Excel Step 5

Step 5. Enter the dependent variable (Y) data by placing the cursor in the " Input Y-Range " box, then highlighting the corresponding data column in the workbook

Image
Image
Run a Multiple Regression in Excel Step 6
Run a Multiple Regression in Excel Step 6

Step 6. Enter the independent variable data by placing the cursor in the " Input X-Range " box, then highlight some related data fields in the workbook (eg $C$1:

$E$53).

  • Note: independent variable data fields MUST be next to each other for input to be analyzed properly.
  • If you're using labels or headings (again, headings are in the first row of each column), click the box next to " Labels ".
  • The initial confidence level (default confidence level) is 95%. If you want to change it, click the box next to " Confidence Level " and change the value.
  • Under "Output Options", enter a name in the "New Worksheet Ply" box.
Run a Multiple Regression in Excel Step 7
Run a Multiple Regression in Excel Step 7

Step 7. Select the desired option in the " Residuals " category

Graphical residual output is created with the " Residual Plots " and " Line Fit Plots " options.

Recommended: