Buzz
Excel is a suitable program for performing multiple regression, even for users who lack access to advanced statistical software. The process is both fast and easy to learn.
Steps
Open Microsoft Excel.
Check if the Analysis ToolPak is active by clicking on the "Data" tab.
Select Add-ins
Enter your data or open a data file. The data should be in adjacent columns, with labels in the first row of each column.
Click on the "Data" tab, then select "Data Analysis" in the "Analysis" section (typically located near the right side of the Data tab options).
Enter the dependent data by placing the cursor in the "Input Y-Range" field, then select the data column in the Workbook (which contains various types of spreadsheets).
You can input independent variables by placing the cursor in the "Input X-Range" field, then selecting multiple columns in the Workbook (for example, select $C$1:$E$53).
- NOTE: The independent variable data columns MUST be adjacent for the input process to proceed correctly.
- If using labels (usually found in the first row of each column), click the box next to "Labels".
- The default confidence level is 95%. To change this value, click the box next to "Confidence Level" and adjust the value as desired.
- You can type into the "New Worksheet Ply" field under "Output Options".
Select the desired options under the "Residuals" section. The residuals plot will be generated using the "Residual Plots" and "Line Fit Plots" options.
Click "OK" and the analysis will begin.
