HomeApplicationOffice informationHow to Run Regression Analysis in Microsoft Excel

How to Run Regression Analysis in Microsoft Excel

Method 1 of 2:

Make Sure Regression Analysis Is Supported On Your Excel

  1. How to Run Regression Analysis in Microsoft Excel Picture 1
    If your version of Excel displays the ribbon (Home, Insert, Page Layout, Formulas…)
    1. Click on the Office Button at the top left of the page and go to Excel Options.
    2. Click on Add-Ins on the left side of the page.
    3. Find Analysis tool pack. If it's on your list of active add-ins, you're set.
      1. If it's on your list of inactive add-ins, look at the bottom of the window for the drop-down list next to Manage, make sure Excel Add-Ins is selected, and hit Go. In the next window that pops up, make sure Analysis tool pack is checked and hit OK to activate. Allow it to install if necessary.
  2. How to Run Regression Analysis in Microsoft Excel Picture 2
    If your version of Excel displays the traditional toolbar (File, Edit, View, Insert…)
    1. Go to Tools > Add-Ins.
    2. Find Analysis tool pack. (If you don't see it, look for it using the Browse function.)
      1. If it's in the Add-Ins Available box, make sure Analysis tool pack is checked and hit OK to activate. Allow it to install if necessary.
  3. How to Run Regression Analysis in Microsoft Excel Picture 3
    Excel for Mac 2011 and higher do not include the analysis tool pack. You can't do it without a different piece of software. This was by design since Microsoft does not like Apple.
Method 2 of 2:

Run Regression Analysis

  1. How to Run Regression Analysis in Microsoft Excel Picture 4
    Enter the data into the spreadsheet that you are evaluating. You should have at least two columns of numbers that will be representing your Input Y Range and your Input X Range. Input Y represents the dependent variable while Input X is your independent variable.
  2. How to Run Regression Analysis in Microsoft Excel Picture 5
    Open the Regression Analysis tool.
    1. If your version of Excel displays the ribbon, go to Data, find the Analysis section, hit Data Analysis, and choose Regression from the list of tools.
    2. If your version of Excel displays the traditional toolbar, go to Tools > Data Analysis and choose Regression from the list of tools.
  3. How to Run Regression Analysis in Microsoft Excel Picture 6
    Define your Input Y Range. In the Regression Analysis box, click inside the Input Y Range box. Then, click and drag your cursor in the Input Y Range field to select all the numbers you want to analyze. You will see a formula that has been entered into the Input Y Range spot.
  4. How to Run Regression Analysis in Microsoft Excel Picture 7
    Repeat the previous step for the Input X Range.
  5. How to Run Regression Analysis in Microsoft Excel Picture 8
    Modify your settings if desired. Choose whether or not to display labels, residuals, residual plots, etc. by checking the desired boxes.
  6. How to Run Regression Analysis in Microsoft Excel Picture 9
    Designate where the output will appear. You can either select a particular output range or send the data to a new workbook or worksheet.
  7. How to Run Regression Analysis in Microsoft Excel Picture 10
    Click OK. The summary of your regression output will appear where designated.

Sample Regression Analyses

How to Run Regression Analysis in Microsoft Excel Picture 11 Sample Regression Analysis
How to Run Regression Analysis in Microsoft Excel Picture 12 Sample Regression Analysis for House Size
How to Run Regression Analysis in Microsoft Excel Picture 13 Sample Regression Analysis for Blood Pressure
4 ★ | 1 Vote
analysisregressioninputexcel

You should read it

May be interested

  • How to Add Up Columns in ExcelPhoto of How to Add Up Columns in Excel
    this wikihow teaches you how to add two or more columns together in an excel document. you can use the sum command on both windows and mac versions of excel to do so. open your excel document. double-click the excel document that you want...
  • How to Search for Words in ExcelPhoto of How to Search for Words in Excel
    an excel document can be overwhelming to look through. thankfully, you can use the search function to conveniently locate a particular word, or group of words, in an excel worksheet. launch ms excel. do this by clicking on its icon in your...
  • How to Unshare an Excel WorkbookPhoto of How to Unshare an Excel Workbook
    this wikihow teaches you how to stop sharing a microsoft excel document on desktop, iphone, and android platforms. open excel. it's a green app with a white 'x' on it. to open a shared document that you wish to unshare, you'll need to load...
  • How to Use the Sum Function in Microsoft ExcelPhoto of How to Use the Sum Function in Microsoft Excel
    using the sum function in excel is an easy way to save yourself lots of time. decide what column of numbers or words you would like to add up
  • How to Integrate Large Data Sets in ExcelPhoto of How to Integrate Large Data Sets in Excel
    these instructions will show you how to approximate integrals for large data sets in microsoft excel. this can be particularly useful when analyzing data from machinery or equipment that takes a large number of measurements—for example, in ...
  • How to Make Tables Using Microsoft ExcelPhoto of How to Make Tables Using Microsoft Excel
    this wikihow teaches you how to create a table of information in microsoft excel. you can do this on both windows and mac versions of excel. open your excel document. double-click the excel document, or double-click the excel icon and then...

Office information