VBA to Compute a Linear Regression Analysis.

Category:
Office/VBA
Type:
Controls
Difficulty:
Intermediate
Author:
Anonymous

Version Compatibility: Visual Basic 6

More information:
This code performs a multiple linear regression analysis by programming the worksheet using R1C1 references and VBA. Analysis data are input through a userform and the resultant model is constructed on a new worksheet with all applicable worksheet functions included. Since the data are not mean centered or standardized, numerical inaccuracy may result where the data are significantly ill-conditioned.

Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.

Download linearregression.zip