Content

• To step

Excel is a good option for running multiple regressions, especially if you cannot use specialist statistical software. The procedure is quick and easy to learn.

To step

1. Verify that the "Data Analytics" ToolPak is active by clicking the "Data" tab. If you don't see the option, you will first have to enable it as follows:
   • Open the "File" menu (or press Alt + F) and select "Options".
   • Click on "Add-ons" on the left side of the window.
   • Click "Start" next to the "Manage: Add-ons" option at the bottom of the window.
   • Select Add-ons In the new window, check the box next to "Analysis ToolPak" and click "OK" Select Add-ons Enter your details or open your database. Data must be arranged in adjacent columns and the labels must be in the first row of each column.
   • Select the "Data" tab, then click "Data Analysis" in the "Analysis" group (probably (far) right of the data tab), then click "Regression".
   • Enter the dependent (Y) data first by placing the cursor in the "Input Range Y" field, then selecting the data column in the worksheet.
   • The independent variables are entered by first placing the cursor in the "Input Range X" field, then selecting multiple columns in the worksheet (eg. $ C $ 1: $ E $ 53).
     • The data columns with independent variables MUST be next to each other for the input to be correct.
     • If you are using labels (again, they should be in the first row of each column), check the box next to "Labels".
     • By default, the Confidence level is set to 95%. If you want to change this value, click the box next to "Confidence Level" and adjust the value.
     • Under "Output Range", type a name in the "New Worksheet" field.
   • Select the desired options in the "Faults" category. Graphical output of faults are created with the options "Graphs for faults" and "Graphs for lines".
   • Click on "OK" and the analysis will be performed.