With an array of statistical software products on the market (e.g., Stata, SPSS, SAS, R, etc.), I limit my use of Excel to data management tasks. That said, I know that others exploit Excel's full capacity and use it for some limited analytical and statistical tasks. To this end, I pass along information on a recent release of an add-in, RegressIt, which is designed to enrich (and ease) Excel's regression capabilities. Developed by a pair of B-School professors, Robert Nau (Duke) and John Butler (Texas), the product is available for free. A brief description follows; click here for more technical information.
“RegressIt © is a PC Excel add-in that performs multivariate descriptive data analysis and multiple linear regression analysis with presentation-quality output in native Excel format…. It is offered free of charge as a public service in order to teach and support good analytical practices, especially data and model visualization, tests of model assumptions, appropriate use of transformed variables in linear models, intelligent formatting of tables and charts, and keeping a detailed and well-organized audit trail.
The RegressIt program file is an Excel macro (xlam) file that is less than 500K in size. It runs on PC’s in Excel 2007, 2010 and 2013, and it can perform analyses and fit models with up to 50 variables at one time and up to 32766 rows of data. You can use it on a Mac if you run it in the Windows version of Excel using VMware Fusion or other PC virtualization software.”