/Astrolabe-Regression

VBA tool for regressions in Excel

Primary LanguageVisual Basic

Astrolabe-Regression

VBA tool for regressions in Excel

To use it please put your data in an Excel sheet, from Range A1, with labels and activate the UserForm. In "Select Y" TextBox insert the number of the Y column and in "Select Xs" TextBox insert the numbers of the Xs columns separated by commas.

For instance if the Y is in column A and the Xs in columns B and C, you have to write 1 in "Select Y" and 2,3 in "Select Xs".

In order to use this tool you need the Excel Add-in called "Data Analysis".

This tool has been created and tested in Excel 2016.