How to Run a Multiple Regression in Excel
Open Microsoft Excel., Check to see if the "Data Analysis" ToolPak is active by clicking on the "Data" tab., Enter your data, or open your data file., Select the "Data" tab, then click "Data Analysis" in the "Analysis" grouping (most likely at or...
Step-by-Step Guide
-
Step 1: Open Microsoft Excel.
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 , Data must be arranged in immediately adjacent columns and labels should be in the first row of each column. ,,, $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. , Graphical residual outputs are created by with the "Residual Plots" and "Line Fit Plots" options. , -
Step 2: Check to see if the "Data Analysis" ToolPak is active by clicking on the "Data" tab.
-
Step 3: Enter your data
-
Step 4: or open your data file.
-
Step 5: Select the "Data" tab
-
Step 6: then click "Data Analysis" in the "Analysis" grouping (most likely at or near the far right of Data tab options).
-
Step 7: Input the dependent (Y) data by first placing the cursor in the "Input Y-Range" field
-
Step 8: then highlighting the column of data in the workbook.
-
Step 9: The independent variables are entered by first placing the cursor in the "Input X-Range" field
-
Step 10: then highlighting multiple columns in the workbook (e.g.
-
Step 11: Select the desired options in the "Residuals" category.
-
Step 12: Click "OK" and the analysis will be created.
Detailed Guide
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 , Data must be arranged in immediately adjacent columns and labels should be in the first row of each column. ,,, $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. , Graphical residual outputs are created by with the "Residual Plots" and "Line Fit Plots" options. ,
About the Author
Jason Collins
Experienced content creator specializing in lifestyle guides and tutorials.
Rate This Guide
How helpful was this guide? Click to rate: