QXLA: Adding Upper Quantiles for the Studentized Range to Excel for Multiple Comparison Procedures

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 addin 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 workbook example, demonstrating the Tukey, S-N-K, and REGWQ tests, has also been included. Compared with other options available, the method is fast with low error rates.

Keywords

• Microsoft Excel
• VisualBasics
• VBA
• add-in
• studentized range Q-distribution