Skip to main content
ARS Home » Southeast Area » New Orleans, Louisiana » Southern Regional Research Center » Commodity Utilization Research » Research » Publications at this Location » Publication #348749
Title: A simple but accurate Excel user-defined function to calculate studentized range quantiles for Tukey tests

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. A simple but accurate Excel user-defined function to calculate studentized range quantiles for Tukey tests [Technical Report]. New Orleans, LA: USDA, Agricultural Research Service, Southern Regional Research Center. 11 p. https://www.ars.usda.gov/ARSUserFiles/60540520/RapidCalculationOfQ.pdf

Interpretive Summary: An accurate, fast, and easily implemented user-defined function was developed for calculation of Studentized range quantiles. Having these quantiles (Q) available in Excel is an advantage as it is easy to perform comparisons of means in post hoc tests as part of analysis of variance. The developed procedure was about 200 times faster than other accurate Excel methods available and provided very low error rates over a wide range of probabilities.

Technical Abstract: An accurate, fast, and easily implemented user-defined function was developed for calculation of Studentized range quantiles. Having these quantiles (Q) available in Excel is an advantage as it is easy to perform comparisons of means in post hoc tests as part of analysis of variance. The developed procedure was about 200 times faster than other accurate Excel methods available and provided very low error rates over a wide range of probabilities.