Student and researchers are often introduced to Analysis of Variance (ANOVA) Statistics by first studying one-way ANOVA examples.  They then move on to factorial ANOVA statistics, for example two-way ANOVA, but often this is limited to balanced data.  Balanced data are when the number of data values for each of the category (or group) is the same.  When this is the case, the calculations are simple to do and the equations can easily be written to allow for each of the values needed to construct an ANOVA table and compare means.  When unbalanced data are encountered, which is often the case in agricultural field studies, the data are often entered into a statistical program such as SAS.  The results reported without much thought to the process and procedures that are used, which may vary between statistical software.  In this presentation we will show how dynamic spreadsheets can be constructed to produce ANOVA tables and compare means of groups and compare means of groups of groups.

ANOVA for unbalanced data: Using spreadsheets to evaluate sums of squares and comparisons of means

255th National Meeting (2018)

The official archive and repository for all ACS Meetings & Expositions abstracts and select posters or presentations.