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.
Mendeley helps you to discover research relevant for your work.
CITATION STYLE
Klasson, K. T. (2018). QXLA: adding upper quantiles for the studentized range to excel for multiple comparison procedures. Journal of Statistical Software, 85. https://doi.org/10.18637/jss.v085.c01