A Spreadsheet Tool for Learning the Multiple Regression F-test, t-tests, and Multicollinearity

This note presents a spreadsheet tool that allows teachers the opportunity to guide students towards answering on their own questions related to the multiple regression F-test, the t-tests, and multicollinearity. The note demonstrates approaches for using the spreadsheet that might be appropriate for three different levels of statistics classes, so teachers can select the context that is most appropriate for their particular needs. The spreadsheet tool is linked to this article, and materials are provided in the appendices for teachers to use as handouts, homework questions, and answer keys.