Finding P-Values for F Tests of Hypothesis on a Spreadsheet.

The calculation of the F statistic for a one-factor analysis of variance (ANOVA) and the construction of an ANOVA tables are easily implemented on a spreadsheet. This paper describes how to compute the p-value (observed significance level) for a particular F statistic on a spreadsheet. Decision making on a spreadsheet and applications to the classroom are also discussed for Lotus 1-2-3 for DOS or for Windows. Spreadsheets enable the learner to see what is calculated and how results are obtained, and they allow the user to automate statistical decisions. Spreadsheet use is particularly useful for students in that it creates conditions in which: (1) fundamental concepts and their meanings must be understood; (2) calculations can be automated; (3) meanings of the concepts are enhanced; (4) technology interference is minimal; (5) many examples can be studied; (6) decision making becomes the focus of learning hypothesis testing; (7) decisions about hypothesis testing can be made in different ways; and (8) changing the values on a worksheet recalculates the entire worksheet with results adjusted automatically. An appendix discusses a particular function of the Lotus 1-2-3 software for Windows. (Contains three tables and seven references.) (SLD)