Author(s)

William Laverty^1*, Ivan Kelly²

¹Department of Mathematics and Statistics, University of Saskatchewan, Saskatoon, Canada.
²Professor Emeritus, Department of Educational Psychology & Special Education, University of Saskatchewan, Saskatoon, Canada.

To understand any statistical tool requires not only an understanding of the relevant computational procedures but also an awareness of the assumptions upon which the procedures are based, and the effects of violations of these assumptions. In our earlier articles (Laverty, Miket, & Kelly [1]) and (Laverty & Kelly, [2] [3]) we used Microsoft Excel to simulate both a Hidden Markov model and heteroskedastic models showing different realizations of these models and the performance of the techniques for identifying the underlying hidden states using simulated data. The advantage of using Excel is that the simulations are regenerated when the spreadsheet is recalculated allowing the user to observe the performance of the statistical technique under different realizations of the data. In this article we will show how to use Excel to generate data from a one-way ANOVA (Analysis of Variance) model and how the statistical methods behave both when the fundamental assumptions of the model hold and when these assumptions are violated. The purpose of this article is to provide tools for individuals to gain an intuitive understanding of these violations using this readily available program.

Excel, One-Way ANOVA, Assumption Violations, t-Distribution, Cauchy Distribution

Laverty, W. and Kelly, I. (2019) Using Excel to Explore the Effects of Assumption Violations on One-Way Analysis of Variance (ANOVA) Statistical Procedures. Open Journal of Statistics, 9, 458-469. doi: 10.4236/ojs.2019.94031.