A new procedure using a student-friendly least-squares multiple linear-regression technique utilizing a function within Microsoft Excel is described that enables students to calculate molecular constants from the vibronic spectrum of iodine. This method is advantageous pedagogically as it calculates molecular constants for ground and excited…

When the author first used "VisiCalc," the author thought it a very useful tool when he had the formulas. But how could he design a spreadsheet if there was no known formula for the quantities he was trying to predict? A few months later, the author relates he learned to use multiple linear regression software and suddenly it all clicked into…

Described is a method for discriminant analysis which uses the multiple regression facilities offered by many microcomputer statistical packages. This method is illustrated with an ecological example using the MICROTAB statistical package on a BBC microcomputer. Compares these results with an analysis of the same data using SPSS X. (Author/CW)

The study provides: (1) a rationale for using microcomputer spreadsheet programs as teaching tools in applied statistics courses; (2) examples of one spreadsheet template--Analysis of Variance; (3) corresponding workbook exercises for the ANOVA template; and (4) results and discussion of how the exercises are used in an introductory statistics…