I'd like to make you aware of some major updates to RegressIt, a very powerful and user-friendly Excel add-in for multivariate descriptive analysis and linear and logistic regression that is available for free at this web site:
A quick overview of its features can be found in this set of slides:
Versions of RegressIt have been distributed to the public since 2014, but it has recently undergone significant enhancements, including an innovative menu system for model space navigation and output display, the ability to run on Macs as well as PC's, an interface for performing both linear and logistic regression analysis in R, and a separate PC version for logistic regression within Excel. The logistic regression version of the program generates highly interactive output worksheets in which cutoff values in classification tables and ROC charts can be dialed up and down after fitting a model, a good tool for sensitivity analysis and live demonstrations.
RegressIt was developed in a teaching environment at Duke University for a course on regression and time series analysis taught to MBA's and grad students in other departments, and it is also intended for wider use in teaching (including workshops and webinars) as well as in applications. It has a sophisticated but easy-to-use interface that is designed to take maximum advantage of the interactivity and multiple dimensions of the Excel environment, with many unique audit trail features to support teaching and grading as well as to keep your own work organized.
For those who teach or otherwise work with R, it includes a menu interface that allows Excel to be used as a front end for running linear and logistic regression models in R (with customized table and chart output in both environments) and allows R to be used as a computational back end for work carried out mainly in Excel. See this page and its links for details:
Whatever your prior feelings about statistical analysis in Excel, take a look at RegressIt and try out its features to see how it provides a very effective platform for teaching and applying regression analysis, one that could even be integrated into an R-based curriculum. I welcome your feedback.
You may leave the list at any time by sending the command
to [log in to unmask], leaving the subject line blank.