Skip to main content
ARS Home » Southeast Area » New Orleans, Louisiana » Southern Regional Research Center » Commodity Utilization Research » Research » Publications at this Location » Publication #374587
Research Project: Developing Technologies that Enable Growth and Profitability in the Commercial Conversion of Sugarcane, Sweet Sorghum, and Energy Beets into Sugar, Advanced Biofuels, and bioproducts-Bridging Project

Location: Commodity Utilization Research

Title: Using Excel for dynamic analysis of variance and unplanned multiple comparisons procedures

Author
item Klasson, K Thomas

Submitted to: USDA-ARS Research Notes
Publication Type: Research Notes
Publication Acceptance Date: 5/5/2020
Publication Date: 5/5/2020
Citation: Klasson, K.T. 2020. Using Excel for dynamic analysis of variance and unplanned multiple comparisons procedures. USDA-ARS Research Notes. [TechnicalReport]. New Orleans, LA: USDA, Agricultural Research Service, Southern Regional Research Center. 10 p. https://www.ars.usda.gov/ARSUserFiles/60540520/Excel-ANOVA-UMCP.pdf

Interpretive Summary: Microsoft Excel is often used for data storage, calculations, data charting, etc. but not for complicated statistics. While some statistical functions and data analysis tools exist within the software, it is often not sufficient for most statistical evaluations. Therefore, a dynamic spreadsheet was developed that carried out standard analysis of variances evaluation and post hoc tests using unplanned multiple comparisons procedures (UMCPs). It was done by minimal programming, utilizing the existing functions of Excel, so that it can also be used as a teaching tool for UMCPs. The spreadsheet is dynamic and is updated automatically as existing raw data are revised or new data are entered. The spreadsheet is useful for all agricultural experimentalists who evaluate the impact on subjects receiving different treatments.

Technical Abstract: Microsoft Excel is often used for data storage, calculations, data charting, etc. but not for complicated statistics. While some statistical functions and data analysis tools exist within the software, it is often not sufficient for most statistical evaluations. Therefore, a dynamic spreadsheet was developed that carried out standard analysis of variances evaluation and post hoc tests using unplanned multiple comparisons procedures (UMCPs). It was done by minimal programming, utilizing the existing functions of Excel, so that it can also be used as a teaching tool for UMCPs. The spreadsheet is dynamic and is updated automatically as existing raw data are revised or new data are entered. The spreadsheet is useful for all agricultural experimentalists who evaluate the impact on subjects receiving different treatments.