DATA GENERATION AND ANALYSIS USING SPREADSHEETS

Modern spreadsheets are powerful and useful tools that can often replace special-purpose programs for generating data and for student analysis of simple statistical problems. The inherent flexibility of spreadsheets makes them especially convenient and extensible. Several templates for generating and analyzing data for t tests and analysis of variance are discussed. Users can specify the n, XBAR, and SD of two or more groups and then execute macros that generate appropriate data. Overwriting the generated data with "real" values turns the spreadsheet into a data analysis program. Spreadsheets hold promise as valuable instructional supplements for simple designs, but they are less suitable for more complex designs, where special-purpose programs may be more appropriate.