How to Run Regression Analysis in Microsoft Excel

Step-by-Step Guide

1. 1

   Step 1: If your version of Excel displays the ribbon (Home

   Click on Add-Ins on the left side of the page.
   
   Find Analysis tool pack.
   
   If it’s on your list of active add-ins, you’re set.
   
   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. 2

   Step 2: Insert

   Find Analysis tool pack. (If you don’t see it, look for it using the Browse function.) 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. , You can't do it without a different piece of software.
   
   This was by design since Microsoft does not like Apple.
3. 3

   Step 3: Page Layout

4. 4

   Step 4: Formulas…) Click on the Office Button at the top left of the page and go to Excel Options.

5. 5

   Step 5: If your version of Excel displays the traditional toolbar (File

6. 6

   Step 6: Insert…) Go to Tools > Add-Ins.

7. 7

   Step 7: Excel for Mac 2011 and higher do not include the analysis tool pack.

Detailed Guide

About the Author