Published by the Foundation for Open Access Statistics
Editors-in-chief: Bettina Grün, Torsten Hothorn, Edzer Pebesma, Achim Zeileis    ISSN 1548-7660; CODEN JSSOBK
QXLA: Adding Upper Quantiles for the Studentized Range to Excel for Multiple Comparison Procedures | Klasson | Journal of Statistical Software
Authors: K. Thomas Klasson
Title: 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.

Page views:: 1276. Submitted: 2016-07-15. Published: 2018-06-09.
Paper: QXLA: Adding Upper Quantiles for the Studentized Range to Excel for Multiple Comparison Procedures     Download PDF (Downloads: 531)
Supplements:
QXLA5.1.xla: Excell add-in Download (Downloads: 48; 98KB)
v85c01-replication.zip: Source code and replication materials Download (Downloads: 28; 193KB)

DOI: 10.18637/jss.v085.c01

by
This work is licensed under the licenses
Paper: Creative Commons Attribution 3.0 Unported License
Code: GNU General Public License (at least one of version 2 or version 3) or a GPL-compatible license.