{'fraction_non_alphanumeric': 0.020239880059970013, 'fraction_numerical': 0.0022488755622188904, 'mean_word_length': 4.933333333333334, 'pattern_counts': {'":': 0, '<': 0, '<?xml version=': 0, '>': 0, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
Using Excel to Explore the Effects of Assumption Violations on One-Way Analysis of Variance (ANOVA) Statistical Procedures

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.