RegressIt is a powerful Excel add-in which performs multivariate descriptive data analysis and linear regression analysis and creates high-quality table and chart output in native Excel format. The 2018 version, which runs on both Macs and PC's, has just been released on this site. It features a 40-button ribbon interface which provides innovative model space and worksheet navigation tools, built-in documentation and teaching notes, interactive use of cell colors and fonts, a multi-threaded audit trail, and the ability to exchange regression code with R. The ribbon greatly streamlines the analysis, minimizing the number of mouse clicks or finger taps that are needed for careful well-labeled work, and it makes it largely unnecessary to use any of Excel's own buttons or menus. A separate version of the program which also performs logistic regression with interactive tables and charts is available for the PC.
The output format and navigation tools are designed to take advantage of all 4 dimensions of the Excel environment—stacks of worksheets, rows and columns of cells, and layers of information within cells--while avoiding the tedium of scrolling and paging and searching with Excel's own controls. These tools greatly simplify the process of exploring multivariate data, fitting and refining and comparing regression models, sharing and evaluating work performed by others, and leaving a comprehensive and easily navigated audit trail.
Facebook | LinkedIn
- For students, these features make it easy to learn principles of regression analysis (and thoughtful data analysis in general) while working efficiently in an Excel environment. The software is good for team exercises and is more fun to use than the standard alternatives, and its presentation quality tables and charts are ready-made for inclusion in reports. It is also self-instructing, with pop-up documentation and teaching notes displayed in message boxes and cell comments.
- For instructors, these features make it easy to teach both statistical concepts and hands-on data analysis, to evaluate student modeling efforts (the entire analytical process, not just the end results), and to verify the originality and authenticity of submitted work. It is good for interactive demonstrations in the classroom as well as for assignments. Even if use of RegressIt is not required in a course, it can be recommended to students as a self-teaching supplementary tool, and many will find their way to this web site anyway.
- For practitioners, these features make it easy to explore a complex model space, to collaborate and share results with colleagues and clients who may have different levels of technical expertise, and to brush up on one's knowledge while working.
- For touchscreen and tablet computer users, the interface makes it easy to drive a fully detailed analysis by tapping one's finger at the top or bottom or side of the screen. The results also look great and are easily navigated with Excel viewing apps on smartphones.
- For R users, it reads and writes R code for linear regression, so that models run in RegressIt can be re-run in R with just a few mouse clicks, and vice versa, allowing you to take advantage of the output features of both and to get a gentle introduction to R (or perhaps Excel) if you need it.
- For anyone who otherwise uses Excel for data analysis, it is a free, major upgrade from what is provided in the Analysis Toolpak, whose design dates to the 1990's.
Facebook | LinkedIn