eduzhai > Physical Sciences > Physics Sciences >

Using Excel to Explore the Effects of Assumption Violations on One-Way Analysis of Variance (ANOVA) Statistical Procedures

  • Save

... pages left unread,continue reading

Document pages: 12 pages

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

Please select stars to rate!


0 comments Sign in to leave a comment.

    Data loading, please wait...