Skip to main content
ARS Home » Southeast Area » New Orleans, Louisiana » Southern Regional Research Center » Commodity Utilization Research » Research » Publications at this Location » Publication #330982
Research Project: Increasing the Value of Cottonseed

Location: Commodity Utilization Research

Title: QXLA: Adding upper quantiles for the studentized range to Excel for multiple comparison procedures

Author
item Klasson, K Thomas

Submitted to: Journal of Statistical Software
Publication Type: Peer Reviewed Journal
Publication Acceptance Date: 12/1/2017
Publication Date: 6/9/2018
Citation: Klasson, K.T. 2018. QXLA: Adding upper quantiles for the studentized range to Excel for multiple comparison procedures. Journal of Statistical Software. Journal of Statistical Software, Code Snippets. Vol(85):1-9.

Interpretive Summary: Microsoft Excel can do basic statistics but it cannot do things that have to do with studentized range. That information must be entered by the user. This document describes a method to add the capability of studentized range distributions to Excel. A spreadsheet example, demonstrating the use has also been included. The method is fast, compared with other options available, with low error rates.

Technical Abstract: Microsoft Excel has some functionality in terms of basic statistics; however it lacks distribution functions built around the studentized range (Q). The developed Excel add-in introduces two new user-defined functions, QDISTG and QINVG, based on the studentized range Q-distribution that expands the functionality of Excel for statistical analysis. A spreadsheet example, demonstrating the Tukey, S-N-K, and REGWQ tests, has also been included. The method is fast, compared with other options available, with low error rates.