Content

• To step
• Method 1 of 2: Make Regression Analysis Available in your Version of Excel
• Method 2 of 2: The Regression Analysis

Regression analysis is an excellent method for analyzing large amounts of data and making forecasts and predictions. Review the following instructions to work with regression analysis in Microsoft Excel.

To step

Method 1 of 2: Make Regression Analysis Available in your Version of Excel

1. If you have a version of Excel with a ribbon (a ribbon) (Start, Insert, Page Layout, etc)
   • Click on the "File" tab or the Office Button at the top left of the window and go to Excel Options (only needed with the Office Button).
   • click on Add-ons on the left side of the page.
   • Find it Analysis tool pack. If it is already in the list of active add-ons, then you are done.
     • If not, look at the bottom of the screen for the drop-down list next to Management, make sure that Excel Add-ins is selected, and click Ready. In the next window you can Analysis tool pack check. click on OK to activate. Install it if necessary.
2. Do you have a version of Excel with a traditional menu (File, Edit, View, etc.)
   • Go to Functions > Add-ons.
   • Find it Analysis tool pack. (If you don't see it, use the Leaves function.)
     • Make sure that Analysis tool pack checked and click OK to activate. Install it if necessary.
3. Excel for Mac 2011 and above does not come with the analysis tool pack. You need separate software for this.

Method 2 of 2: The Regression Analysis

1. Enter the data into the worksheet / spreadsheet that you will be analyzing. You should have at least two columns of numbers representing Input Range Y and your Input Range X. Input Y represents the dependent variable while Input X represents the independent variable.
2. Open the Regression Analysis tool.
   • If you have a version of Excel with the ribbon/it ribbon, then go to data, and then right-click in the box Analysis, on Data analysis, and choose Regression from the list of options.
   • If you have a version of Excel with the traditional menu, then go to Functions > Data analysis and choose Regression from the list of options.
3. Determine your Input Range Y. In the Regression Analysis window, click inside the input field Input range Y. Then click in the Input range Y field to select all the numbers you want to analyze. You will now see the cells you selected are in the Input Range Y box.
4. Repeat the previous step for Input Range X.
5. Change the settings if necessary. Choose whether or not you want to show labels, confidence level, etc., by checking them or not.
6. Determine where the results should be placed. You can choose a specific output range or forward the data to a new workbook or worksheet.
7. click on OK. An overview of the output of the regression analysis appears at the desired location in Excel.