Skip to main content
ARS Home » Southeast Area » New Orleans, Louisiana » Southern Regional Research Center » Commodity Utilization Research » Research » Publications at this Location » Publication #348732
Title: Two-way ANOVA for unbalanced data: The spreadsheet way

Author
item Klasson, K Thomas

Submitted to: USDA-ARS Research Notes
Publication Type: Research Notes
Publication Acceptance Date: 6/5/2019
Publication Date: 6/5/2019
Citation: Klasson, K.T. 2019. Two-way ANOVA for unbalanced data: The spreadsheet way [Technical Report]. New Orleans, LA: USDA, Agricultural Research Service, Southern Regional Research Center. 14 p. https://www.ars.usda.gov/ARSUserFiles/60540520/Two-wayANOVAspreadsheet.pdf

Interpretive Summary: Understanding two-way Analysis of Variance (ANOVA) with unbalanced data is challenging and is often dismissed and handed over to dedicated statistical software program without knowing how the data is handled by those programs. This paper allows students, instructors, and researchers to use Excel spreadsheets to explore two-way ANOVA scenarios with unbalanced data.

Technical Abstract: Understanding two-way Analysis of Variance (ANOVA) with unbalanced data is challenging and is often dismissed and handed over to dedicated statistical software program without knowing how the data is handled by those programs. This paper allows students, instructors, and researchers to use Excel spreadsheets to explore two-way ANOVA scenarios with unbalanced data.