Question

How do you create your multiple regression formula from your data? I ran my Regression in excel and I have my data, I just don't know how to create the formula.

Answer 1

First install Add-In and connect it with excel (Lots of videos there are in YouTube)

Check to see if the "Data Analysis" ToolPak is active by clicking on the "Data" tab. 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

Enter your data, or open your data file. Data must be arranged in immediately adjacent columns and labels should be in the first row of each column.

Select the "Data" tab, then click "Data Analysis" in the "Analysis" grouping (most likely at or near the far right of Data tab options).

Input the dependent (Y) data by first placing the cursor in the "Input Y-Range" field, then highlighting the column of data in the workbook.

The independent variables are entered by first placing the cursor in the "Input X-Range" field, then highlighting multiple columns in the workbook (e.g. $C$1:$E$53)

Select the desired options in the "Residuals" category. Graphical residual outputs are created by with the "Residual Plots" and "Line Fit Plots" options.

Click "OK" and the analysis will be created.