Teaching Statistics by Spreadsheet: A Developmental Approach

Abstract

One of the greatest difficulties in teaching statistics is imparting an understanding of the procedures and their uses. This analysis develops a framework for using spreadsheet software on a microcomputer to develop sophisticated statistical procedure templates that are effective in teaching statistical concepts. The analysis consists of four parts: an overview of traditional computer-based statistical applications, the development of a framework for teaching-oriented statistical applications, illustrations of the framework with an example for time series analysis, and suggestions for integrating multiple procedures in a single spreadsheet. Keywords: spreadsheet, statistical analysis, teaching, template.

Computerized Economic Modeling: From Laboratory to Classroom

“…Linear relationships (e.g., supply and demand equations) could be analyzed with these programs and the difference between shifts in a curve and movements along a curve could be displayed. For examples of how spreadsheets are being used to teach economics see Brooker (1987aBrooker ( , 1987b, and for statistics see Ostrowski (1988).…”

Economics: Spreadsheets as Pedagogical Tools for Economic Statistics and Econometrics

“…Rather than using the built-in regression features suggested by judge (1990) or providing a facultydesigned spreadsheet with macros suggested by Ostrowski (1988), I helped the students build their own using a spreadsheet program. Rather than using the built-in regression features suggested by judge (1990) or providing a facultydesigned spreadsheet with macros suggested by Ostrowski (1988), I helped the students build their own using a spreadsheet program.…”