VBA to Compute a Linear Regression Analysis.
Category:
Office/VBAType:
ControlsDifficulty:
IntermediateAuthor:
AnonymousVersion 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