Rutgers University



Activating Analysis ToolPak – VBA for EXCEL and Performing Regression with EXCELClick on:FileOptions (lower left)Add-Ins (on left)Analysis ToolPak-VBAGo (near the bottom)Analysis ToolPak-VBA (in window)OkTerminate EXCEL. Restart EXCEL. Under data tab, there is a data analysis on the right. Regression is one of the pull down options. Once the regression window opens, specify where the “Y” data is, where “X” data is. If you have multiple X variables, place the data in columns next to one another and highlight all the rows and columns that have X data. EXCEL will interpret each column of data as a different independent variable. Lastly, specify where in the spreadsheet you want the output to be displayed than click on Ok. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download