Spreadsheets statistics for teaching and production


Book: 
Proceedings of the Third International Conference on Teaching Statistics
Authors: 
Murphy, B., Bartlett, G. A., Klobas, J., & Keady, G.
Editors: 
Vere-Jones, D., Carlyle, S., & Dawkins, B. P.
Category: 
Volume: 
2
Pages: 
228-233
Year: 
1991
Publisher: 
International Statistical Institute
Place: 
Voorburg, Netherlands
Abstract: 

We have found spreadsheets very useful for teaching statistics, operations research, and other quantitative methods in commerce: students learn quickly when typing and debugging formulae and macros, and get a real feeling for the relation between computation and theory. However, after a while, it is necessary to turn to a more traditional statistical package to find both standard and advanced procedures needed for real-world data examination. WESTAT Associates has developed the MASS system for some years, a stand-alone statistical package of some size and power, and we have used it extensively for teaching, at second course but not at introductory level. In the past six months we (1.5 persons) have ported it to sit on the new spreadsheet WingZ (by Informix Inc) on the Mac to form a new program StatZ, which combines the advantages of a spreadsheet and a specialised program for the teaching and practice of statistics. (See Section 3(ii) for other computers.) Porting a program from one language or machine or system to another is usually a painful exercise. However, the power and flexibility of the "scripting" and of the facilities for linking external code provided by WingZ and its HyperScript macro language, which we have used for incorporating our MASS code into their highly commercial, well-tested base product, seems destined to have a profound effect on related areas of program development. This will yield new research and teaching software, as already pioneered by Apple's HyperCard, the technical precursor of WingZ's HyperScript.

The CAUSE Research Group is supported in part by a member initiative grant from the American Statistical Association’s Section on Statistics and Data Science Education