An Excel GLM Program for Statistics Classes and Beyond

• In Event: Extending the General Linear Model: From Classical Regression to Bayesian Estimation and Machine Learning

Abstract

The virtual interface enforced by COVID-19 made university labs and software used for teaching statistics unavailable. Therefore, we created a flexible and powerful Excel program that can perform most general linear model analyses, allowing delivery of a statistical methods course, from beginning to advanced, without those labs and software. We have also taken this opportunity to provide embedded contextual guidance toward correct understanding of analyses, pointing out where commercial packages err. To promote subsequent use of quantitative methods, all relevant output is in “camera-ready” APA cut-and-paste tables. Our evaluation data suggest that students negotiate statistics better with this tool than commercial packages. We offer its availability and our experiences here.

Authors

• Mary G. Lieberman, Florida Atlantic University

• Maria D. Vásquez-Colina, Florida Atlantic University

• John D. Morris, Florida Atlantic University