Teaching Excel the General Linear Model for Student Access and Accuracy

• In Event: Linear Modeling: Methodology and Applications

Abstract

Due to the inaccessibility of university labs during the Pandemic, we created a powerful Excel program that performs most General Linear Model analyses, allowing delivery of a statistical methods course, beginning or more advanced, with Excel. All students are comfortable with and have immediate access to Excel. We also took this opportunity to embed contextual guidance toward correct understanding of analyses and to note where commercial packages err. To promote use of quantitative methods, all relevant output is automatically generated in “camera-ready” APA copy-and-paste tables. We continue to develop the software and find that students gain more from it than the commercial package we introduce. We offer its availability, our experiences, and a student evaluation here.

Authors

• John D. Morris, Florida Atlantic University

• Mary G. Lieberman, Florida Atlantic University