VBA to Compute a Linear Regression Analysis.
Version Compatibility: Visual Basic 6
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.